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. Check into FILLFACTOR (on both tables and indexes). -- Craig Ringer -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance