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

[Bruce Rindahl]

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