[postgis-users] Union as an aggregate
strk at keybit.net
Mon Sep 29 09:46:02 PDT 2003
I made my dumbass-mode aggregate (unite!).
It eats up all available memory, which remains allocated
also at the end of function run.
Does it sound as a postgresql bug ?
To reduce memory occupation it might be useful to release detoasted
values passed as arguments to geomunion with pfree, because
those allocations might remain 'till the end of the aggregate
run, but I'm not sure about palloced values life/aggregates.
> strk wrote:
> > Hello, I'm playing around with GEOS and I wondered why
> > there is no aggregate function to use with GEOSUnion.
> No reason. It is relatively simple to code up in a dumbass way. Doing it
> efficiently is much harder.
> > I think an aggregate would be the most natural way to
> > use it (does OGC talks about this?).
> I agree, it is the way most people will understand union to work. Of
> course, OGC makes no mention of such an operating mode at all.
> | Paul Ramsey
> | Refractions Research
> | Email: pramsey at refractions.net
> | Phone: (250) 885-0632
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users