Re: cache whole data in RAM - Mailing list pgsql-performance

From William Yu
Subject Re: cache whole data in RAM
Date
Msg-id bvrskn$sdc$1@news.hub.org
Whole thread Raw
In response to cache whole data in RAM  (David Teran <david.teran@cluster9.com>)
List pgsql-performance
David Teran wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>

Upon bootup, automatically run "SELECT * FROM xyz" on every table in
your database.


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Compile Vs RPMs
Next
From: Mark Harrison
Date:
Subject: select is not using index?