From: | "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Cosmetic note: hit rates in logs |
Date: | 2007-02-14 06:28:52 |
Message-ID: | 5648.125.24.221.250.1171434532.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Just noticed a small cosmetic point in the logs when logging statement
performance data: if a statement accesses 0 blocks, the "hit rate" is
given as 0%.
I can see that that makes sense mathematically--insofar as 0/0 makes
mathematical sense at all--but wouldn't it be more helpful to represent
this as a 100% hit rate?
I guess computing hit rate as the limit of 0/x is as valid as computing
the limit of x/x (with x being the number of accesses that approaches
zero). But when I look at the logs I find myself going "low hit rate
here--oh wait, that's for zero accesses" all the time. Or would the
change make other people "good hit rate here--oh wait, that's for zero
accesses"?
Jeroen
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Miller | 2007-02-14 06:41:58 | "anyelement2" pseudotype |
Previous Message | Bruce Momjian | 2007-02-14 05:11:27 | Re: [HACKERS] Error in from_char() for field 'D'? |