Re: Function for listing pg_wal/summaries directory - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Function for listing pg_wal/summaries directory
Date
Msg-id 7e08d7bb-f803-4c09-8f3e-1a9d909aa428@oss.nttdata.com
Whole thread Raw
In response to Re: Function for listing pg_wal/summaries directory  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Function for listing pg_wal/summaries directory
List pgsql-hackers

On 2024/10/08 23:36, Nathan Bossart wrote:
> On Tue, Oct 08, 2024 at 01:19:52PM +0900, Michael Paquier wrote:
>> On Tue, Oct 08, 2024 at 12:41:16PM +0900, Fujii Masao wrote:
>>> One benefit of supporting something like pg_ls_summariesdir() is that
>>> it allows us to view the last modification time of each WAL summary file
>>> and estimate when they'll be removed based on wal_summary_keep_time.
>>>
>>> Of course, we could also extend the existing function to report
>>> the last modification time if this use case is valid, though.
>>
>> My argument is about knowing the size of each file, for monitoring of
>> disk space.  The retention can be controlled by a GUC based on time,
>> and this function requires knowing about the file name format.
> 
> Okay.  I have no problem with adding something like pg_ls_summariesdir(),
> but I guess I was hopeful we could just add any missing information to the
> existing WAL summarization information functions.  A new pg_ls_*dir()
> function would indeed fit nicely with the existing suite of generic file
> access functions.
> 
> The patch posted upthread looks reasonable to me, so I'll go commit it soon
> unless there is any feedback.

Thanks! The patch looks good to me, too.

>  IMHO we should consider alphabetizing the
> table in the docs [0], too.

+1

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION




pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Add contrib/pg_logicalsnapinspect
Next
From: Peter Smith
Date:
Subject: Re: GUC names in messages