pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16503: excessive memory consumption.
2+ messages / 2 participants
[nested] [flat]

* BUG #16503: excessive memory consumption.
@ 2020-06-18 21:33  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-06-18 21:33 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: jaypeeid@gmail.com

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16503: excessive memory consumption.
@ 2020-06-18 21:50  Tom Lane <tgl@sss.pgh.pa.us>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2020-06-18 21:50 UTC (permalink / raw)
  To: jaypeeid@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-06-18 21:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-18 21:33 BUG #16503: excessive memory consumption. PG Bug reporting form <noreply@postgresql.org>
2020-06-18 21:50 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox