Unconventional PostgreSQL Optimizations
Creative ideas for speeding up queries in PostgreSQL
Summary
Computing the count of distinct elements in massive data sets is often necessary but computationally intensive. Say you need to determine the number of distinct people visiting Facebook in the past…