[postgis-users] evaluation tools?

Biddy newskatze at riomhphost.net
Wed Jun 2 07:13:10 PDT 2010


Hi everyone,

I was wondering what is the best way in postgis to get  
performance/benchmark infos about your database.

For example, where do I find how much physical space my index takes up  
or the actual table? And how do you best record how long a typical  
query takes - let's say I let it run for a 100 times over various  
parts of the dataset from a little java program, how do I best collect  
the times it took to execute the queries?

Thanks,
B.





More information about the postgis-users mailing list