Re: queries are fast after dump->restore but slow again after some days dispite vacuum - Mailing list pgsql-performance

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