"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