On Thu, Jan 22, 2009 at 10:58:25PM +0100, Thomas Finneid wrote: > Thomas Markus wrote: > >> try to reorganize your data with CLUSTER and create appropriate indixes >> (dont forget to check statistics). > > One question. Assume I have clustered and new data has been added after > that, according to the docs that data is added "outside" of the clustered > data. What happens when I run cluster again? I would assume its smart and > to only clusteres the new data, i.e. adding it to the already created > clusters, as apporpriate, so the execution time would be a lot lower, > right? or would it run through and recluster everything from scratch again? > > thomas > It reclusters again from scratch. You do get better performance on the reads from the data that is already clustered.
Cheers, Ken -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
