vacuum full alternative

From: Martin von Oertzen <maletin(at)cpan(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum full alternative
Date: 2011-02-17 14:21:48
Message-ID: AANLkTi=nFbK8u0cORZqo6M_8ZxXSUNwLOi=NB6L8W5he@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,

i'm very thankful for a new solution to the Vacuum-Full-Problem, as
it was reported in the wiki:
http://wiki.postgresql.org/wiki/VACUUM_FULL#ALTER_TABLE_.._SET_DATA_TYPE

but I have the feeling, that this command is not faster, than a cluster.

prior to 9.0 the syntax does not contain "SET DATA", so i would modify
the example:
ALTER TABLE your_table ALTER an_integer_column TYPE integer;

at the next solution i would modify the text
"The main reason you may want to use SELECT ... INTO instead of CLUSTER
is if you don't want to sort the table."
to
"The main reason you may want to use SELECT ... INTO instead of CLUSTER
is, if you want to avoid an exclusive lock."

regards, maletin.

Browse pgsql-admin by date

  From Date Subject
Next Message Webb, John 2011-02-17 18:02:33 Setting up Postgresql to use SSL
Previous Message Selva manickaraja 2011-02-17 06:15:52 Fwd: Trigger File Behaviour