Re: finding out vacuum completion %, and vacuum VS vacuum full

From: Decibel! <decibel(at)decibel(dot)org>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: finding out vacuum completion %, and vacuum VS vacuum full
Date: 2007-08-07 22:58:00
Message-ID: 20070807225800.GZ25704@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 07, 2007 at 08:40:47AM -0700, Steve Atkins wrote:
> If you have adequate disk space free (enough to hold another
> copy of the new table) and the table has an index on it, then
> CLUSTER the table.

Be advised that there's some MVCC issues with CLUSTER in current
versions, but normally you'd only run into them in a serialized
transaction. If you're not using that you're probably fine, but remember
that pg_dump and pg_dumpall use serialized transactions.
--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Decibel! 2007-08-07 22:59:20 Re: Intelligent Database in postgreSQL
Previous Message Ragnar 2007-08-07 22:57:50 Re: create table liek view