5mins of Postgres E19: Speeding up sort performance in Postgres 15

Published: 26 May 2022
on channel: pganalyze

658

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

On this page of the site you can watch the video online 5mins of Postgres E19: Speeding up sort performance in Postgres 15 with a duration of hours minute second in good quality, which was uploaded by the user pganalyze 26 May 2022, share the link with friends and acquaintances, this video has already been watched 658 times on youtube and it was liked by 23 viewers. Enjoy your viewing!