Re: How much log space does VACUUM need?

In article <7843(dot)986599087(at)sss(dot)pgh(dot)pa(dot)us>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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