Subject: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
To: "Bossart, Nathan" <bossartn@amazon.com>, Bharath Rupireddy
	<bharath.rupireddyforpostgres@gmail.com>, PostgreSQL Hackers
	<pgsql-hackers@lists.postgresql.org>
CC: "satyanarlapuram@gmail.com" <satyanarlapuram@gmail.com>,
	"marvin_liang@qq.com" <marvin_liang@qq.com>, "actyzhang@outlook.com"
	<actyzhang@outlook.com>, Ashutosh Sharma <ashu.coek88@gmail.com>
References: 
 <CALj2ACUGUYXsEQdKhEdsBzhGEyF3xggvLdD8C0VT72TNEfOiog@mail.gmail.com>
 <A0BDA184-3564-4FC0-8B71-B16B5D828B9F@amazon.com>
From: "Drouvot, Bertrand" <bdrouvot@amazon.com>
Message-ID: <03c3fcd8-ac01-e6e2-a321-2808d07b11da@amazon.com>
Date: Fri, 10 Sep 2021 09:04:10 +0200
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:78.0)
 Gecko/20100101 Thunderbird/78.14.0
MIME-Version: 1.0
In-Reply-To: <A0BDA184-3564-4FC0-8B71-B16B5D828B9F@amazon.com>
Content-Type: text/plain; charset="utf-8"; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/03c3fcd8-ac01-e6e2-a321-2808d07b11da%40amazon.com>
Precedence: bulk


On 9/10/21 12:49 AM, Bossart, Nathan wrote:
> On 9/8/21, 6:49 AM, "Bharath Rupireddy" <bharath.rupireddyforpostgres@gmail.com> wrote:
>> How about we create a new extension, called pg_walinspect (synonymous
>> to pageinspect extension) with a bunch of SQL-callable functions that
>> get the raw WAL records or stats out of a running postgres database
>> instance in a more structured way that is easily consumable by all the
>> users or DBAs or developers? We can also provide these functionalities
>> into the core postgres (in xlogfuncs.c) instead of a new extension,
>> but we would like it to be pluggable so that the functions will be
>> used only if required.
> +1
>
> Nathan
>
+1

Bertrand