8.2rc1: vacuum full fills up disk space

From: "Thomas H(dot)" <me(at)alternize(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: 8.2rc1: vacuum full fills up disk space
Date: 2006-11-27 05:34:57
Message-ID: 0d1b01c711e5$c6fef890$0201a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

this somehow sounds buggy:

there's this table forum.posts which had 224mb table size, 145mb toast table size and 176mb indexes size (aproximately 60'000 rows). as i was doing some updates of all the records, i've issued a VACUUM FULL <tablename>...

this was merely 60min ago, and it hasn't yet finished... instead in pg_xlog there are now 380+ files, totalling in over 6gb. available disk space is almost used up...

the table was freshly loaded yestertday when reloading for rc1.

as the process of vacuuming is still ongoing, is there something i can do to...
a) .. prevent total diskspace fillup. what happens if i send a cancel signal to the process?
b) .. gather some "evidence" if needed?
c) .. check if the vacuum process is still alive?
d) .. give the process in question a higher priority so it would finish sooner?

thanks,
thomas

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-11-27 06:24:27 Re: 8.2rc1: vacuum full fills up disk space
Previous Message Zdenek Kotala 2006-11-26 16:58:37 Re: PostgreSQL 8.1.5: regression tests fail on sparc