Speeding up partial COUNT(*) in Postgres by using LIMIT in a subquery
Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...
In episode 103 of “5mins of Postgres”, we look at optimizing the performance of COUNT statements when only a subset of the data needs to be counted, through use of a LIMIT in a sub-SELECT. We also discuss how this can be represented effectively in a web application.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
An Efficient Way to Check for Existence of Multiple Values in SQL - Blog post by Lukas Eder
https://blog.jooq.org/an-efficient-wa...