| 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: | Whole Thread | Raw Message | 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'? |