Alexandre Leclerc wrote:
- 2. Could we stop VACUUM FULL and simply restart postmaster and starting a normal VACUUM even if it's slow?
This is what you want to do. VACUUM FULL is the slow way--much, much slower--and it is not needed to clean up from wraparound issues. Here's two more opinions on that: http://archives.postgresql.org/message-id/5224.1255142...@sss.pgh.pa.us
And here's some notes about why you should avoid VACUUM FULL: http://wiki.postgresql.org/wiki/VACUUM_FULL
(Note that you don't have a good CLUSTER implementation in your 8.1 server, so using that to clean up tables isn't an option)
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support g...@2ndquadrant.com www.2ndQuadrant.us -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
