Running 10 Million PostgreSQL Indexes In Production (And Counting) (2016)
Database 101 tells us that we need to use index to speed the query to avoid full table scan over all our data. However, we should not overuse them because it will affect INSERT performance and requires more memory. Hence, we need to be balance on what to index and how. In this post, Heap analytic writes about how they manage to speed up query with over 10 million indexes. It’s a good read in database engineering.
Appears in lists (1)
More like this (4)
A Look at PostgreSQL's BRIN Indexes — BRIN (Block Range Index) indexes are a powerful way...
Getting The Most Out of Your Postgres Indexes — Quick examples and tips around covering indexes,...