| From: | Maksim Milyutin <milyutinma(at)gmail(dot)com> |
|---|---|
| To: | Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: "checkpointer process" is consuming more memory. How to control it? |
| Date: | 2018-08-22 14:43:30 |
| Message-ID: | 0c876e93-3842-da88-3a7e-c574711e9522@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
22.08.2018 16:43, Raghavendra Rao J S V wrote:
> We have a database cluster as "db1_data". Under this cluster we have
> two databases. one is *db1 *and other is *qovr*. I surprised to see as
> "checkpointer process" is consuming 8.73GB of memory(RSS value as
> 9158892). Why "checkpointer process" is consuming this much amount of
> memory and how to limit the usage of the "checkpointer process" memory.
RSS value is not reasonable to determine memory leaks because it takes
into account shared segments (e.g. from shared buffer cache). As a
long-lived process checkpointer process tries to flush and as a
consequence to touch each buffer cell therefore its RSS approaches to
local allocated memory plus shared_buffers.
If you want to know the real local memory consumption you may to use
python utility *smem* to see unshared local memory size.
--
Regards,
Maksim Milyutin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Gauthier | 2018-08-22 15:56:14 | Can Pg somehow recognize/honor linux groups to control user access ? |
| Previous Message | Avi Vallarapu | 2018-08-22 14:14:48 | Re: "checkpointer process" is consuming more memory. How to control it? |