Re: How much log space does VACUUM need?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gordon A(dot) Runkle" <gar(at)integrated-dynamics(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How much log space does VACUUM need?
Date: 2001-04-06 23:18:07
Message-ID: 7843.986599087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gordon A. Runkle" <gar(at)integrated-dynamics(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Wrubleski 2001-04-06 23:22:29 update tables in remote db using trigger
Previous Message Tom Lane 2001-04-06 22:31:15 Re: monetary data type