Re: [GENERAL] Update statement results in Out of memory

2016-07-07 Thread Ivan Bianchi
>> >> CREATE TABLE newtable AS SELECT ST_Buffer(geom) ... FROM oldtable; >> >> If you still see memory issues with the above then you probably do >> have a leak, *or* you're just running buffer on a sufficiently large >> input geometry or with a large e

[GENERAL] Update statement results in Out of memory

2016-07-06 Thread Ivan Bianchi
Hello, I am trying to update a column using a PostGIS ST_Buffer function into a table of 4.257.769 rows, but after 6 hours, an *Out of memory* error appears and the kernel starts killing processes until a *Kernel Panic* shows up. I have simplified the buff