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.
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 |