medium10 pts · first answer countspostgresqlvacuum
When autovacuum starts on a table
A table has 10,00,000 (1 million) rows. Settings are default: autovacuum_vacuum_threshold = 50 and autovacuum_vacuum_scale_factor = 0.2. About how many dead rows trigger autovacuum?
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