No change I'm afraid :( -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: 17 May 2012 22:59 To: John Watts Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: difference in query plan when db is restored "John Watts" <jwatts@xxxxxxxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]
|
|