| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: 7.4 Checkpoint Question |
| Date: | 2007-11-29 16:02:19 |
| Message-ID: | 20071129160219.GJ6226@crankycanuck.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Nov 29, 2007 at 10:10:54AM -0500, Brad Nicholson wrote:
> This is a _really _low volume system, less than 500 writes/hour. Normal
> operation sees checkpoint related spikes of around 200-300 milliseconds.
> We always checkpoint at the checkpoint timeout (every 5 minutes).
> During this one checkpoint, I'm seeing transactions running 2-3 seconds.
> During this time, writes are < 5/minute.
> What gives?
pg_dump? Remember that it has special locks approximately equivalent
(actually eq? I forget) with SERIALIZABLE mode, which makes things rather
different.
A
--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-11-29 16:14:21 | Re: 7.4 Checkpoint Question |
| Previous Message | Tom Lane | 2007-11-29 15:45:31 | Re: TB-sized databases |