LIMIT vs Performance

Postgres FM

Inhoud geleverd door Michael Christofides and Nikolay Samokhvalov. Alle podcastinhoud, inclusief afleveringen, afbeeldingen en podcastbeschrijvingen, wordt rechtstreeks geüpload en geleverd door Michael Christofides and Nikolay Samokhvalov of hun podcastplatformpartner. Als u denkt dat iemand uw auteursrechtelijk beschermde werk zonder uw toestemming gebruikt, kunt u het hier beschreven proces https://nl.player.fm/legal volgen.

1+ y ago 45:23

MP3•Thuis aflevering

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 afleveringen

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