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
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