Re: [GENERAL] Selection of index for CLUSTER

2010-02-15 Thread Leonardo F
> The docs are mute on this. Not true. Read the NOTES section of http://www.postgresql.org/docs/8.4/static/sql-cluster.html : -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Selection of index for CLUSTER

2010-02-15 Thread Marcin Krol
Hello everyone, Is there some guideline for selection of index to use for CLUSTER? This is rather important as physical table is reorganized according to that index I gather? The docs are mute on this. The docs recommend running ANALYZE on the table. hrs=# ANALYZE VERBOSE hosts; INFO: analy