Re: Memory issue on FreeBSD

From: Achilleas Mantzios <achill(at)smadev(dot)internal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Vick Khera <vivek(at)khera(dot)org>
Subject: Re: Memory issue on FreeBSD
Date: 2012-11-07 08:16:43
Message-ID: 4470191.e3N54GRWLd@smadev.internal.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vick,
fantastic script, thanx! FreeBSD sysctl system is awesome!

On Τρι 06 Νοε 2012 14:33:43 Vick Khera wrote:

On Mon, Nov 5, 2012 at 10:11 AM, Frank Broniewski <brfr(at)metrico(dot)lu> wrote:

and this is after a few hours of running:

Mem: 91M Active, 17G Inact, 3983M Wired, 1526M Cache, 3283M Buf, 155M Free
Swap: 4096M Total, 828K Used, 4095M Free

For comparison, here is the output of a 32GB FreeBSD 9.0/amd64 server, with Postgres 9.0.7 running since June 10, and is heavily pounded on 24x7. The data + indexes are about 240GB on disk. This server only runs postgres aside from the basic system processes.

Mem: 231M Active, 21G Inact, 3777M Wired, 1009M Cache, 3285M Buf, 191M Free
Swap: 4096M Total, 272K Used, 4096M Free

I agree with the conclusion that the shared memory segments are confusing the output of top. There are no memory leaks, and FreeBSD doesn't "lose" any memory.

There are some scripts floating around that read values from sysctl vm.stats.vm and format them nicely to tell you how much memory is used up and free. Try the one referenced here: http://www.cyberciti.biz/faq/freebsd-command-to-get-ram-information/

-
Achilleas Mantzios
IT DEPT

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2012-11-07 08:21:04 Re: Comparing txid_current() to xmin
Previous Message Yvon Thoraval 2012-11-07 07:57:45 Re: creating a function returning FALSE on NULL input ?