From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Scaling further up
Date: Mon, 15 Mar 2004 15:09:31 -0500
Message-ID: <20040315200930.GA2921@phlogiston.dyndns.org> (raw)
In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098062@vt-pe2550-001.vantage.vantage.com>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098062@vt-pe2550-001.vantage.vantage.com>
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
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: ajs@crankycanuck.ca
Subject: Re: Scaling further up
In-Reply-To: <20040315200930.GA2921@phlogiston.dyndns.org>
* 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