query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

Поиск
Список
Период
Сортировка
От Jessica Richard
Тема query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Дата
Msg-id 785900.84546.qm@web56411.mail.re3.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Johann Spies
Дата:
Сообщение: Re: ERROR: invalid memory alloc request size
Следующее
От: "Nykolyn, Andrew"
Дата:
Сообщение: Problem Recovering from Windows PITR