[postgis-users] Re: Query uses too much memory

Reid Priedhorsky reid at umn.edu
Thu Jan 22 14:57:42 PST 2009


On 01/21/2009 05:29 PM, Paul Ramsey wrote:
 >
> Upgrade to 1.3.5, it looks like you are doing point-in-polygon
> intersects, and there were some massive leaks there that I fixed in
> later revisions.

This did the trick -- query now completes in ~90 mins on a heavily 
loaded machine using ~190M, which is fine.

Thanks so much!

Reid



More information about the postgis-users mailing list