cache whole data in RAM

From: David Teran <david(dot)teran(at)cluster9(dot)com>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: cache whole data in RAM
Date: 2004-02-03 12:54:17
Message-ID: 13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

we are trying to speed up a database which has about 3 GB of data. The
server has 8 GB RAM and we wonder how we can ensure that the whole DB
is read into RAM. We hope that this will speed up some queries.

regards David

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2004-02-03 13:26:06 Re: cache whole data in RAM
Previous Message Kevin Brown 2004-02-03 10:57:46 Re: COPY from question