Reading the database in RAM - Mailing list pgsql-general

From vitthal
Subject Reading the database in RAM
Date
Msg-id 3BABE7FA.FD81760A@discerncomm.com
Whole thread Raw
List pgsql-general
Is there any way of reading the whole database into memory? By changing
the
number of shared buffers the first query still takes long time and the
subsequent similar queries are fast.
If there is way of pinning the database in the memory all similar
queries will
take the same time.
thanks


pgsql-general by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Re: backend stalls
Next
From: Stephan Szabo
Date:
Subject: Re: what is wrong with this SQL?