pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17309: Memory consumption
2+ messages / 2 participants
[nested] [flat]
* BUG #17309: Memory consumption
@ 2021-12-02 18:05 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-12-02 18:05 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: vihari.postgresdba@gmail.com
The following bug has been logged on the website:
Bug reference: 17309
Logged by: raj adi
Email address: vihari.postgresdba@gmail.com
PostgreSQL version: 13.2
Operating system: linux
Description:
Hi Team,
We are configured postgres 13.2 version in the EKS cluster. We are facing
high memory consumption. we have 60GB of RAM and with in one week almost
the memory is reaching 40 GB. I found one of the checkpointer background
process is consuming 16.1 % memory. I never seen this much memory
consumption in the postgres. Please provide any option to resolve this
memory issue. Kindly let me know if any memory leak in the postgres 13.2
version.
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
1001 101 0.0 16.1 10858488 10534144 ? Ss Nov14 17:18 postgres:
checkpointer
Thanks and Regards,
Vihari
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17309: Memory consumption
@ 2021-12-02 18:37 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 @ 2021-12-02 18:37 UTC (permalink / raw)
To: vihari.postgresdba@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> We are configured postgres 13.2 version in the EKS cluster. We are facing
> high memory consumption. we have 60GB of RAM and with in one week almost
> the memory is reaching 40 GB. I found one of the checkpointer background
> process is consuming 16.1 % memory. I never seen this much memory
> consumption in the postgres. Please provide any option to resolve this
> memory issue. Kindly let me know if any memory leak in the postgres 13.2
> version.
It seems quite unlikely that there's any actual bug here; more likely,
you are misreading the output of "ps". Many versions of ps will report
a process's use of shared memory as though it were local memory in that
process, ie ps will claim that each process is consuming the whole amount
of the shared memory, even though there's really only one copy.
Particularly with the checkpointer, which doesn't run any user-defined
code, a leak isn't very credible. I would ask first what is your
shared_buffers setting? If the checkpointer's reported memory
consumption isn't much more than that, then there's nothing to see here.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-12-02 18:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-12-02 18:05 BUG #17309: Memory consumption PG Bug reporting form <noreply@postgresql.org>
2021-12-02 18:37 ` 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