Andrew Dunstan 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
Hi, I am running a 9.1 server at Ubuntu. When I upgraded to the current version
I did a pg_dump followed by pg_restore and found that the db was much faster.
But slowed down again after two days. I did the dump-restore again and could
now
compare the two (actually identical) databases. This is
