[postgis-users] question on performance?

Paragon Corporation lr at pcorp.us
Mon Aug 4 12:14:29 PDT 2008

Not sure if this answers your question.  As long as you have spatial indexes
in place point in polygon queries should run pretty fast.  No you don't need
to do point by point comparisons you can do point by polygon comparisons
You would do something along the line of
SELECT polytable.the_polygon, pointtable.the_point
FROM polytable INNER JOIN pointtable ON ST_Intersects(the_polygon,


From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Saka
Sent: Monday, August 04, 2008 11:04 AM
To: PostGIS
Subject: [postgis-users] question on performance?

Hi all. 
I've a large set of points and a set of polygons. I have written a program
for point in polygon of these dataset even writing its algorithm.
I wanted to know about performance of doing this by PostGIS. however a cost
of connection to postgis exists.
also, can i do it in a bunch manner other than just point by point using

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

More information about the postgis-users mailing list