hard20 pts · first answer countsindexingmvcc
Index-only scan still reads the table
EXPLAIN ANALYZE shows "Index Only Scan ... Heap Fetches: 4800000" on a big, frequently updated table. Why, and what helps?
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Composite index column orderDatabase Administrator
- Why PostgreSQL needs VACUUMDatabase Administrator
- Covering indexDatabase Administrator
- Slow deep paginationDatabase Administrator
- Adding an index on a live tableDatabase Administrator
- Deleting a customer takes secondsDatabase Administrator
- Disk not freed after a big deleteDatabase Administrator