Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: 8.2rc1: vacuum full fills up disk space



"Thomas H." <me(at)alternize(dot)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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group