<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-abbreviated" href="mailto:strk@refractions.net">strk@refractions.net</a> wrote:
<blockquote cite="mid20041122171050.GA70813@freek.keybit.net"
type="cite">
<pre wrap="">On Mon, Nov 22, 2004 at 08:54:56AM -0800, Kevin Neufeld wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->
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;
</pre>
</blockquote>
<tt>This is using PostGIS v0.9.0<br>
<br>
</tt><tt>cwb_prod_11_10=# select mem_size(the_geom) from
valid_group_codes where group_code = 'BBAR';<br>
mem_size <br>
----------<br>
3408260<br>
(1 row)<br>
<br>
cwb_prod_11_10=# select mem_size(the_geom) from valid_group_codes where
group_code = 'LARL';<br>
mem_size <br>
----------<br>
8956628<br>
(1 row)<br>
<br>
<br>
</tt>
<blockquote cite="mid20041122171050.GA70813@freek.keybit.net"
type="cite">
<pre wrap=""></pre>
<blockquote type="cite">
<pre wrap="">--
Kevin Neufeld,
Refractions Research Inc.,
<a class="moz-txt-link-abbreviated" href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</a>
Phone: (250) 383-3022
Fax: (250) 383-2140
_______________________________________________
postgis-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-devel@postgis.refractions.net">postgis-devel@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-devel">http://postgis.refractions.net/mailman/listinfo/postgis-devel</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Kevin Neufeld,
Refractions Research Inc.,
<a class="moz-txt-link-abbreviated" href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</a>
Phone: (250) 383-3022
Fax: (250) 383-2140 </pre>
</body>
</html>