Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 3A4559FBE23 for ; Tue, 15 May 2007 21:54:40 -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 16223-03 for ; Tue, 15 May 2007 21:54:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id F10AF9FBE0A for ; Tue, 15 May 2007 21:54:32 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 829F85644D; Tue, 15 May 2007 19:54:31 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 15 May 2007 19:54:29 -0500 Date: Tue, 15 May 2007 19:54:29 -0500 From: "Jim C. Nasby" 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 Message-ID: <20070516005428.GA11533@nasby.net> References: <785900.84546.qm@web56411.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <785900.84546.qm@web56411.mail.re3.yahoo.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070516:rjessil@yahoo.com::rgb+VtoobahKuSNr:00000000000000000000 0000000000000000000000004hSZ X-Hashcash: 1:20:070516:pgsql-admin@postgresql.org::pr1PIvOEccBypm5A:00000000000 0000000000000000000000007ps8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/129 X-Sequence-Number: 25449 On Tue, May 15, 2007 at 12:49:54PM -0700, Jessica Richard wrote: > We had the following upgrades last week: > > proj-4.4.9 to proj-4.5.0 > geos-2.2.1 to geos-2.2.3 > Postgis 1.1.1 to Postgis 1.2.1, > then > Postgres 8.1.4 to 8.2.4 > > > 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. > > Has any one seen this performance issue after the upgrade before? It can happen, yes. If it's a PostGIS-specific query I suggest you post to the PostGIS list asking for help about it. If it's not PostGIS-specific you should post the query and EXPLAIN ANALYZE output from both versions to pgsql-performance. -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)