Linux mis-reporting memory

From: Decibel! <decibel(at)decibel(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Linux mis-reporting memory
Date: 2007-09-20 23:04:01
Message-ID: 20070920230400.GM95343@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sorry, I know this is probably more a linux question, but I'm guessing
that others have run into this...

I'm finding this rather interesting report from top on a Debian box...

Mem: 32945280k total, 32871832k used, 73448k free, 247432k buffers
Swap: 1951888k total, 42308k used, 1909580k free, 30294300k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
12492 postgres 15 0 8469m 8.0g 8.0g S 0 25.6 3:52.03 postmaster
7820 postgres 16 0 8474m 4.7g 4.7g S 0 15.1 1:23.72 postmaster
21863 postgres 15 0 8472m 3.9g 3.9g S 0 12.4 0:30.61 postmaster
19893 postgres 15 0 8471m 2.4g 2.4g S 0 7.6 0:07.54 postmaster
20423 postgres 17 0 8472m 1.4g 1.4g S 0 4.4 0:04.61 postmaster
26395 postgres 15 0 8474m 1.1g 1.0g S 1 3.4 0:02.12 postmaster
12985 postgres 15 0 8472m 937m 930m S 0 2.9 0:05.50 postmaster
26806 postgres 15 0 8474m 787m 779m D 4 2.4 0:01.56 postmaster

This is a machine that's been up some time and the database is 400G, so
I'm pretty confident that shared_buffers (set to 8G) should be
completely full, and that's what that top process is indicating.

So how is it that linux thinks that 30G is cached?
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-09-20 23:12:14 Re: Linux mis-reporting memory
Previous Message Kamen Stanev 2007-09-20 21:36:59 query io stats and finding a slow query