pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: postgresql not using enough memory?
Date: Wed, 19 May 2004 18:21:00 -0400
Message-ID: <m3hduchxdf.fsf@wolfe.cbbrowne.com> (raw)
References: <p06020438bcd16fc8a146@[192.168.123.110]>

Oops! admin@usachurch.com was seen spray-painting on a wall:
> Hello list,
>
> I know this is a complicated issue, but I'll throw it out there...
> Our DB box has 3GB of ram - which is supposed to be used by
> postgres.  Whenever I use top, it only shows about 800MB being
> used with 2.2GB free.  What can I do to tell postgres to use more
> of that memory - maybe 2GB ?

The one change that might be appropriate would be to bump up sort
memory.  Not too much; 40MB is a terrifically large amount unless
you're doing REALLY enormous sorts.

Aside from that, it is quite likely that everything is AOK.
PostgreSQL benefits from having data in the filesystem cache, and if
you up the shared buffer cache, you risk having the commonly-used data
stored twice, once in the buffer cache, and once in the filesystem
cache, which is wasteful.
-- 
output = ("cbbrowne" "@" "ntlug.org")
http://cbbrowne.com/info/rdbms.html
Let me control a planet's oxygen supply and I don't care who makes the
laws.



view thread (2+ messages)

Message-ID: <m3hduchxdf.fsf@wolfe.cbbrowne.com>
Permalink:  ../m3hduchxdf.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m3hduchxdf.fsf@wolfe.cbbrowne.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-admin@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: postgresql not using enough memory?
  In-Reply-To: <m3hduchxdf.fsf@wolfe.cbbrowne.com>
  References: <p06020438bcd16fc8a146@[192.168.123.110]> <m3hduchxdf.fsf@wolfe.cbbrowne.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