20,000 Times Faster Order By Limit | Scaling Postgres 366

In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times faster query by fixing an order by limit issue.

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/366-20k-faster-order-by-limit/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

Scaling Postgres

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

• No. of episodes: 367
• Latest episode: 2025-05-25
• Technology

Where can you listen?