Postgres Pro
Downloads
Home   >   mailing lists

Re: Large index operation crashes postgres - Mailing list pgsql-general

From Frans Hals
Subject Re: Large index operation crashes postgres
Date
Msg-id 39af1ed21003271327s2f8bcb44y15018eacbf333139@mail.gmail.com
Whole thread Raw
In response to Re: Large index operation crashes postgres  (Paul Ramsey <pramsey@cleverelephant.ca>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Frans Hals
Date:
Subject: Re: Large index operation crashes postgres
Next
From: Faheem Mitha
Date:
Subject: simultaneously reducing both memory usage and runtime for a query