From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: yli@rsa.com
Subject: BUG #16831: Idle postgres processes on Linux consumes huge amount of memory
Date: Wed, 20 Jan 2021 21:04:56 +0000
Message-ID: <16831-c341255cd0d97a74@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16831
Logged by: Yaqing Li
Email address: yli@rsa.com
PostgreSQL version: Unsupported/Unknown
Operating system: Suse Linux
Description:
We are still using postgresql 9.4.1, however, it looks the same issue as in
9.5 as someone reported:
https://www.postgresql.org/account/reset/NzAyMjY-5ng-2bb43dc39c9c2c644a7a/
We have some client side read only user run report against the database
using ADODB. On a 16GB system, when the memory setting for database is as
following.
shared_buffers = 3840MB
effective_cache_size = 8GB
max_connections = 200
work_mem = 80MB
maintenance_work_mem = 960MB
The memory consumption for each postgres process is like this:
PID=11152 - Swap used: 3736 KB - (postgres)
PID=3380 - Swap used: 1580 KB - (postgres)
PID=11150 - Swap used: 1568 KB - (postgres)
PID=11147 - Swap used: 1352 KB - (postgres)
PID=3382 - Swap used: 660 KB - (postgres)
The system works fine with that,
But after we changed the system memory to 32GB, and adjusted the database
memory to the following:
shared_buffers = 7680MB
effective_cache_size = 16GB
max_connections = 200
work_mem = 160MB
maintenance_work_mem = 1920MB
The postgres process consume huge memory as following for the same database
size
PID=6840 - Swap used: 145860 KB - (postgres)
PID=6842 - Swap used: 142564 KB - (postgres)
PID=6841 - Swap used: 141620 KB - (postgres)
So it looks to me there is a bug in PostgresSql about the memory allocation,
is it fixed in any version?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, yli@rsa.com
Subject: Re: BUG #16831: Idle postgres processes on Linux consumes huge amount of memory
In-Reply-To: <16831-c341255cd0d97a74@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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