Feedback-ID: i76984098:Fastmail
Message-ID: <942b979a-c5e8-40e7-bdec-0234a0e5a010@aklaver.com>
Date: Wed, 5 Nov 2025 07:36:58 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9
 (PostgreSQL 11 streaming replication)
To: Bala M <krishna.pgdba@gmail.com>, Greg Sabino Mullane
 <htamfids@gmail.com>, Francisco Olarte <folarte@peoplecall.com>
Cc: chris+google@qwirx.com, pgsql-general@lists.postgresql.org
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
 <CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com>
 <CAJ4rSwvsRJhwfuem0vsws1WwRZPN8Ju2Nw0e0Oc2j7n=MXUhMg@mail.gmail.com>
 <CAKAnmmK9Fjb5YngH4BSb8Lmk3qh10nw=1M3xdcLatr9-U-f-Ug@mail.gmail.com>
 <CA+bJJbwSZg6fiQ78N-_2NwRBbp=6e5WjnSX9SPa_DOxnaU63Vg@mail.gmail.com>
 <CAJ4rSwstZoVgVjbHeDNVq+7eBWCVZSXjNMRpzB4QFjArZT0Hcg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJ4rSwstZoVgVjbHeDNVq+7eBWCVZSXjNMRpzB4QFjArZT0Hcg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/942b979a-c5e8-40e7-bdec-0234a0e5a010%40aklaver.com>
Precedence: bulk

On 11/4/25 22:27, Bala M wrote:
> Thank you all for your suggestions,
> 
> Thanks for your quick response and for sharing the details.
> After reviewing the options, the logical replication approach seems to 
> be the most feasible one with minimal downtime.
> 
> However, we currently have 7 streaming replication setups running from 
> production, with a total database size of around 15 TB. Out of this, 
> there are about 10 large tables ranging from 1 TB (max) to 50 GB (min) 
> each, along with approximately 150+ sequences.
> 
> Could you please confirm if there are any successful case studies or 
> benchmarks available for a similar setup?

Since you have given minimal information in this post, I doubt there is 
really a way to compare to other situations. Collect the details you 
provided earlier in the thread for those folks getting to it just now.

That would be:

1) Postgres versions on both ends

2) OS and versions on both ends.

3) Network distance between 'machines'.

4) The logical replication settings.

> Additionally, please share any recommended parameter tuning or best 
> practices for handling logical replication at this scale.

Since you have already started is that not already to late for this?


> 
> Current server configuration:
> 
> CPU: 144 cores
> 
> RAM: 512 GB
> 
> 
> Thanks & Regards
> Krishna.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com