Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DAEEF9FBD95 for ; Tue, 15 May 2007 16:50:10 -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 64807-05 for ; Tue, 15 May 2007 16:49:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56411.mail.re3.yahoo.com (web56411.mail.re3.yahoo.com [216.252.111.90]) by postgresql.org (Postfix) with SMTP id 271879FBD92 for ; Tue, 15 May 2007 16:49:56 -0300 (ADT) Received: (qmail 85160 invoked by uid 60001); 15 May 2007 19:49:54 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=XLfneddkgCnJTmGH2bK1jQ0ehmbiq+zl0LsiEboV4irip9jdosfniCX2cGRzkmfCI3jgMUBtUWId2WAaYF+KpQbkjPx4Mxw7vsAFIEo2saXyhuEkciEFRXydxsmBRCniHLyjB/ohlIaqBSGpsEZ6DqC4aMpFPj8bPcUn7/wG+Tc=; X-YMail-OSG: 3EzEmaAVM1lnf78KCFqkV2Kuy_U5qQHttrcKHT7B Received: from [198.119.134.32] by web56411.mail.re3.yahoo.com via HTTP; Tue, 15 May 2007 12:49:54 PDT Date: Tue, 15 May 2007 12:49:54 -0700 (PDT) From: Jessica Richard Subject: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-773338770-1179258594=:84546" Content-Transfer-Encoding: 8bit Message-ID: <785900.84546.qm@web56411.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/117 X-Sequence-Number: 25437 --0-773338770-1179258594=:84546 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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? Thanks a lot, Jessica --------------------------------- Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. --0-773338770-1179258594=:84546 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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?

Thanks a lot,
Jessica



Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. --0-773338770-1179258594=:84546--