Tino Schwarze wrote: > I remember several people (including myself) who used VACUUM FULL as a > last resort when their database was bloated and they run out of disk > space. But this seems to be moot, anyway, so it's probably better not to > offer something that might or might not work in such a situation (and > takes loooong) but tell them straight: "You need lots of disk space or > you need to dump/drop/restore your database". I guess this was an easier mistake to make back when autovacuum was newer or inexistant. Nowadays, you install a 8.3 cluster, you already got some protection. And in 8.4 with the dead space map it will be even more difficult. Not saying it'll be impossible to get in that situation, but should be rare enough that we can suggest other workarounds when need arises. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
