LIMIT vs Performance

Postgres FM

内容由Michael Christofides and Nikolay Samokhvalov提供。所有播客内容（包括剧集、图形和播客描述）均由 Michael Christofides and Nikolay Samokhvalov 或其播客平台合作伙伴直接上传和提供。如果您认为有人在未经您许可的情况下使用您的受版权保护的作品，您可以按照此处概述的流程进行操作https://zh.player.fm/legal。

1+ y ago 45:23

MP3•单集首页

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

166集单集

#Tech #News #Tech News #Michael Christofides #Nikolay Samokhvalov #Postgres #PostgreSQL #Database #SQL #Technology