PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE
I was profiling a dashboard that loaded in 3 seconds. The main query filtered by customer_id and selected customer_name, email, and last_order_date. PostgreSQL found 2,000 matching rows...
postgresdba.hashnode.dev4 min read