Re: [GENERAL] [ADMIN] Can we load all database objects in memory?

2009-03-26 Thread Albe Laurenz
Iñigo Martinez Lasala 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? Thanks for your time and taking a look at this question. Thanks Deepak Increase effective_cache_size parameter.

Re: [GENERAL] [ADMIN] Can we load all database objects in memory?

2009-03-25 Thread Iñigo Martinez Lasala
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