Andrew Dunstan <andrew <at> dunslane.net> writes: > Try running CLUSTER on the relevant tables and see if it makes a > difference. If it does you might want to look into using pg_reorg > periodically. That worked like a charm! Many thanks. But how comes, the queries are also fast after a restore without the cluster? regards, Felix -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
