4 ms·
> SQL Server operations I might me misunderstanding you, but this is a post about PostgreSQL, not Microsoft's SQL Server. > performance benefits for analytica
by mattashii 4y ago
> SQL Server operations
I might me misunderstanding you, but this is a post about PostgreSQL, not Microsoft's SQL Server.
> performance benefits for analytical/warehouse model
That performance result was for a fully in-memory sort operation, which you are are less likely to see in data warehouses.
- dspillett 4y ago> but this is a post about PostgreSQL, not Microsoft's SQL Server. I assume that what was meant is what I'd say as “SQL engine” or “SQL query runner”. It is unfortunate that MS has a habit of using common words in its product names. PG is a SQL server (no capital) in the sense that it is a server that processes SQL statements for retrieving and manipulating data.