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

Reply via email to