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.