BUG #1283: Queries slow down after restoring big db - Mailing list pgsql-bugs

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.