Subham,

I would start with reviewing Prof Mike Stonebrakers and Dr Paula Hawthorns paper http://portal.acm.org/citation.cfm?doid=582095.582097 you can also look at Perftrack http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.101.7063&rep=rep1&type=pdf

regards

3dmashUp

On 3/27/2011 6:22 AM, SUBHAM ROY wrote:
Hi,
I am currently a student of IIT Bombay. I am doing a project on "Benchmark design". For that I need to measure the performance of various queries in databases. I want to know how can we measure the execution time of a query in Postgres (Explain analyze will not do). Also is there any tools available in Linux for measuring the performance of queries of databases such as Oracle 11g, Postgres, etc.
Any suggestions will be very helpful.

--
Thank You,
Subham Roy,
CSE IIT Bombay.



--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to