Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 540FE9FBBB1 for ; Wed, 16 May 2007 16:12:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 28593-01 for ; Wed, 16 May 2007 16:12:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 01BC79FBBAA for ; Wed, 16 May 2007 16:12:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l4GJCCTF006146; Wed, 16 May 2007 15:12:12 -0400 (EDT) To: Jessica Richard cc: pgsql-admin@postgresql.org Subject: Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade In-reply-to: <785900.84546.qm@web56411.mail.re3.yahoo.com> References: <785900.84546.qm@web56411.mail.re3.yahoo.com> Comments: In-reply-to Jessica Richard message dated "Tue, 15 May 2007 12:49:54 -0700" Date: Wed, 16 May 2007 15:12:12 -0400 Message-ID: <6145.1179342732@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/148 X-Sequence-Number: 25468 Jessica Richard writes: > After the entire upgrades, a same query with geospatial functions that used to come back in a few minutes, now take about 3 minutes to finish, no erors, just much slower than before. The standard first question is "did you remember to re-ANALYZE your tables after reloading into the new database"? regards, tom lane