Reading the database in RAM

From: vitthal <vitthal(at)discerncomm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reading the database in RAM
Date: 2001-09-22 01:29:14
Message-ID: 3BABE969.C69E6B63@discerncomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. My database is around 200MB and could
easily be pinned into RAM.
thanks

vitthal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2001-09-22 04:36:47 Tupple statistics function
Previous Message vitthal 2001-09-22 01:23:07 Reading the database in RAM