Skip site navigation (1) Skip section navigation (2)

Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Date: 2007-05-16 00:54:29
Message-ID: 20070516005428.GA11533@nasby.net (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)decibel(dot)org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

pgsql-admin by date

Next:From: Jim C. NasbyDate: 2007-05-16 00:57:16
Subject: Re: Problem Recovering from Windows PITR
Previous:From: Joshua D. DrakeDate: 2007-05-16 00:01:52
Subject: Re: How overcome wait for vacuum full?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group