At Thu, 12 Jul 2018 10:31:46 +1200, Thomas Munro 
<thomas.mu...@enterprisedb.com> wrote in 
<CAEepm=2ygnw6dj5wx8tusrmcpdz5uziih_qq0ptdha8mmls...@mail.gmail.com>
> I suppose someone might argue that even when it's not a hit and it's
> not a read, we might still want to count this buffer interaction in
> some other way.  Perhaps there should be a separate counter?  It may
> technically be a kind of cache miss, but it's nowhere near as
> expensive as a synchronous system call like read() so I didn't propose
> that.

At Thu, 12 Jul 2018 10:19:29 +1000, Haribabu Kommi <kommi.harib...@gmail.com> 
wrote in <CAJrrPGduEpxwtu9VFxT21DNK=WRP=lujk4gjpfm+4+pcjpc...@mail.gmail.com>
> Thanks for the details. I got your point. But we need to include
> RBM_ZERO_ON_ERROR case read operations, excluding others
> are fine.

FWIW I agree to Haribabu's comment that the case of RBM_ZERO_*
other than ON_ERROR is a hit. It seems to show zheap's disk I /O
reduction by itself in certain extent.

At Thu, 12 Jul 2018 13:28:37 +1200, David Rowley <david.row...@2ndquadrant.com> 
wrote in <CAKJS1f_kem=OzVpFADzC2=VpzcXuSQ+HCW=hp67gaxrnq-e...@mail.gmail.com>
> On 12 July 2018 at 12:19, Haribabu Kommi <kommi.harib...@gmail.com> wrote:
> > Yes, I agree that we may need a new counter that counts the buffers that
> > are just allocated (no read or no write). But currently, may be the counter
> > value is very less, so people are not interested.

> The existing counters don't show up in EXPLAIN (ANALYZE, BUFFERS) when
> they're zero. The new counter would surely work the same way, so the
> users wouldn't be burdened by additional explain output it when
> they're not affected by it.

I don't object strongly neither to the new counter but I'm not
sure it is enough distinctive from hits, in the view that "a hit
is where we found a buffer for the requested page".

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center


Reply via email to