Tagged performance

One entry carries the tag performance, newest first. All tags.

• PostgreSQL or SQL Server - how do they differ, and when is migrating from one to the other worth it?

  howto · sql · sql · databases · postgresql · sql-server · migration · data-types · performance · licensing · Nov 3, 2026

  Neither is faster in general. Move to PostgreSQL to drop per-core licences, run on any host and gain its types and extensions. Move to SQL Server for the Microsoft data stack, columnstore analytics, or a vendor that certifies only it. Migrate only when that gain beats the cost, which is in the code (procedures, dialect, collation, locking), not the data.