PostgreSQL MindMap

Get Started. It's Free
or sign up with your email address
Rocket clouds
PostgreSQL by Mind Map: PostgreSQL

1. Autovacuum

1.1. Parameters

1.1.1. maintenance_work_mem determines how much memory that you allocate for autovacuum to use to scan a database table and to hold all the row IDs that are going to be vacuumed Work in conjuntion with autovacuum_max_workers Many small tables, increase autovacuum_max_workers and less maintenance_work_mem Large table (>100GB)

1.1.2. autovacuum_max_workers