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  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Autovacuum Tuning advice  (Greg Williamson <gwilliamson39@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: [HACKERS] full text search index scan query plan changed in 8.4.2?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Autovacuum Tuning advice