Re: Can we load all database objects in memory?

Increase effective_cache_size parameter.

An "effective_cache_size=11GB" should be more than enough.

-----Original Message-----
From: DM <dm.aeqa@gmail.com>
To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: [ADMIN] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 12:20:08 -0700

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?   Thanks for your time and taking a look at this question.     Thanks Deepak