On 6/21/25 23:09, Aleš Zelený wrote:
> Hello,
> ...
>
> The application benefits from parallel queries, so despite the first
> temptation to disable parallel queries (based on log entries correlation
> only, but is that the root cause?) I did not want to disable parallel
> queries, if there is another workaround/solution/fix available.
>
> Thanks for any hints on how to provide more information if needed, as
> well as for fix/workaround advice.
>
Could it be that you simply ran out of memory, or perhaps hit the
overcommit? What does sysctl say?
sysctl vm.overcommit_memory
And what's CommitLimit/Committed_AS in /proc/meminfo? IIRC the shmem is
counted against the limit, and if the system does not have significant
swap, it's not uncommon to hit that (esp. with overcommit_memory=2).
regards
--
Tomas Vondra