Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Jakub Ouhrabka wrote:
> >> Was autovacuum requesting to write this 20MB file 650x per minute?
> > Yes, exactly.
> > Ideally, autovacuum would only request a new copy of the file if the one
> > it got was considerably out of date. Obviously a tenth of a second is
> > not old enough.
> Wasn't it you that insisted on a short staleness criterion for autovac
> in the first place?
well, my current opinion is that we should spend some nonzero amount of
thought into figuring out what to do.
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
pgsql-hackers by date
|Next:||From: Chris Browne||Date: 2010-02-16 23:13:08|
|Subject: Re: LISTEN/NOTIFY and notification timing guarantees|
|Previous:||From: Tom Lane||Date: 2010-02-16 23:05:31|
|Subject: Re: Problem with 8.4 stats collector high load |