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.
>