Re: Loading the entire DB into RAM - Mailing list pgsql-performance

From Tom Lane
Subject Re: Loading the entire DB into RAM
Date
Msg-id 12191.1144423514@sss.pgh.pa.us
Whole thread Raw
In response to Loading the entire DB into RAM  ("Charles A. Landemaine" <landemaine@gmail.com>)
List pgsql-performance
"Charles A. Landemaine" <landemaine@gmail.com> writes:
> What I'd like to do is find out how to keep the whole DB in RAM so
> that each time some one does a query, it doesn't use the HDD. Is it
> possible, if so, how?

That should happen essentially for free, if the kernel doesn't have any
better use for the memory --- anything read from disk once will stay in
kernel disk cache.  Perhaps you need to take a closer look at your
kernel VM parameters.  Or maybe you don't have enough RAM yet for both
the DB contents and the processes you need to run.

            regards, tom lane

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Spotting planner errors (was Re: Query planner is using
Next
From: Tom Lane
Date:
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7