"Charles A. Landemaine" <landemaine@xxxxxxxxx> 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
