This should be fixed when 1.3.4 comes out. An rc2 will be out tomorrow you can try.
P. On Tue, Oct 21, 2008 at 3:28 PM, John Zhang <[EMAIL PROTECTED]> wrote: > Hello list, > > I am writing to seek your input on how to handle such an issue: > > I have a large table containing over 3 million polygons and a small table > containing 53k points. My function is to identify whether a point in the > table is Contained by a polygon in the polygon table. ST_Contains function > is effectively used for this purpose (it takes about 2 seconds for given > known polygon: "polyG && ptG AND ST_Contains(polyG, ptG)" is used where > polyG an ptG are the geometries of the point an dpolygon). However, with a > given pt, it crashes to run through all the polygons with the reason given > "Out of memory for query" in about 300 seconds. I then tested with select > count(*) of the polygon table, it takes 100 seconds as well. It seems there > is something wrong in the database configuration. I could not figure out > what is wrong there. Could anyone help on the issue? Any input would be much > appreciated. > > Thanks in advance. > John > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
