Postgres Pro
Downloads
Home   >   mailing lists

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

From Charles A. Landemaine
Subject Loading the entire DB into RAM
Date
Msg-id e6575a30604070737n20b2d7a4l33ba51dcbf4527a@mail.gmail.com
Whole thread Raw
Responses Re: Loading the entire DB into RAM
Re: Loading the entire DB into RAM
Re: Loading the entire DB into RAM
List pgsql-performance
Tree view 
I have a web server with PostgreSQL and RHEL. It hosts a search
engine, and each time some one makes a query, it uses the HDD Raid
array. The DB is not very big, it is less than a GB. I plan to add
more RAM anyway.

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?
Thanks,

Charles.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query planner is using wrong index.
Next
From: Richard Huxton
Date:
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and