Cosmetic note: hit rates in logs

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

Browse pgsql-hackers by date

  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'?