Re: Resetting spilled txn statistics in pg_stat_replication

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Cc: Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Resetting spilled txn statistics in pg_stat_replication
Date: 2020-09-30 09:10:41
Message-ID: CAA4eK1JaCaCsoowniB+0atg-o1h27JFQE3ENV-gKLeZ0-e0i3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 30, 2020 at 1:12 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> On Fri, Sep 25, 2020 at 4:33 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Thu, Sep 24, 2020 at 5:44 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > I have done some more testing of this patch especially for the case
> > where we spill before streaming the transaction and found everything
> > is working as expected. Additionally, I have changed a few more
> > comments and ran pgindent. I am still not very sure whether we want to
> > display physical slots in this view as all the stats are for logical
> > slots but anyway we can add stats w.r.t physical slots in the future.
> > I am fine either way (don't show physical slots in this view or show
> > them but keep stats as 0). Let me know if you have any thoughts on
> > these points, other than that I am happy with the current state of the
> > patch.
>
> IMHO, It will make more sense to only show the logical replication
> slots in this view.
>

Okay, Sawada-San, others, do you have any opinion on this matter?

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2020-09-30 09:16:13 Re: [HACKERS] logical decoding of two-phase transactions
Previous Message Michael Paquier 2020-09-30 09:10:10 Re: [DOC] Document concurrent index builds waiting on each other