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.
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