Thread: BUG #16503: excessive memory consumption.

BUG #16503: excessive memory consumption.

From
PG Bug reporting form
Date:
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


Re: BUG #16503: excessive memory consumption.

From
Tom Lane
Date:
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