Loading the entire DB into RAM

From: "Charles A(dot) Landemaine" <landemaine(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Loading the entire DB into RAM
Date: 2006-04-07 14:37:34
Message-ID: e6575a30604070737n20b2d7a4l33ba51dcbf4527a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2006-04-07 14:40:51 Re: Same SQL, 104296ms of difference between 7.4.12 and
Previous Message Tom Lane 2006-04-07 14:34:53 Re: Query planner is using wrong index.