5mins of Postgres E19: Speeding up sort performance in Postgres 15
Today, we're going to talk about four specific improvements made in Postgres 15 that help speeding up sort performance:
1. Sorting a single column
2. Reducing memory consumption by using a different memory allocator
3. New specialized sort routines for common data types
4. Replacing the algorithm that's used for splitting up sorts to disk when they exceed the "work_mem".
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
Speeding up sort performance in Postgres 15 - by David Rowley: https://techcommunity.microsoft.com/t...
David Rowley on Twitter: / davidrowley_pg
Download Postgres 15 beta1 release: https://www.postgresql.org/about/news...
PGCon 2022: https://www.pgcon.org/2022/
PGCON on Twitter: / pgcon