On Wed, Apr 30, 2014 at 10:40 AM, Elanchezhiyan Elango
<elanelango@gmail.com> wrote:
> log_autovacuum_min_duration = 0
>
> autovacuum_vacuum_scale_factor = 0
> autovacuum_vacuum_threshold = 40000
> autovacuum_analyze_scale_factor = 0
> autovacuum_analyze_threshold = 40000
I don't think it is a good idea to set scale factor and this high
threshold instance wide. You can try per table settings instead if you
want.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray.ru@gmail.com