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