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