Re: Hardware upgrade for a high-traffic database

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Brian Hirt <bhirt(at)mobygames(dot)com>
Cc: Jason Coene <jcoene(at)gotfrag(dot)com>, 'Postgresql Performance' <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware upgrade for a high-traffic database
Date: 2004-08-11 21:50:10
Message-ID: 1092261009.16087.101.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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!

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jason Coene 2004-08-11 22:03:40 Re: Hardware upgrade for a high-traffic database
Previous Message Rod Taylor 2004-08-11 21:46:24 Re: Hardware upgrade for a high-traffic database