Re: 8.2rc1: vacuum full fills up disk space - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 8.2rc1: vacuum full fills up disk space
Date
Msg-id 4490.1164608667@sss.pgh.pa.us
Whole thread Raw
In response to 8.2rc1: vacuum full fills up disk space  ("Thomas H." <me@alternize.com>)
List pgsql-bugs
"Thomas H." <me@alternize.com> writes:
> this somehow sounds buggy:

vacuum full absolutely *will* bloat your index, if run on a
heavily-modified table.  I do not think it will bloat pg_xlog by itself
however; are you sure you don't have some other open transactions?

> a) .. prevent total diskspace fillup. what happens if i send a cancel =
> signal to the process?

Killing it should not corrupt anything; if it does that IS a serious bug
and will be met with a full alarm response...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Thomas H."
Date:
Subject: 8.2rc1: vacuum full fills up disk space
Next
From: "Thomas H."
Date:
Subject: Re: 8.2rc1: vacuum full fills up disk space