Re: Heavy postgres process - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Heavy postgres process
Date
Msg-id dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com
Whole thread Raw
In response to Re: Heavy postgres process  ("Guido Barosio" <gbarosio@gmail.com>)
List pgsql-admin
On Tue, Sep 16, 2008 at 8:37 AM, Guido Barosio <gbarosio@gmail.com> wrote:
> On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan <Vivek_Sharan@infosys.com> wrote:
>> Thanks for the information so far

OK, I'm not BSD expert (Tom Lane might help out here) but I'm guessing
that what we see in the following lines of top:

>> 87340 postgres    2   0  7200K  1224K select 0   1:41  0.00%  0.00% postgres
>> 90961 postgres    2   0 83580K 76008K sbwait 0   0:30  0.00%  0.00% postgres
>> 90920 postgres    2   0 83636K 76068K sbwait 0   0:29  0.00%  0.00% postgres

Is that the number on the left, like 83636K is the total memory used,
and the number to the right 76068K is how much is shared buffers
etc...  which would mean that each of those processes above are using
about 7 megs a piece, and the rest is repeated.

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Help request: how to tune performance?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Setting Effective Cache Size