Krowa Krowax <krowa333(at)gmail(dot)com> 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