Horton

Re: [PERFORM] More detail on settings for pgavd?

Andrew Sullivan <andrew@libertyrms.info>

View thread View on postgr.es
From: Andrew Sullivan <andrew@libertyrms.info>
To: pgsql-hackers@postgresql.org
Date: 2003-11-26T04:27:46Z
Lists: pgsql-hackers, pgsql-performance 
On Fri, Nov 21, 2003 at 07:51:17PM -0500, Greg Stark wrote:
> The second vacuum waits for the lock to become available. If the
> situation got really bad there could end up being a growing queue
> of vacuums waiting.

Those of us who have run into this know that "the situation got
really bad" is earlier than one might think.  And it can indeed cause
some pretty pathological behaviour.

A


-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110