[postgis-devel] Query causes Postgres to crash

[strk at refractions.net]

On Thu, Dec 09, 2004 at 10:48:42AM -0800, collin wrote:
> Folks, the following query has consistantly caused Postgresql 8.0beta4 
> to crash (postgis 1.0cvs (10/15/04),geos 2.0.1,proj4.4.9) on a FC3 linux 
> pc (1GB ram, 160GB HD, dual 750mhz PIII).
> 
> UPDATE grid10m SET
> lzmin = (SELECT min(lz) from unfilteredpts WHERE lreturn  && the_geom),
> lzmax  = (SELECT max(lz) from unfilteredpts WHERE lreturn  && the_geom),
> lzavg  = (SELECT avg(lz) from unfilteredpts WHERE lreturn  && the_geom),
> lzstddev  = (SELECT stddev(lz) from unfilteredpts WHERE lreturn  && 
> the_geom);
> 
> grid10m is a set of 11,000 square polygons.  unfilteredpts is as set of 
> 2.5 million points (2 geometry columns lreturn, freturn).
> 
> I am trying an explain analyze on a subset (1,700 grid polys & 400,000 
> pts), but it has been 2 hours and I still do not have a result.
> 
> Any thoughts? Thanks,

I'd concentrate to explain analyze not returning.
Define DEBUG_GEOMETRY_STATS in lwgeom/lwgeom_estimate.c
and see what goes on.
--strk;

> 
> Collin
> NCALM/NCED, UC Berkeley
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel