On Wed, Apr 30, 2014 at 10:40 AM, Elanchezhiyan Elango
<elanela...@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...@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to