Re: query runtime guru hint - Mailing list pgadmin-hackers

From Dave Page
Subject Re: query runtime guru hint
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4850749@ratbert.vale-housing.co.uk
Whole thread Raw
In response to query runtime guru hint  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-hackers


-----Original Message-----
From: pgadmin-hackers-owner@postgresql.org 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
thatone 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
inthe docs explaining exactly how the timings work is appropriate. 

Regards, Dave

pgadmin-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: query runtime guru hint
Next
From: OpenMacNews
Date:
Subject: pgadminIII on OSX 10.3.9; w/ wxWidgets-2.6.0 OK, w/ wxWidgets-CVS make fail