Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory
On Wed, Mar 25, 2009 at 1:20 PM, DM dm.a...@gmail.com wrote:
Hi All,
I have a database of 10GB.
My Database Server has a RAM of 16GB
Is there a way that I can load all the database objects to memory?
Just replying to pgsql-general...
Yeah, just select * from table for each table, then
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory