Re: Standardize LSN-based filename

From: Japin Li <japinli(at)hotmail(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Standardize LSN-based filename
Date: 2025-08-22 01:29:20
Message-ID: ME0P300MB0445186032FDC90C08C277DAB63DA@ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 21 Aug 2025 at 15:52, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Wed, Aug 20, 2025 at 10:37 AM Japin Li <japinli(at)hotmail(dot)com> wrote:
>> Yeah. It's for both consistency and for proper file sorting.
>>
>> Zero-padding ensures that when a file system or tool sorts the snapshot files
>> alphabetically, the order is also chronological. For example, without
>> zero-padding, 2-1.snap would come before 10-1.snap, which is incorrect.
>
> I understand this situation can occur. Does this actually cause any real issues?
No.

> If not, and if no other programs depend on file name ordering, then the current
> naming should be fine?

Yeah! I don't insist on implementing this now; I'm simply documenting the
potential issue.

--
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2025-08-22 01:41:15 Re: Remove unneeded cast in heap_xlog_lock.
Previous Message Fujii Masao 2025-08-22 01:19:32 Re: Don't treat virtual generated columns as missing statistics in vacuumdb --missing-stats-only