From: | Alexandru Lazarev <alexandru(dot)lazarev(at)gmail(dot)com> |
---|---|
To: | kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is pg_basebackup Performance Limited by Files Page Cache? |
Date: | 2025-04-09 11:20:22 |
Message-ID: | CAL93h0GbsoAFNZoh6zpRObWMdU8MvAC0ctd18O2nVdzGjuu+oA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)lazarev(at)gmail(dot)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 issue disappears).
> 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(dot)vaikla(at)gmail(dot)com> wrote:
>>
>> Hi,
>> Did you get any feedback?
>> I have suspected something similar.
>>
>> br
>> Kaido
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2025-04-09 13:16:11 | Re: PgBackRest fails due to filesystem full |
Previous Message | Achilleas Mantzios - cloud | 2025-04-09 06:20:37 | Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm |