Autovacuum Tuning advice
От | Plugge, Joe R. |
---|---|
Тема | Autovacuum Tuning advice |
Дата | |
Msg-id | E2160D87-855A-49E9-8704-D6389A76C2F3@mimectl обсуждение исходный текст |
Ответ на | Re: Hunting Unused Indexes .. is it this simple ? (Andy Colson <andy@squeakycode.net>) |
Ответы |
Re: Autovacuum Tuning advice
Re: Autovacuum Tuning advice |
Список | pgsql-performance |
I have a very busy system that takes about 9 million inserts per day and each record gets updated at least once after theinsert (all for the one same table), there are other tables that get hit but not as severely. As suspected I am havinga problem with table bloat. Any advice on how to be more aggressive with autovacuum? I am using 8.4.1. My machinehas 4 Intel Xeon 3000 MHz Processors with 8 GB of Ram. Currently I am using only defaults for autovac. shared_buffers = 768MB # min 128kB work_mem = 1MB # min 64kB maintenance_work_mem = 384MB #------------------------------------------------------------------------------ # AUTOVACUUM PARAMETERS #------------------------------------------------------------------------------ #autovacuum = on #log_autovacuum_min_duration = -1 #autovacuum_max_workers = 3 #autovacuum_naptime = 1min #autovacuum_vacuum_threshold = 50 #autovacuum_analyze_threshold = 50 #autovacuum_vacuum_scale_factor = 0.2 #autovacuum_analyze_scale_factor = 0.1 #autovacuum_freeze_max_age = 200000000 #autovacuum_vacuum_cost_delay = 20ms #autovacuum_vacuum_cost_limit = -1
В списке pgsql-performance по дате отправления: