Paul,
I have started the operation right now after a fresh reboot of the machine.
<update placex set leakcheck = st_x(st_centroid(geometry));>
Please give me some time to collect the results...
Thanks & regards
Frans
2010/3/25 Paul Ramsey <pramsey@cleverelephant.ca>:
> If you build an index, or try to update a column, using just the
>
> ST_X(ST_Centroid())
>
> without all the extra pl/pgsql wrapping, do you still see the memory
> footprint grow substantially?
>
> P.