Go offline with the Player FM app!
LIMIT vs Performance
Manage episode 416226575 series 3369151
Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it can actually hurt performance(!)
Here are some links to things they mentioned:
- LIMIT considered harmful in PostgreSQL (Twitter thread by Christophe Pettus) https://twitter.com/Xof/status/1413542818673577987
- LIMIT and OFFSET (docs) https://www.postgresql.org/docs/current/queries-limit.html
- No OFFSET (by Markus Winand) https://use-the-index-luke.com/no-offset
- LIMIT clause (docs) https://www.postgresql.org/docs/current/sql-select.html#SQL-LIMIT
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
109 episodes
Manage episode 416226575 series 3369151
Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it can actually hurt performance(!)
Here are some links to things they mentioned:
- LIMIT considered harmful in PostgreSQL (Twitter thread by Christophe Pettus) https://twitter.com/Xof/status/1413542818673577987
- LIMIT and OFFSET (docs) https://www.postgresql.org/docs/current/queries-limit.html
- No OFFSET (by Markus Winand) https://use-the-index-luke.com/no-offset
- LIMIT clause (docs) https://www.postgresql.org/docs/current/sql-select.html#SQL-LIMIT
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
109 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.