Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #1283: Queries slow down after restoring big db
Date
Msg-id 23667.1097182035@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1283: Queries slow down after restoring big db  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in PostrgeSQL 8.0beta
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1238: postgres option -Q used in src/test/bench