Postgres Pro
Downloads
Home   >   mailing lists

Re: difference in query plan when db is restored - Mailing list pgsql-general

From Tom Lane
Subject Re: difference in query plan when db is restored
Date
Msg-id 1326.1337284712@sss.pgh.pa.us
Whole thread Raw
In response to difference in query plan when db is restored  ("John Watts" <jwatts@promotion-update.com>)
Responses Re: difference in query plan when db is restored
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "John Watts"
Date:
Subject: difference in query plan when db is restored
Next
From: "John Watts"
Date:
Subject: Re: difference in query plan when db is restored