pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Decibel! <decibel@decibel.org>
Cc: Gregory Stark <stark@enterprisedb.com>
Cc: Csaba Nagy <nagy@ecircle-ag.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Linux mis-reporting memory
Date: Tue, 2 Oct 2007 11:51:23 -0500
Message-ID: <dcc563d10710020951y6ee76521n7a8e633e7847d7c8@mail.gmail.com> (raw)
In-Reply-To: <094E11EB-8F17-4C96-993A-4AD637404F91@decibel.org>
References: <20070920230400.GM95343@decibel.org>
	<16213.1190329934@sss.pgh.pa.us>
	<87r6ksa1jb.fsf@oxford.xeocode.com>
	<1190363401.4661.116.camel@PCD12478>
	<87r6ksuzf8.fsf@oxford.xeocode.com>
	<094E11EB-8F17-4C96-993A-4AD637404F91@decibel.org>

On 10/2/07, Decibel! <decibel@decibel.org> wrote:
> On Sep 21, 2007, at 4:43 AM, Gregory Stark wrote:
> > "Csaba Nagy" <nagy@ecircle-ag.com> writes:
> >
> >> On Fri, 2007-09-21 at 09:03 +0100, Gregory Stark wrote:
> >>>>> Mem:  32945280k total, 32871832k used,    73448k free,
> >>>>> 247432k buffers
> >>>>> Swap:  1951888k total,    42308k used,  1909580k free,
> >>>>> 30294300k cached
> >>>>
> >>> It seems to imply Linux is paging out sysV shared memory. In fact
> >>> some of
> >>> Heikki's tests here showed that Linux would do precisely that.
> >>
> >> But then why is it not reporting that in the "Swap: used"
> >> section ? It
> >> only reports 42308k used swap.
> >
> > Hm, good point.
> >
> > The other possibility is that Postgres just hasn't even touched a
> > large part
> > of its shared buffers.
>
> Sorry for the late reply...
>
> No, this is on a very active database server; the working set is
> almost certainly larger than memory (probably by a fair margin :( ),
> and all of the shared buffers should be in use.
>
> I'm leaning towards "top on linux == dumb".

Yeah, that pretty much describes it.  It's gotten better than it once
was.  But it still doesn't seem to be able to tell shared memory from
cache/buffer.



view thread (16+ messages)  latest in thread

Message-ID: <dcc563d10710020951y6ee76521n7a8e633e7847d7c8@mail.gmail.com>
Permalink:  ../dcc563d10710020951y6ee76521n7a8e633e7847d7c8@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10710020951y6ee76521n7a8e633e7847d7c8@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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, decibel@decibel.org, stark@enterprisedb.com, nagy@ecircle-ag.com
  Subject: Re: Linux mis-reporting memory
  In-Reply-To: <dcc563d10710020951y6ee76521n7a8e633e7847d7c8@mail.gmail.com>
  References: <20070920230400.GM95343@decibel.org> <16213.1190329934@sss.pgh.pa.us> <87r6ksa1jb.fsf@oxford.xeocode.com> <1190363401.4661.116.camel@PCD12478> <87r6ksuzf8.fsf@oxford.xeocode.com> <094E11EB-8F17-4C96-993A-4AD637404F91@decibel.org> <dcc563d10710020951y6ee76521n7a8e633e7847d7c8@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