Date: Fri, 10 Sep 2021 10:51:21 +0900
From: Michael Paquier <michael@paquier.xyz>
To: "Bossart, Nathan" <bossartn@amazon.com>
Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	"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>
Subject: Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
Message-ID: <YTq6GZFTbyLPw1Jg@paquier.xyz>
References: 
 <CALj2ACUGUYXsEQdKhEdsBzhGEyF3xggvLdD8C0VT72TNEfOiog@mail.gmail.com>
 <A0BDA184-3564-4FC0-8B71-B16B5D828B9F@amazon.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="ubN7Det0Pl2B7Aiw"
Content-Disposition: inline
In-Reply-To: <A0BDA184-3564-4FC0-8B71-B16B5D828B9F@amazon.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YTq6GZFTbyLPw1Jg%40paquier.xyz>
Precedence: bulk


--ubN7Det0Pl2B7Aiw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Sep 09, 2021 at 10:49:46PM +0000, Bossart, Nathan wrote:
> +1

A backend approach has the advantage that you can use the proper locks
to make sure that a segment is not recycled or removed by a concurrent
checkpoint, so that would be reliable.
--
Michael

--ubN7Det0Pl2B7Aiw
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmE6uhkACgkQnvQgOdby
QH1XTw/+IzvYKpg0AyRR33l3sEXNDlpaQzk4kK0Lu6Kv3FSBwDyTe2xK0DkQwP9K
5RHBs3W/Dgh5gecYlQKUH1dzjGI69lvXpDRM/ll061OQllSQqVg2c3d7MODfQXHA
ovCOUTmj7plFNpo7xYnUiV4SRT/folm3VTQB7nw5I+23jxcU3EnrNz0iLEQP2AOe
1ACB/CyfXQP/XtGy4ufq8cQjUXQxrQ5I76uVDM4KFu0Nbaz0zHjSQ+ixEKSsdPSO
WV3S1l1ln8u7ZVUnZgxSQaZTSub6ApL2vhc7rtsf+kqDlQ6xi0nj4Crh9egfRHXy
ZYaqKtbuQ/D6eBmOMvOKS38Uul7uWOhOVf7pHiwHOArNPgJQdPVn97ekWU2uzEOF
BJOMmTCLgzdFkul0El0q1322nRyn7Qb+zb78XMQjylaRzUOP3ON2jpRmNDSfonHK
bq1sGBMZRnkxN0cR1wbMdQ3Fa7vi5LppSxBAzKxlQefU7p3O0n30sjrXg4LpDxja
6uU0zla3LGY/xIHX13Q1HkrZp+ONKST3OZ25M5/PdhQaRfypsGvEzW/+8wk9WUPt
ftt6Koi4AbigB7zaUu6d4kyQIst3tTAWfURt4XKPaC71D7djlgO6QviN3LZHTwFI
uDX9amWRjowEb0KATP4zm/MZNZmJwZU4R/izrATIK0WVKPqWrN8=
=CmJg
-----END PGP SIGNATURE-----

--ubN7Det0Pl2B7Aiw--