PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries

PostgreSQL Partial Indexes: Targeted Indexing for Faster Queries I recently reviewed a database where the orders table had a 400 MB index on the status column. 95% of the rows were 'completed' -- queries never touched them. The application only ever ...