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