"Charles A. Landemaine" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly