And I have a daily cron script that executes the following statement: sudo -u postgres /usr/bin/vacuumdb -U postgres --all --analyze But I had not considered using CLUSTER - I will certainly look into that. Thanks again. Harry Mantheakis London, UK -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance