New vacuum for 7.2

From: reina(at)nsi(dot)edu (Tony Reina)
To: pgsql-admin(at)postgresql(dot)org
Subject: New vacuum for 7.2
Date: 2002-03-15 01:10:32
Message-ID: f40d3195.0203141710.69d4917e@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm a little confused about the new vacuum for 7.2. The documentation
says that the new vacuum doesn't lock the tables, but the old version
of vacuum can be invoked by using the 'full' option.

When would I need to use the old version of vacuum? It says that the
old version shrinks the on disk size by removing out-dated tuples.
Does the new version do this eventually?

Thanks.
-Tony

Browse pgsql-admin by date

  From Date Subject
Next Message Eric Scroger 2002-03-15 01:28:46 Postgres 6.4, gmake, d: command not found
Previous Message Terry Cox 2002-03-15 00:41:00 Locked out of database