BUG #16503: excessive memory consumption.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #16503: excessive memory consumption.

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      16503
Logged by:          Jay Prakash
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

Re: BUG #16503: excessive memory consumption.

Tom Lane-2
PG Bug reporting form <[hidden email]> 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