Re: Vacuum goes worse

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <stephane.schildknecht@xxxxxxxxxxxxxxxx> writes:
> Tom Lane a écrit :
>> The real question is how often do rows get updated?  I suspect you
>> probably need to vacuum this table more than once a day.

> To be honest, I suspect it too. But, I have been told by people using
> that database they can't do vacuum more frequently than once in a day as
> it increases the time to achieve concurrent operations.

vacuum_cost_delay can help here.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux