Re: How much log space does VACUUM need? - Mailing list pgsql-general

From Tom Lane
Subject Re: How much log space does VACUUM need?
Date
Msg-id 7843.986599087@sss.pgh.pa.us
Whole thread Raw
In response to How much log space does VACUUM need?  ("Gordon A. Runkle" <gar@integrated-dynamics.com>)
List pgsql-general
"Gordon A. Runkle" <gar@integrated-dynamics.com> writes:
> Yet, when running VACUUM ANALYZE on this table, I run out of
> space.

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 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: monetary data type
Next
From: Marc Wrubleski
Date:
Subject: update tables in remote db using trigger