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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
