Krowa Krowax <krowa333@xxxxxxxxx> wrote: > Why vacuum full stops responding? :( If you give it enough time (which is hard to predict and possibly more time than you want to allow), it will probably finish, eventually. It is, however, almost never needed or desirable to use VACUUM FULL. I recommend you just use VACUUM ANALYZE (possibly with VERBOSE). If the table is bloated enough to warrant trying to reclaim space, do you have room for an extra copy of it? If so, try using CLUSTER, followed by VACUUM ANALYZE, instead of VACUUM FULL. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
