| From: | Phillip Berry <pberry(at)stellaconcepts(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Startup process thrashing |
| Date: | 2008-12-12 00:29:25 |
| Message-ID: | 200812121129.25584.pberry@stellaconcepts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 12 December 2008 03:59:42 Tom Lane wrote:
> 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?
No the crash happened in single user mode so their was (AFAIK) no logs of what happened outside of
the console. I've grepped all the recent logs anyway and there's no mention of checkpoint
problems.
Cheers
Phil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rusty Conover | 2008-12-12 06:58:03 | Question with combining ANY with ilike |
| Previous Message | Sun Dong | 2008-12-11 22:21:33 | how to load text file that has embeded nul character |