Re: Scaling further up

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Scaling further up
Date: 2004-03-15 20:09:31
Message-ID: 20040315200930.GA2921@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Mar 12, 2004 at 06:25:48PM -0500, Anjan Dave wrote:
> We upgraded from 8GB to 12GB RAM a month or so ago, but even in the
> past, I've never seen the system exhaust on it's system cache (~6GB, in
> 'top'), while it's swapping.
>
> Some one had mentioned why not have the entire DB in memory? How do I
> configure that, for knowledge?

You don't. It'll automatically be in memory if (a) you have enough
memory, (b) you don't have anything else on the machine using the
memory, and (c) it's been read at least one time.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Davies 2004-03-15 20:28:35 Re: Scaling further up
Previous Message Arjen van der Meijden 2004-03-15 18:54:21 Re: Large CASE-statement is pretty slow?