BUG #16503: excessive memory consumption.
The following bug has been logged on the website:
Bug reference: 16503
Logged by: Jay Prakash
Email address: jaypeeid@gmail.com
PostgreSQL version: 10.10
Operating system: AWS RDS
Description:
Hi
My name is Jay Prakash. I am new to Postgres. I have more than 20 years of
experience with Oracle but in my current job, I have to tune SQL with
Postgres database. I have having performance issue and I wanted to know how
to submit my question/concern in the community forum for help. I am also
getting below error everyday. I am not sure if it is related to the bug.
Please advise.
Thu, 18 Jun 2020 14:41:13 GMT The database process was killed by the OS due
to excessive memory consumption. It is recommended to tune your database
workload and/or parameter usage to reduce memory consumption.
Thu, 18 Jun 2020 14:41:13 GMT Database could not be started due to
incompatible parameters. It is recommended to tune your parameter to reduce
memory consumption.
Regards,
Jay
PG Bug reporting form <noreply@postgresql.org> writes:
Thu, 18 Jun 2020 14:41:13 GMT The database process was killed by the OS due
to excessive memory consumption. It is recommended to tune your database
workload and/or parameter usage to reduce memory consumption.
This looks like you got hit by the dreaded OOM killer. See
https://www.postgresql.org/docs/current/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
for some background and advice.
regards, tom lane