[postgis-devel] Query causes Postgres to crash

[collin]

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,

Collin
NCALM/NCED, UC Berkeley