-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Andreas Pflug
Sent: Mon 4/25/2005 5:59 PM
To: pgadmin-hackers
Subject: [pgadmin-hackers] query runtime guru hint
> RFC:
> Taken from the recent discussion on pgsql-performance, I added the
> requirement to have a guru hint for long query runtimes. Now I got a
> good question to ask:
> whatsalongruntime? >10s? >300ms? ...
Good question. 10 seconds sounds good to me - we want the message to get
across, and it's not like you can't disable that one hint.
> Is this a guru hint topic at all, or more a doc/faq topic? Though
> annoying users with guru popups might prevent people from flooding the
> lists with questions answered in the faqs.
Yes, I think so - especially given Tom's observation about the query times in
pgAdmin. I think a hint, and a paragraph in the docs explaining exactly how the
timings work is appropriate.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend