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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Fabio Fucci" <ffucci(at)kell(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1283: Queries slow down after restoring big db
Date: 2004-10-07 20:47:15
Message-ID: 23667.1097182035@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2004-10-07 22:51:37 Re: BUG #1238: postgres option -Q used in src/test/bench
Previous Message Tom Lane 2004-10-07 20:39:23 Re: Bug in PostrgeSQL 8.0beta