SELECT COUNT(*) is Slow, Estimate it Instead (with Example in Node JS and Postgres) Published 2021-04-23 Download video MP4 360p Recommendations 18:19 Database Indexing Explained (with PostgreSQL) 16:06 Mastering Memory Management in Node.js: Tips and Tricks for Better Performance 01:01 select count(*) is expensive 29:04 Explaining the Postgres Query Optimizer | Citus Con: An Event for Postgres 2022 07:01 Stop using COUNT(id) to count rows 44:04 Publish-Subscribe Pattern vs Message Queues vs Request Response (Detailed Discussions with Examples) 11:36 Make your database queries 1000 times faster! 13:28 Faster database indexes (straight from the docs) 17:12 Solving one of PostgreSQL's biggest weaknesses. 29:39 Postgres, MVCC, and you or, Why COUNT(*) is slow (David Wolever) 11:16 Why create Index blocks writes 12:09 Count Millions of Rows Fast with Materialized Views: Databases for Developers: Performance #6 25:19 PostgreSQL performance tips you have never seen before | Citus Con: An Event for Postgres 2023 49:59 Sequelize ORM Tutorial (all in one video) 20:29 Avoid premature Database Sharding 31:21 PostgreSQL Indexing : How, why, and when. 05:57 Secret To Optimizing SQL Queries - Understand The SQL Execution Order Similar videos 04:03 PostgreSQL Spotting Query Problems 10/12 14:37 51 - PostgreSQL : Slow long running and blocked queries in PostgreSQL 32:39 PostgreSQL Performance - Speed Up Your System 14:09 PostgreSQL : Find the slow running queries in postgresql 01:00 Nesting "If Statements" Is Bad. Do This Instead. 02:43 Databases: PostgreSQL extremely slow counts 05:09 Databases: Postgresql extremely slow count (with index, simple query) (4 Solutions!!) 07:07 Drastically Improve Query Time From 4 seconds to 70 milliseconds (50 - 60 times faster) 00:16 Best Programming Languages #programming #coding #javascript 02:14 Databases: Optimizing performance of basic select count (*) query on large postgresql 9.6.5 table 00:34 Senior Programmers vs Junior Developers #shorts 07:24 Postgres - Understanding COUNT in PostgreSQL 06:44 Using explain analyze and pgMustard to speed up a slow query 09:10 don’t use “offset” in your SQL 16:38 Postgres + NodeJS: executing query and prepared statements 00:28 The HARDEST part about programming 🤦♂️ #code #programming #technology #tech #software #developer More results