David Ondrejik <David.Ondrejik@xxxxxxxx> wrote: > So I had to kill my process, recover disk space and get the > machine back in working condition for the weekend. I guess I will > attempt to do the full vacuum again next week. Why do you think that you need a VACUUM FULL? That is only needed as an extreme measure in rather unusual circumstances. We run hundreds of PostgreSQL databases, and have not used VACUUM FULL for years. On the other hand, we VACUUM ANALYZE most databases in their entirety every night. (Be very careful not to confuse VACUUM FULL with vacuum of an entire database.) On the other hand, the failed attempt at VACUUM FULL may have bloated your indexes, so you might want to REINDEX the table next week, followed by a VACUUM ANALYZE (without the FULL). -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
