"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
