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 <andrea...@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. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
