Offline dengan aplikasi Player FM !
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
119 episode
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
119 episode
ทุกตอน
×Selamat datang di Player FM!
Player FM memindai web untuk mencari podcast berkualitas tinggi untuk Anda nikmati saat ini. Ini adalah aplikasi podcast terbaik dan bekerja untuk Android, iPhone, dan web. Daftar untuk menyinkronkan langganan di seluruh perangkat.