| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Greg Smith <gsmith(at)gregsmith(dot)com> |
| Cc: | Phillip Berry <pberry(at)stellaconcepts(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Startup process thrashing |
| Date: | 2008-12-11 16:59:42 |
| Message-ID: | 8935.1229014782@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> On Thu, 11 Dec 2008, Phillip Berry wrote:
>> I'm not running PITR and checkpoint_segments is set to 100 as this is
>> home to a very write intensive app.
> That's weird then. It shouldn't ever keep around more than 201 WAL
> segments. I've heard one report of a similarly mysterious excess of them,
> from Robert Treat, but that was probably caused by a hardware failure.
AFAIK the only non-PITR reason for WAL files to not get recycled is if
checkpoints were failing. Do you still have the postmaster log from
before the original crash, and if so is there anything in there about
checkpoint failures?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-12-11 17:09:06 | Re: Startup process thrashing |
| Previous Message | Andrew Sullivan | 2008-12-11 16:12:41 | Re: Data Replication |