| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Phillip Berry" <pberry(at)stellaconcepts(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Startup process thrashing |
| Date: | 2008-12-11 18:20:00 |
| Message-ID: | 9699.1229019600@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 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?
> Don't forget that the OP mentioned earlier that he had very long help
> open connections with possible long help open transactions.
Open transactions don't prevent checkpoints and thus not WAL truncation
either. You're confusing this with vacuuming.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TiTo® | 2008-12-11 18:20:14 | Schemas and Privileges |
| Previous Message | Joshua D. Drake | 2008-12-11 17:52:12 | Re: Data Replication |