Carpe diem! The Call-for-Proposals (CFP) for our new, free, & virtual developer event is open until Feb 6th. Learn more in the CFP for Citus Con: An Event for Postgres.
Everybody counts, but not always quickly. This article is a close look into how PostgreSQL optimizes counting. If you know the tricks there are ways to count rows orders of magnitude faster than you do already.
The problem is actually underdescribed...Keep reading