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@xxxxxxxxxxxxxxxxx>: > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
