Re: Large index operation crashes postgres

Поиск
Список
Период
Сортировка
От Frans Hals
Тема Re: Large index operation crashes postgres
Дата
Msg-id 39af1ed21003271327s2f8bcb44y15018eacbf333139@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Large index operation crashes postgres  (Paul Ramsey <pramsey@cleverelephant.ca>)
Список pgsql-general
Paul,

do you know, if Postgis 1.3.6 will survive, if I install Geos 3.2 over
it? Currently, there's Geos 3.1.1 installed.
I remember, I had to downgrade Postgis/Geos to be compatible with
Postgres 8.3.9. As I "herited" the database from a  8.3.9 dump, I
needed to fit my installation before restoring the dump.

Thanks
Frans

2010/3/26 Paul Ramsey <pramsey@cleverelephant.ca>:
> Occams razor says it's PostGIS. However, I'm concerned about how old
> the code being run is. In particular, the library underneath PostGIS,
> GEOS, had a *lot* of memory work done on it over the last year. I'd
> like to see if things improve if you upgrade to GEOS 3.2.

В списке pgsql-general по дате отправления:

Предыдущее
От: Frans Hals
Дата:
Сообщение: Re: Large index operation crashes postgres
Следующее
От: Faheem Mitha
Дата:
Сообщение: simultaneously reducing both memory usage and runtime for a query