Sorting in Postgres 15 is 371% faster in certain cases

episode

The Backend Engineering Show with Hussein Nasser not yet transcribed

▲ 0

Transcript

This episode hasn't been transcribed yet Upvotes decide what gets transcribed next — 0 so far. Sign in to upvote

Related

recent transcribed audio

NPR News: 09-29-2026 7AM EDT 4 min · 29 Sep 2026 · NPR News Now

7AM ET 09/29/2026 Newscast 3 min · 29 Sep 2026 · Fox News Hourly Update

Most replayed moment: The hidden dangers of hearing loss | Prof. Marcelo Rivolta 8 min · 29 Sep 2026 · ZOE Science & Nutrition

Overmedicated To Death: Former FDA Officer on Presley Gerber & The Psychiatric Crisis in America w/ Dr. Mary Talley Bowden, Dr. Josef Witt-Doerring & Ronald Owens Jr. – Ask Dr. Drew – Ep 670 1h 19m · 29 Sep 2026 · Ask Dr. Drew

Federal boost for Navitas 6 min · 29 Sep 2026 · Wall Street Breakfast

SpaceX Starship Finally Reached Orbit & Why Dudes Are Becoming Cat Dads 29 min · 29 Sep 2026 · Morning Brew Daily

Report any issue

Source

Recorded01 Jun 2022

Publisheranchor.fm ↗

Handlerec:9885838

Show notes

Fantastic gains in Postgres 15! improved sorting by 371%. Normally you can avoid sorting by using an index access path. However, you can’t always have an index on every group by, order by, join or distinct predict. This will come handy. Let us discuss Resources https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-15-Faster-Sort https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/speeding-up-sort-performance-in-postgres-15/ba-p/3396953#change3 https://www.postgresql.org/docs/15/release-15.html#id-1.11.6.5.4 https://techcommunity.microsoft.com/t5/sql-server-blog/understanding-sql-server-fast-forward-server-cursors/ba-p/383556

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Sign in