Re: Pluggable Storage - Andres's take

From: Beena Emerson <memissemerson(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Mithun Cy <mithun(dot)cy(at)enterprisedb(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pluggable Storage - Andres's take
Date: 2018-09-11 08:00:46
Message-ID: CAOG9ApF2nUBEMMzoJQwkFxiLSR2uGeGeop3nJCQ89HjF-RDwHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

On Mon, 10 Sep 2018, 19:33 Amit Kapila, <amit(dot)kapila16(at)gmail(dot)com> wrote:

> On Mon, Sep 10, 2018 at 1:12 PM Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
> wrote:
> >
> > On Wed, Sep 5, 2018 at 2:04 PM Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
> wrote:
> >>
> > pg_stat_get_tuples_hot_updated and others:
> > /*
> > * Counter tuples_hot_updated stores number of hot updates for heap table
> > * and the number of inplace updates for zheap table.
> > */
> > if ((tabentry = pgstat_fetch_stat_tabentry(relid)) == NULL ||
> > RelationStorageIsZHeap(rel))
> > result = 0;
> > else
> > result = (int64) (tabentry->tuples_hot_updated);
> >
> >
> > Is the special condition is needed? The values should be 0 because of
> zheap right?
> >
>
> I also think so. Beena/Mithun has worked on this part of the code, so
> it is better if they also confirm once.
>

We have used the hot_updated counter to count the number of inplace updates
for zheap to qvoid introducing a new counter. Though, technically, hot
updates are 0 for zheap, the counter could hold non-zero value indicating
the inplace updates.

Thank you

>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2018-09-11 08:28:38 Re: Avoid extra Sort nodes between WindowAggs when sorting can be reused
Previous Message Michael Paquier 2018-09-11 07:08:34 Re: stat() on Windows might cause error if target file is larger than 4GB