"John Watts" <[email protected]> writes:
> I have a database query which executes normal (under 1s) with 21 steps
> according to the query paln. However, when the database is dumped and
> restored on the _same_ PostgreSQL server, the query plan takes 34 steps
> to complete and it executes in excess of 90 seconds!
Usually you need to ANALYZE after restoring from a dump ...
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
