Put it on a RAM disk.

chris


On Tue, 2004-02-03 at 07:54, 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
> 


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to