[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Re: Query uses too much memory
From:       Reid Priedhorsky <reid () umn ! edu>
Date:       2009-01-22 22:57:42
Message-ID: 4978F9E6.7040805 () umn ! edu
[Download RAW message or body]

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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]