From: Rod Taylor <pg@rbt.ca>
To: Brian Hirt <bhirt@mobygames.com>
Cc: Jason Coene <jcoene@gotfrag.com>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Hardware upgrade for a high-traffic database
Date: Wed, 11 Aug 2004 17:50:10 -0400
Message-ID: <1092261009.16087.101.camel@jester> (raw)
In-Reply-To: <DA21B257-EBDD-11D8-AF1E-000D93AD2E74@mobygames.com>
References: <200408112118.i7BLIR0E097522@mail.gotfrag.com>
<DA21B257-EBDD-11D8-AF1E-000D93AD2E74@mobygames.com>
On Wed, 2004-08-11 at 17:31, Brian Hirt wrote:
> On Aug 11, 2004, at 3:18 PM, Jason Coene wrote:
> >
> > I'm wondering why our PG server is using so little memory... The
> > system has
> > 2GB of memory, though only around 200MB of it are used. Is there a PG
> > setting to force more memory usage towards the cache? Additionally,
> > we use
> > FreeBSD. I've heard that Linux may manage that memory better, any
> > truth
> > there? Sorry if I'm grabbing at straws here :)
> >
>
> i don't know about freebsd, but linux is very aggressive about using
> unused memory for disk cache. we have dedicated linux box running pg
Aggressive indeed.. I'm stuck with the version that has a tendency to
swap out active processes rather than abandon disk cache -- it gets very
annoying!
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@rbt.ca, bhirt@mobygames.com, jcoene@gotfrag.com
Subject: Re: Hardware upgrade for a high-traffic database
In-Reply-To: <1092261009.16087.101.camel@jester>
* 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