| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Charles A(dot) Landemaine" <landemaine(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Loading the entire DB into RAM |
| Date: | 2006-04-07 15:25:14 |
| Message-ID: | 12191.1144423514@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Charles A. Landemaine" <landemaine(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-04-07 15:29:32 | Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7 |
| Previous Message | Richard Huxton | 2006-04-07 15:24:56 | Re: Spotting planner errors (was Re: Query planner is using |