Solving Postgres' Count Problem
An article on Hacker News examines the inefficiencies of using COUNT(*) in PostgreSQL databases, particularly when scanning large tables. It outlines several approaches to mitigate the performance impact, including using approximate counting extensions, maintaining summary tables, and leveraging index‑only scans. The piece provides code examples and benchmarks to illustrate how each method can reduce query latency.