Re: Is pg_basebackup Performance Limited by Files Page Cache? - Mailing list pgsql-general

From Alexandru Lazarev
Subject Re: Is pg_basebackup Performance Limited by Files Page Cache?
Date
Msg-id CAL93h0GbsoAFNZoh6zpRObWMdU8MvAC0ctd18O2nVdzGjuu+oA@mail.gmail.com
Whole thread Raw
In response to Re: Is pg_basebackup Performance Limited by Files Page Cache?  (Alexandru Lazarev <alexandru.lazarev@gmail.com>)
List pgsql-general
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_linux9_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 PM Alexandru Lazarev
<alexandru.lazarev@gmail.com> wrote:
>
> In my case culprit is Linux Kernel (Oracle Linux 9.2: RHCK 5.14 - issue exists, after switched to UEK 5.15 Kernel
issuedisappears). 
> I did various tests with PG container and rsync too and even out of container (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



pgsql-general by date:

Previous
From: Achilleas Mantzios - cloud
Date:
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
Next
From: Ron Johnson
Date:
Subject: Re: PgBackRest fails due to filesystem full