all AI news
LIMIT vs Performance
May 3, 2024, 1 p.m. | Nikolay Samokhvalov and Michael Christofides
Postgres FM postgres.fm
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 …
More from postgres.fm / Postgres FM
Jobs in AI, ML, Big Data
Data Engineer
@ Michelin | Pune
Senior Research Analyst, Global Analytics & Measurement
@ NBCUniversal | London, United Kingdom
Research Scientist
@ Meta | Menlo Park, CA
NLP Speech Research Intern
@ Tencent | UK-London
Junior Senior Reliability Engineer
@ NielsenIQ | Bogotá, Colombia
[Job - 15712] Vaga Afirmativa para Mulheres - QA (Automation), SR
@ CI&T | Brazil