[postgis-devel] Query causes Postgres to crash

[strk at refractions.net]

Collin.. I've also found a crash bug report which might be the cause
of your problem:

I'm sorry didn't search on the web, here are info to find out
yourself:

> Date: Fri, 05 Nov 2004 15:46:53 -0500
> From: Tom Lane <tgl at sss.pgh.pa.us>
> Subject: Re: [HACKERS] Backend 8.0.0B4 crash on SELECT ...

Contains a patch and has to do with estimators code...
Beta5 is out, maybe you can also test that.

I've made a simple test locally and my explain analyze is also
hung with a much smaller dataset (beta4 here).

--strk;


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,
> 
> Collin
> NCALM/NCED, UC Berkeley
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel