[postgis-devel] simplify()

[strk at refractions.net]

On Mon, Nov 22, 2004 at 08:54:56AM -0800, Kevin Neufeld wrote:
> Is this a bug with simplify(<geom>,<precision>)?
> 
> cwb_prod_11_10=# update valid_group_codes set the_geom = 
> simplify(the_geom, 1000) where group_code = 'BBAR';
> UPDATE 1
> 
> 
> cwb_prod_11_10=# update valid_group_codes set the_geom = 
> simplify(the_geom, 1000) where group_code = 'LARL';
> ERROR:  out of memory
> DETAIL:  Failed on request of size 5441252.
> 
> For reference: the_geom in this case is a collection of linestrings, 
> making up a single multilinestring. Using a BC Albers projection and our 
> dataset, this query will simplify the_geom where every linestring in the 
> collection is composed of just its start and end points.

Check memsize(the_geom)
Simplify allocates as much memory as needed for a full copy of
the input.
Also what postgis version is it ?
--strk;

> 
> -- 
> Kevin Neufeld,
> Refractions Research Inc.,
> kneufeld at refractions.net
> Phone: (250) 383-3022 
> Fax:   (250) 383-2140 
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel