On Sat, Nov 1, 2025 at 3:14 AM Andrey Borodin <[email protected]> wrote: > Many storages charge for request. If archive tool issues HEAD request to S3 - > it might costs user some money. > Other storages cap frequency of requests at some RPS. In worst case we might > affect archiving capabilities of primary. > > The key idea here is that archive storage might be a disaster recovery system > that is optimized for storing data, but not for listing this data frequently. > So the cluster should not delegate archive_status function to some distant > storage if it can be cheaply tracked within HA cluster internally.
Just idea, as another approach, we could check whether the specified WAL file has already been archived, by querying pg_stat_archiver on the primary, instead of sending a request to the storage service. So, it seems we could set the standby's archive_command to a script that performs this check via pg_stat_archiver to achieve the same goal. Thoughts? Regards, -- Fujii Masao
