In article <7843.986599087@sss.pgh.pa.us>, "Tom Lane" <tgl@sss.pgh.pa.us>
wrote:
> Not sure if that should be construed as a bug or not; Vadim will have to
> answer that. But here's a thought: try increasing CHECKPOINT_TIMEOUT
> and/or CHECKPOINT_SEGMENTS so that you don't get intermediate
> checkpoints while the vacuum proceeds. Should reduce the thing's
> appetite for log space ...
Thanks Tom. I didn't get to do anything with this until
today -- the power supply on that box fried (at least
the 12V side did), during a COPY. I'm running ext2 as
the filesystem and even so, things came right up after
I fixed the box. So, I'm happy with PostgreSQL's recovery
ability! It's WAL worth the effort you put into it.
Sorry, it just came to me and I typed before I thought...
Gordon.
--
It doesn't get any easier, you just go faster.
-- Greg LeMond