SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres)
Published April 24, 2021
Views 80.1K | Likes 2.26K | Comments 163
At a glance
Views
80,159
Likes
2,269
Comments
163
Performance vs. channel
Outlier score
Engagement rate
More features coming
We're working on new analytics and tools. Stay tuned.
About
Get my database course https://database.husseinnasser.com In this video, I'll show how we can use the database query planner to estimate the count with the table statistics and gain enormous performance. I'm going to use Postgres as my database and express node js as my backend. Source Code https://github.com/hna…
- Published
- April 24, 2021
- Made for kids
- No
More features coming
We're working on new analytics and tools. Stay tuned.