The following bug has been logged online:
Bug reference: 1283
Logged by: Fabio Fucci
Email address: ffucci@kell.it
PostgreSQL version: 7.3
Operating system: linux
Description: Queries slow down after restoring big db
Details:
We dumped a database with a lot of data using command pg_dump mydb >
mydb.dump
Then we reimported the data in this way:
1- createdb anotherdb
2- psql anotherdb < mydb.dump
After the data was restored queries(SELECT queries, with JOINs) was very
very slow.
We solved the problem making a separate dump for the database schema and one
for the data and then reimported first the schema and then the data.