[postgis-users] Buffer Performance

Martin Davis mbdavis at VividSolutions.com
Fri Mar 12 09:33:50 PST 2004

The performance difference is probably due to the difference in the
buffer widths.  In general, larger buffer widths require longer to
compute than smaller ones.  This is due to the greater interaction
(intersections) between the offset curves computed to build the buffer
Martin Davis, Senior Technical Architect
Vivid Solutions Inc.
Suite #1A-2328 Government Street Victoria, B.C. V8T 5G5
Phone: (250) 385 6040 - Local 308 Fax: (250) 385 6046

	-----Original Message-----
	From: Alexander Pucher [mailto:pucher at atlas.gis.univie.ac.at] 
	Sent: Friday, March 12, 2004 3:39 AM
	To: PostGIS Users Discussion
	Subject: [postgis-users] Buffer Performance
	did some buffer performance testing with a table that holds
about 2100 multilinestrings (river network of europe).
	'select buffer(the_geom,5) from river;'
	takes about 7 seconds to execute, whereas
	'select buffer(the_geom,15000) from river' 
	takes a couple of minutes...
	The 'river' table is not indexed, if this might be of importance
	'explain select....' 
	shows similar output for both queries:
	 Seq Scan on river  (cost=0.00..139.51 rows=2051 width=32)
	(1 row)
	What's the reason for the difference in execution time,
depending on the buffer size?
	Is there a way to speed up execution time of such queries??
	Best regards,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040312/b6e93475/attachment.html>

More information about the postgis-users mailing list