On Tue, Jun 4, 2013 at 5:06 PM, ascot.moss@xxxxxxxxx <ascot.moss@xxxxxxxxx> wrote: > if I change the value of "vacuum_cost_delay", what is the impact of it on autovacuum side? If autovacuum_vacuum_cost_delay is not -1 then autovacuum will use this value, and there will be no effect of changing vacuum_cost_delay on autovacuum. However, if it is -1 than it will use the value of vacuum_cost_delay. http://www.postgresql.org/docs/9.2/static/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-COST-DELAY > > regards > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Kind regards, Sergey Konoplev PostgreSQL Consultant and DBA Profile: http://www.linkedin.com/in/grayhemp Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979 Skype: gray-hemp Jabber: gray.ru@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general