[postgis-users] PostGIS Contains / Intersects / Within Performance

[Paul Ramsey]

Bruce,

You need the trunk of both postgis and geos to test the new  
performance goodies..

P

On Jan 28, 2008, at 11:24 AM, Bruce Rindahl wrote:

> Thanks Paul
> I am not sure this is the place for these comments but...
> I upgraded MinGW to version 5.1.3 and that fixed the crash on  
> Geos-3.0.0 but
> I am getting compile errors on the SVN snapshot given in the link  
> below.
> Can I test the performance upgrades using the 3.0.0 version or do I  
> need to
> get the SVN version working?
> Bruce
>
> -----Original Message-----
> From: Paul Ramsey [mailto:pramsey at refractions.net]
> Sent: Monday, January 28, 2008 11:37 AM
> To: rindahl at lrcwe.com; PostGIS Users Discussion
> Cc: 'Ben Jubb'
> Subject: Re: [postgis-users] PostGIS Contains / Intersects / Within
> Performance
>
> fixed
>
> http://geos.refractions.net/downloads/geos-svn.tar.bz2
>
> On Jan 28, 2008, at 10:22 AM, Bruce Rindahl wrote:
>
>> I am getting a major crash on ld.exe when trying to compile 3.0.0.
>> I can't
>> seem to get a complete SVN snapshot when using the directions on
>> http://geos.refractions.net (configure is missing).
>> The link for geos-svn.tar.bz2
> (http://geos.refractions.net/geos-svn.tar.bz2
>> )
>> gives me a 404 error.
>> Could you check on the hourly snapshot link?
>> Thanks
>> Bruce
>>
>> -----Original Message-----
>> From: Ben Jubb [mailto:benjubb at refractions.net]
>> Sent: Monday, January 28, 2008 9:55 AM
>> To: rindahl at lrcwe.com; PostGIS Users Discussion
>> Subject: Re: [postgis-users] PostGIS Contains / Intersects / Within
>> Performance
>>
>> I had no trouble compiling GEOS SVN on MinGW.
>>
>> b
>>
>> Bruce Rindahl wrote:
>>
>> 	Ok let me try this differently :)
>> 	Has anyone had any luck compiling GOES 3.0 or GEOS SVN under MingW?
>> It is
>> 	causing major crashes for me.  If not then I will file a bug.
>> 	Thanks
>> 	Bruce
>> 	
>> 	-----Original Message-----
>> 	From: Paul Ramsey [mailto:pramsey at refractions.net]
>> 	Sent: Saturday, January 26, 2008 9:54 AM
>> 	To: rindahl at lrcwe.com; PostGIS Users Discussion
>> 	Subject: Re: [postgis-users] PostGIS Contains / Intersects / Within
>> 	Performance
>> 	
>> 	I don't know, try and tell us! :)
>> 	
>> 	P
>> 	
>> 	On Jan 25, 2008, at 7:58 PM, Bruce Rindahl wrote:
>> 	
>> 	
>>
>> 		Does the SVN of GEOS compile under MingW??
>> 		Bruce
>> 		
>> 		-----Original Message-----
>> 		From: postgis-users-bounces at postgis.refractions.net
>> 		[mailto:postgis-users-bounces at postgis.refractions.net] On
>> Behalf Of
>> 		Paul
>> 		Ramsey
>> 		Sent: Friday, January 25, 2008 11:46 AM
>> 		To: PostGIS Users Discussion
>> 		Subject: [postgis-users] PostGIS Contains / Intersects /
>> Within
>> 		Performance
>> 		
>> 		I'd love to see some people here with large data volumes who
>> do
>> 		contains/intersects/within tests do some testing of the new
>> postgis/
>> 		geos prepared geometry code...
>> 		
>> 		To test the new functions
>> 		
>> 		- install the svn snapshot of GEOS
>> 		- install the svn snapshot of PostGIS
>> 		- use the ST_ContainsPrepared(g1,g2) predicate for the
>> testing
>> 		
>> 		We've seen performance improvements of between 5 and 100
>> times
>> 		faster.  The bigger and more complicated your test
>> geometries are,
>> 		the faster it should be.
>> 		
>> 		Thanks,
>> 		
>> 		P.
>> 		_______________________________________________
>> 		postgis-users mailing list
>> 		postgis-users at postgis.refractions.net
>> 	
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 		
>> 		
>> 		
>> 		_______________________________________________
>> 		postgis-users mailing list
>> 		postgis-users at postgis.refractions.net
>> 	
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 		
>>
>> 	
>> 	
>> 	
>> 	
>> 	_______________________________________________
>> 	postgis-users mailing list
>> 	postgis-users at postgis.refractions.net
>> 	http://postgis.refractions.net/mailman/listinfo/postgis-users
>> 	
>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>