Feedback-ID: i76984098:Fastmail
Message-ID: <73f3723b-f279-43c6-884d-d12b3151ec9e@aklaver.com>
Date: Tue, 12 Aug 2025 09:14:19 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Questions about the continuity of WAL archiving
To: px shi <spxlyy123@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAAccyYKpNsQMD+S-A7a8YtDevFN0uRXkzg4tYWWBOFsv_jASNg@mail.gmail.com>
 <fd5c6708-3791-4339-83a2-e5fc389cd9cb@aklaver.com>
 <CAAccyYLYZmwQiNMoJcQgo5t+E24rDtu1ZeBUrER7ZTKNAcZesw@mail.gmail.com>
 <d3622bf1-6a62-4703-b14e-295f47b5e348@aklaver.com>
 <CAAccyYJ-07SzCRAEkGJ2Qa8EAPCHQM4qcpB=OvD8P0zDbCJ0KQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAAccyYJ-07SzCRAEkGJ2Qa8EAPCHQM4qcpB=OvD8P0zDbCJ0KQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/73f3723b-f279-43c6-884d-d12b3151ec9e%40aklaver.com>
Precedence: bulk

On 8/12/25 01:24, px shi wrote:
> 
>     1) What is the current archiving setup on the primary and why is
>     lagging?
> 
>   The archive command uses pgBackRest to archive to S3. Because it is 
> uploaded to S3, the archiving speed is slow, which has caused lagging.
> 
>     2) Have you looked at archiving off the standby node while it is in
>     standby per:
> 
> Yes, archiving on the standby node is disabled. Is it recommended to 
> share the WAL archive between the primary and standby nodes to avoid 
> interruptions in archiving?

Given that you are using a less then capable storage solution(S3) why do 
you think pushing the WAL from the standby to S3 would perform any 
better then what is happening with the primary WAL?

The solution is to use a more capable storage platform.

> 
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> 于2025年8月8日周五 23:23写道：
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com