Re: Why does "checkpointer" is consumig ~1.2Gb of RAM? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Why does "checkpointer" is consumig ~1.2Gb of RAM?
Date
Msg-id CAOR=d=0GKjyia_WPdA+P41Z-UQLOBRJ34zfoL4VKDA=rK3DtnA@mail.gmail.com
Whole thread Raw
In response to Re: Why does "checkpointer" is consumig ~1.2Gb of RAM?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Why does "checkpointer" is consumig ~1.2Gb of RAM?
List pgsql-general
It's not. If the RES shows 1215M And the SHR is 1214M, then checkpointer is only using 1M. The difference between the two is the shared memory. RES includes SHR.


On Mon, Mar 31, 2014 at 1:44 PM, Edson Richter <edsonrichter@hotmail.com> wrote:
Em 31/03/2014 00:38, Scott Marlowe escreveu:

On Sun, Mar 30, 2014 at 8:43 PM, Edson Richter <edsonrichter@hotmail.com> wrote:
I'm curious about the "checkpointer" process and its configuration.
What are the configuration options that affects the checkpointer process?
Currently, under load, this process goes up to about 1.2GB of RAM:




--


No it really doesn't. VIRT is every thing it touches whether it uses it individually or with other processes. RES is what THIS process is using all by itself. SHR is what it's accessing of shared memory. Here's a short explanation of what those three values mean: http://linuxpoison.blogspot.com/2009/10/what-is-difference-among-virt-res-and.html

Also for a more technical one run "man top" and search for RES, SHR, and VIRT

Yes, I understand that. That's why I've asked: why is checkpointer process consuming 1.2Gb of RAM (1215M RES more precisely), and which parameter affects its memory consumption?

Thanks,

Edson


--

Edson Carlos Ericksson Richter
Sistemas para Bibliotecas, Escolinhas Infantis
Projetos sob medida para sua empresa
Celular:(51) 9318-9766
(51) 8585-0796
"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho original"
- Albert Einstein




--
To understand recursion, one must first understand recursion.
Attachment

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: getting the current query from pg_stat_activity
Next
From: Tom Lane
Date:
Subject: Re: Wanted: ALTER TRIGGER ... OWNED BY EXTENSION