=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <stephane(dot)schildknecht(at)postgresqlfr(dot)org> 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
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2007-10-16 15:38:56|
|Subject: Re: Autovacuum running out of memory |
|Previous:||From: Stéphane Schildknecht||Date: 2007-10-16 15:26:15|
|Subject: Re: Vacuum goes worse|