3 ms·
"The first test I ran while working on reducing the memory consumption of sort improved performance by 371%" This is impressive in terms of performance for SQL
by nitinreddy88 4y ago
"The first test I ran while working on reducing the memory consumption of sort improved performance by 371%"
This is impressive in terms of performance for SQL Server operations.
Imagine the end performance benefits for analytical/warehouse model of queries.
- 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.