hard20 pts · first answer countspostgresqlvacuumindexing
Index-only scans slow on an insert-only table
On PostgreSQL 12, an insert-only audit table never had autovacuum run, and index-only scans keep visiting the heap. What changed in PostgreSQL 13 to address this?
Discussion 0
Join free to post in the discussion.
Related questions
- When a B-tree index helpsDatabase Administrator
- Logical vs physical backupDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- Read-only access for analystsDatabase Administrator
- What pg_hba.conf controlsDatabase Administrator
- View vs materialized viewDatabase Administrator
- Seeing what is running nowDatabase Administrator
- Cancel or terminate a sessionDatabase Administrator