| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] More detail on settings for pgavd? |
| Date: | 2003-11-26 04:27:46 |
| Message-ID: | 20031126042746.GB23015@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Dostatni | 2003-11-26 04:37:52 | Re: Size on Disk |
| Previous Message | Andrew Sullivan | 2003-11-26 04:25:34 | Re: Release cycle length |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-11-26 06:06:34 | Re: Optimize |
| Previous Message | Tom Lane | 2003-11-26 00:37:18 | Re: Impossibly slow DELETEs |