On Tue, Oct 26, 2010 at 5:55 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > never do VACUUM FULL. Rather, use CLUSTER to rebuild heavily used tables > in order of the most frequently used key (typically the PK), however this > requires a global table lock for the duration, so should only be used when > your application is relatively inactive. Another trick I like to use is to alter a table field from type integer to type integer. This causes pg to rewrite the table without trying to do any sorting that cluster would imply, and results in basically the same end result, and is MVCC safe to boot. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
