Postgres Pro
Downloads
Home   >   mailing lists

query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade - Mailing list pgsql-admin

From Jessica Richard
Subject query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Date
Msg-id 785900.84546.qm@web56411.mail.re3.yahoo.com
Whole thread Raw
Responses Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade  ("Jim C. Nasby" <decibel@decibel.org>)
Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Johann Spies
Date:
Subject: Re: ERROR: invalid memory alloc request size
Next
From: "Nykolyn, Andrew"
Date:
Subject: Problem Recovering from Windows PITR