On Wed, Sep 21, 2011 at 11:57 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote: > On 09/21/2011 12:13 PM, Venkat Balaji wrote: >> >> I as a DBA, suggested to perform VACUUM FULL and RE-INDEXING + ANALYZE to >> ensure that IO performance and Indexing performance would be good > > > Read http://wiki.postgresql.org/wiki/VACUUM_FULL before you run VACUUM FULL. > You probably don't want to do that. A multi-gigabyte table can easily be > unavailable for several hours if you execute VACUUM FULL against it. > CLUSTER is almost always faster. It used to be that cluster on a very randomly ordered table was much slower than doing something like select * into newtable from oldtable order by col1, col2; Is that still the case in 9.0/9.1? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
