[postgis-users] ST_Intersects(geom, geom) Memory issue

[Sandro Santilli]

Thanks Andreas.
Could I ask you to also try further filtering your inputs so to avoid 
point geometries as a whole ? It'd help further debugging the issue.
It would take adding something like this:

 AND ST_Dimension(p.cell) != 0 AND ST_Dimension(p.geom) != 0

--strk;


On Wed, Feb 08, 2012 at 04:55:08PM +0100, Andreas Forø Tollefsen wrote:
> I tested the query again and identified which commit of revisions
> introduced the problem.
> Until revision 8876 the query works fine.
> After revision 8877 the query leaks memory and eats up all of the
> servers memory in a couple of minutes.
> 
> Tested:
> 8096 OK
> 8796 OK
> 8866 OK
> 8876 OK
> 8877 NOT OK
> 8886 NOT OK
> 8896 NOT OK
> 8996 NOT OK
> 9096 NOT OK
> 
> Again the query was simply:
> 
> SELECT a.gid, g.startyear, g.endyear, g.cowgroup, a.gridyear INTO geoepr_cell
> FROM priogridall a, priogrid p, geoepreth2 g WHERE a.gid = p.gid AND
> a.gridyear = 1946 AND a.gwcode = g.cowcode AND ST_Intersects(p.cell,
> g.geom)
> AND g.startyear <= 1946 AND g.endyear >= 1946 GROUP BY a.gid,
> g.startyear, g.endyear, g.cowgroup, a.gridyear ORDER BY gid ;
> 
> Would be great if you could look into this.
> 
> Best,
> 
> Andreas
> 
> 
> 2012/2/4 Andreas Forø Tollefsen <andreasft at gmail.com>:
> > I created a new clean db and installed latest rev. Then loaded my tables and
> > ran the query with the same error and postgres server crash.
> > Any suggestions on how i can solve this? As for now i am using rev 8292 and
> > then the query and my raster summaries work.

-- 

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'