[postgis-users] Spatial Query Benchmarks?

[Ethan Alpert]

Well it's not a web app. The problem is it provides users a method of
managing AOI's and querying a fairly large spatial database at user
defined intervals for new intersects of their AOI's. The reason this is
a problem is although the geometry in the database is well defined the
user's AOI's vary in size, vertice count and ring count. So I need to
know at what point will the number of user AOI's affect QoS.

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Craig Miller
Sent: Friday, November 19, 2004 10:53 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Spatial Query Benchmarks?


If you have written an application on top of PostGIS, then the best way
to profile it is to profile the entire solution.  E.g. if it is a web
application then throw WebLoad at it.  By using something like WebLoad,
you can mimic typical use-cases, and then have n number of users
simultaneously hitting it using these typical use-cases.  This will test
the real-world load rather than the theoretical maximums.

--Craig


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Ethan Alpert
Sent: Friday, November 19, 2004 9:36 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Spatial Query Benchmarks?



Anyone have any suggestions for benchmarking? I've got some services
I've built and my management's not going to let me deploy until I can
quantify at what point my it will break on the current architecture.
Anyone thought about how to determine this kind of information? 

How can I know, even heuristically, how many queries/sec my machine can
sustain, given the tuple and/or vertice count in a given table?

Are tuple and vertice count the only things I should be concerned about
or should I also try to thing about geometry shape (convex,concave,
multiple rings,etc) wrt performance.


-e
_______________________________________________
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