Re: [GENERAL] Analyze against a table with geometry columns runs out of memory

2014-05-08 Thread Paul Ramsey
Roxanne, you seem to have isolated the problem to a particular geometry column, which speaks to this being a PostGIS problem. Since the analyze code was re-written in 2.1, and your issue is coming up in a 2.02.1 upgrade, that further points to the issue potentially being a PostGIS problem.

Re: [GENERAL] Analyze against a table with geometry columns runs out of memory

2014-05-08 Thread Roxanne Reid-Bennett
On 5/8/2014 7:07 AM, Paul Ramsey wrote: Roxanne, you seem to have isolated the problem to a particular geometry column, which speaks to this being a PostGIS problem. ok - wrong list - sorry! Since the analyze code was re-written in 2.1, and your issue is coming up in a 2.02.1 upgrade, that

[GENERAL] Analyze against a table with geometry columns runs out of memory

2014-05-07 Thread Roxanne Reid-Bennett
Hello, We are working out the upgrade of our servers from Postgres 9.1 and Postgis 2.0 to Postgres 9.3 and Postgis 2.1 After building the base stack, The System Admin restored the database from a backup. [I'll ask for more details if you need them] I have 3 tables with geometry columns in