pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Guido Barosio <gbarosio@gmail.com>
Cc: Vivek_Sharan <Vivek_Sharan@infosys.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Heavy postgres process
Date: Tue, 16 Sep 2008 11:30:19 -0600
Message-ID: <dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com> (raw)
In-Reply-To: <f7f6b4c70809160737l6e05616fgdc7c5e72ed19c582@mail.gmail.com>
References: <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>
	<dcc563d10809121047n34e16435i4f57e5a20c87da0c@mail.gmail.com>
	<5465CC59A600E2408FFBF84350B9383450F4933AB6@AUSMELMBX01.ad.infosys.com>
	<dcc563d10809150853t1cd4cc44ja6ad5f7b63ce975a@mail.gmail.com>
	<5465CC59A600E2408FFBF84350B9383450F4933C33@AUSMELMBX01.ad.infosys.com>
	<f7f6b4c70809160737l6e05616fgdc7c5e72ed19c582@mail.gmail.com>

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.



view thread (20+ messages)  latest in thread

Message-ID: <dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com>
Permalink:  ../dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com

 · 

reply
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-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, gbarosio@gmail.com, Vivek_Sharan@infosys.com
  Subject: Re: Heavy postgres process
  In-Reply-To: <dcc563d10809161030u3c39a6afp91fba5c39fe128d3@mail.gmail.com>

* 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