Re: pg_walinspect - a new extension to get raw WAL data and WAL stats
Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
Ashutosh Sharma <ashu.coek88@gmail.com>, Stephen Frost <sfrost@snowman.net>, Jeff Davis <pgsql@j-davis.com>, Robert Haas <robertmhaas@gmail.com>, Andrew Dunstan <andrew@dunslane.net>,
Greg Stark <stark@mit.edu>, Jeremy Schneider <schneider@ardentperf.com>,
Bruce Momjian <bruce@momjian.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>, marvin_liang@qq.com,
actyzhang@outlook.com
Date: 2022-03-25T06:41:47Z
Lists: pgsql-hackers
Attachments
- v15-0001-Refactor-pg_waldump-code.patch (application/x-patch) patch v15-0001
- v15-0002-pg_walinspect.patch (application/x-patch) patch v15-0002
- v15-0003-pg_walinspect-tests.patch (application/x-patch) patch v15-0003
- v15-0004-pg_walinspect-docs.patch (application/x-patch) patch v15-0004
On Fri, Mar 25, 2022 at 12:18 AM Andres Freund <andres@anarazel.de> wrote: > > Hi, > > On 2022-03-24 15:02:29 +0530, Bharath Rupireddy wrote: > > On Thu, Mar 24, 2022 at 10:22 AM Kyotaro Horiguchi > > > This doesn't seem to be a part of xlogreader. Couldn't we add a new > > > module "xlogstats"? XLogRecGetBlockRefInfo also doesn't seem to me as > > > a part of xlogreader, the xlogstats looks like a better place. > > > > I'm not sure if it's worth adding new files xlogstats.h/.c just for 2 > > structures, 1 macro, and 2 functions with no plan to add new stats > > structures or functions. Since xlogreader is the one that reads the > > WAL, and is being included by both backend and other modules (tools > > and extensions) IMO it's the right place. However, I can specify in > > xlogreader that if at all the new stats related structures or > > functions are going to be added, it's good to move them into a new > > header and .c file. > > I don't like that location for XLogRecGetBlockRefInfo(). How about putting it > in xlogdesc.c - that kind of fits? Done. > And what do you think about creating src/backend/access/rmgrdesc/stats.c for > XLogRecStoreStats()? It's not a perfect location, but not too bad either. > > XLogRecGetLen() would be ok in xlogreader, but stats.c also would work? I've added a new xlogstats.c/.h (as suggested by Kyotaro-san as well) file under src/backend/access/transam/. I don't think the new file fits well under rmgrdesc. Attaching v15 patch-set, please have a look at it. Regards, Bharath Rupireddy.
Commits
-
Doc build fix: remove tab from filelist.sgml.
- 8638c76cc9f4 15.0 landed
-
Add contrib/pg_walinspect.
- 2258e76f90bf 15.0 landed
-
Simplify SRFs using materialize mode in contrib/ modules
- 5b81703787bf 15.0 cited
-
Invent "trusted" extensions, and remove the pg_pltemplate catalog.
- 50fc694e4374 13.0 cited