medium10 pts · first answer countspostgresqlvacuum
Vacuuming one hot table more often
One 50 crore row events table builds up huge bloat between autovacuum runs, but other tables are fine. What is the targeted fix?
Discussion 0
Join free to post in the discussion.
Related questions
- 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
- Gaps in auto-increment IDsDatabase Administrator