Re: Heavy postgres process

On Tue, Sep 16, 2008 at 8:37 AM, Guido Barosio <gbarosio(at)gmail(dot)com> wrote:
> On Tue, Sep 16, 2008 at 1:41 AM, Vivek_Sharan <Vivek_Sharan(at)infosys(dot)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.