Re: Replication slot stats misgivings

From: vignesh C <vignesh21(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Subject: Re: Replication slot stats misgivings
Date: 2021-04-12 12:16:37
Message-ID: CALDaNm1WH85m1jXJo86icTAU2fiw3RmUF5e4t6JO16M3+uqAzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 12, 2021 at 4:46 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Sat, Apr 10, 2021 at 6:51 PM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> >
>
> Thanks, 0001 and 0002 look good to me. I have a minor comment for 0002.
>
> <entry role="catalog_table_entry"><para role="column_definition">
> + <structfield>total_bytes</structfield><type>bigint</type>
> + </para>
> + <para>
> + Amount of decoded transactions data sent to the decoding output plugin
> + while decoding the changes from WAL for this slot. This can be used to
> + gauge the total amount of data sent during logical decoding.
>
> Can we slightly extend it to say something like: Note that this
> includes the bytes streamed and or spilled. Similarly, we can extend
> it for total_txns.
>

Thanks for the comments, the comments are fixed in the v8 patch attached.
Thoughts?

Regards,
Vignesh

Attachment Content-Type Size
v8-0001-Changed-char-datatype-to-NameData-datatype-for-sl.patch text/x-patch 8.2 KB
v8-0002-Use-HTAB-for-replication-slot-statistics.patch text/x-patch 30.7 KB
v8-0003-Added-total-txns-and-total-txn-bytes-to-replicati.patch text/x-patch 23.3 KB
v8-0004-Added-tests-for-verification-of-logical-replicati.patch text/x-patch 5.2 KB
v8-0005-Test-where-there-are-more-replication-slot-statis.patch text/x-patch 2.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luc Vlaming 2021-04-12 12:24:32 "could not find pathkey item to sort" for TPC-DS queries 94-96
Previous Message Luc Vlaming 2021-04-12 12:11:59 Re: Lazy JIT IR code generation to increase JIT speed with partitions