Increase effective_cache_size parameter. An "effective_cache_size=11GB" should be more than enough.
-----Original Message----- From: DM <dm.a...@gmail.com> To: pgsql-ad...@postgresql.org, pgsql-general@postgresql.org, pgsql-...@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