Postgres Pro
Downloads
Home   >   mailing lists

cache whole data in RAM - Mailing list pgsql-performance

From David Teran
Subject cache whole data in RAM
Date
Msg-id 13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com
Whole thread Raw
Responses Re: cache whole data in RAM  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
Re: cache whole data in RAM  (Bruno Wolff III <bruno@wolff.to>)
Re: cache whole data in RAM  (Chris Trawick <ctrawick@cultured.net>)
Re: cache whole data in RAM  (William Yu <wyu@talisys.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Czuczy Gergely
Date:
Subject: PQexecParams and types
Next
From: Shridhar Daithankar
Date:
Subject: Re: cache whole data in RAM