Horton

Re: pg_walinspect - a new extension to get raw WAL data and WAL stats

Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>

View thread View on postgr.es
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
To: Jeremy Schneider <schneider@ardentperf.com>
Cc: Bruce Momjian <bruce@momjian.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, satyanarlapuram@gmail.com, marvin_liang@qq.com, actyzhang@outlook.com, Ashutosh Sharma <ashu.coek88@gmail.com>
Date: 2021-11-25T10:19:03Z
Lists: pgsql-hackers

Attachments

On Thu, Nov 18, 2021 at 6:43 PM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> On Thu, Oct 7, 2021 at 10:43 AM Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote:
> > > Looking at the proposed API from the initial email, I like that there's
> > > both stats functionality and WAL record inspection functionality
> > > (similar to pg_waldump). I like that there's the ability to pull the
> > > records as raw bytea data, however I think we're also going to want an
> > > ability in v1 of the patch to decode it (similar to pageinspect
> > > heap_page_item_attrs, etc).
> >
> > I'm yet to start working on the patch. I will be doing it soon.
>
> Thanks all. Here's the v1 patch set for the new extension pg_walinspect. Note that I didn't include the documentation part now, I will be doing it a bit later.
>
> Please feel free to review and provide your thoughts.

The v1 patch set was failing to compile on Windows. Here's the v2
patch set fixing that.

Regards,
Bharath Rupireddy.

Commits

  1. Doc build fix: remove tab from filelist.sgml.

  2. Add contrib/pg_walinspect.

  3. Simplify SRFs using materialize mode in contrib/ modules

  4. Invent "trusted" extensions, and remove the pg_pltemplate catalog.