Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuum_cost_delay and autovacuum_cost_delay - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: vacuum_cost_delay and autovacuum_cost_delay
Date
Msg-id CAL_0b1tWyMC0qXd343P9AJiZUn--nPKzGdYJT+p3jhsV7yDOEA@mail.gmail.com
Whole thread Raw
In response to vacuum_cost_delay and autovacuum_cost_delay  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
List pgsql-general
Tree view 
On Tue, Jun 4, 2013 at 5:06 PM, ascot.moss@gmail.com
<ascot.moss@gmail.com> 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@postgresql.org)
> 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@gmail.com

pgsql-general by date:

Previous
From: "ascot.moss@gmail.com"
Date:
Subject: vacuum_cost_delay and autovacuum_cost_delay
Next
From: 任洪彩
Date:
Subject: Re: How to modify dump files created by pg_dump