Thread: BUG #1283: Queries slow down after restoring big db

BUG #1283: Queries slow down after restoring big db

From
"PostgreSQL Bugs List"
Date:
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.

Re: BUG #1283: Queries slow down after restoring big db

From
Tom Lane
Date:
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> 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.

Did you ANALYZE after importing?

            regards, tom lane