Re: [GENERAL] Measuring Query Performance

2005-03-22 Thread Ed L.
On Tuesday March 22 2005 1:32, Qingqing Zhou wrote: > > Sorry, forget to mention this project: > http://pqa.projects.postgresql.org/example.html Ah, that's interesting. I overlooked that post earlier since I wasn't CC'd. Thanks! Ed ---(end of broadcast)---

Re: [GENERAL] Measuring Query Performance

2005-03-22 Thread Ed L.
On Monday March 21 2005 4:30, Ed L. wrote: > I'm attempting to measure database query performance across a > large number of high-volume clusters Let me try rephrasing this: Is anyone systematically measuring query execution times across multiple clusters to identify performance issues in a

Re: [GENERAL] Measuring Query Performance

2005-03-22 Thread Qingqing Zhou
"Qingqing Zhou" <[EMAIL PROTECTED]> writes > ""Ed L."" <[EMAIL PROTECTED]> writes > > How are others handling this problem? Other ideas? > > > Sorry, forget to mention this project: http://pqa.projects.postgresql.org/example.html Regards, Qingqing ---(end of broadca

Re: [GENERAL] Measuring Query Performance

2005-03-22 Thread Qingqing Zhou
""Ed L."" <[EMAIL PROTECTED]> writes > How are others handling this problem? Other ideas? > In your client, you will measure the libpq/odbc/jdbc or whatever call's completion time and send the interesting parts to your log database. And just make sure the tested database and the log database are