MIME-Version: 1.0
References: <CAL93h0EAX7JgAtpQPkXCGzNfzU5x6-M7xYi_mZSO_DEgg2QJkA@mail.gmail.com>
 <CA+427g8buj=VMhwXS1B_sipXoxBqVpRnSHto5xsmA5QRMu=_0Q@mail.gmail.com> <CAL93h0EOvoXQjJAzRqEYZKjEyrMVg9wuKEx6GGShUmGKn0Q3BA@mail.gmail.com>
In-Reply-To: <CAL93h0EOvoXQjJAzRqEYZKjEyrMVg9wuKEx6GGShUmGKn0Q3BA@mail.gmail.com>
From: Alexandru Lazarev <alexandru.lazarev@gmail.com>
Date: Wed, 9 Apr 2025 14:20:22 +0300
Message-ID: <CAL93h0GbsoAFNZoh6zpRObWMdU8MvAC0ctd18O2nVdzGjuu+oA@mail.gmail.com>
Subject: Re: Is pg_basebackup Performance Limited by Files Page Cache?
To: kaido vaikla <kaido.vaikla@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAL93h0GbsoAFNZoh6zpRObWMdU8MvAC0ctd18O2nVdzGjuu%2BoA%40mail.gmail.com>
Precedence: bulk

I'll answer my own question here:
Looks like it is a bug in Oracle Linux (OL) 9.2 RHCK Kernel
"kernel-5.14.0-284.11.1" (see table:
https://docs.oracle.com/en/operating-systems/oracle-linux/9/boot/oracle_lin=
ux9_kernel_version_matrix.html)

Switching to UEK Kernel of the same OL version (9.2) fixed the issue,
but UEK is not supported by some SW (e.g. Vertica DB), so that I've
tried RHCK Kernels update: only Kernel and dependencies from OL9.4
(kernel-5.14.0-427) and OL9.5 (kernel-5.14.0-503.11.1) - both fixed
the issue, with remark: RHCK update using one from OL9.5 is suspected
to have some HW compatibility issues (under investigation).
Some more details discussed here: Performance Degradation with rsync
in container or cgroupv2 with MEM limit on Oracle Linux 9.2 (RHCK 5.14
vs. UEK 5.15)

On Wed, Mar 26, 2025 at 11:17=E2=80=AFPM Alexandru Lazarev
<alexandru.lazarev@gmail.com> wrote:
>
> In my case culprit is Linux Kernel (Oracle Linux 9.2: RHCK 5.14 - issue e=
xists, after switched to UEK 5.15 Kernel issue disappears).
> I did various tests with PG container and rsync too and even out of conta=
iner (launched rsync into a CgroupV2).
>
> So now I guess it is a question to Linux Kernel communities in my case.
> More details: https://www.reddit.com/r/linuxquestions/s/ADScolw76C
>
> AlexL
>
>
> On Wed, Mar 26, 2025, 21:16 kaido vaikla <kaido.vaikla@gmail.com> wrote:
>>
>> Hi,
>> Did you get any feedback?
>> I have suspected something similar.
>>
>> br
>> Kaido