Re: Scaling further up - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Scaling further up
Date
Msg-id 20040315200930.GA2921@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Scaling further up  ("Anjan Dave" <adave@vantage.com>)
Responses Re: Scaling further up  (Matt Davies <matt@mattdavies.net>)
List 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@crankycanuck.ca

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Large CASE-statement is pretty slow?
Next
From: "Rosser Schwarz"
Date:
Subject: atrocious update performance