Sorry Mr. Geoffroy, your message arrived only now in my e-mail. Somehow, every list message takes a large amount of time to come into my e-mail. Thank you for your concerns and yes, postgresql has debug/ analyze commands that displays the time that commit or anything else take to complete. On 2/5/07, Geoffroy Arnoud <garnoud@yahoo.co.uk> wrote:
The database takes between 15ms and 40ms to answer
to freeradius
Sometimes it takes a LOT longer than that.
I don't konw how you measure the processing time. I don't know what your request does, but if it does one or several commit(s), is the commit time counted? I have used Oracle/TkProf (tkprof is a request profiling tool from Oracle) and the time for commit is not given. The only way to have it is to measure it as a black-box.
But maybe it's what you already do. An maybe that prostgre return the commit time?
Geoff.
___________________________________________________________________________ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses http://fr.answers.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html