No change I'm afraid :(
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 17 May 2012 22:59
To: John Watts
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] difference in query plan when db is restored
"John Watts" <jwatts@promotion-update.com> 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