Paul, took your advice and installed Geos 3.2.0. Index is now running for 14 hrs, postmaster is taking all the RAM. Sadly it looks like the Geos update didn't save me. Regards Frans 2010/3/28 Paul Ramsey <pramsey@xxxxxxxxxxxxxxxxx>: > GEOS 3.2 is backwards compatible, so you can install it overtop of 3.1 > and things will still work. > > P >> >> 2010/3/26 Paul Ramsey <pramsey@xxxxxxxxxxxxxxxxx>: >>> 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. >> > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general