BUG #1283: Queries slow down after restoring big db

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.