Thanks Joe, I will set these kernel parameters.
I also would like to highlight that the issue happened on SECONDARY. While
the PRIMARY has less memory and computation in comparison to SECONDARY, not
sure if there is anything wrong in the PgSQL.
PRIMARY: 48vCPUs & 48GB memory
SECONDARY: 64vCPUs &
On 10/14/24 14:37, Siraj G wrote:
This is from the OS log (/var/log/kern.log):
oom-
kill:constraint=CONSTRAINT_NONE,nodemask=(null),cpuset=/,mems_allowed=0,global_oom,task_memcg=/system.sli ce/system-postgresql.slice/postgresql@12-main.service,task=postgres,pid=2334587,uid=114
494 Oct 1
Hello Experts!
My secondary instance has been unstable today. The service is crashing with
Out of Memory. Please see below error
(/var/log/postgresql/postgresql-2024-10-14.log):
10.2.52.50,2024-10-14 15:28:11 IST,686671,finance_revamp,finance_b2b,1,LOG:
duration: 1148.527 ms statement: SELECT "
