Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we load all database objects in memory? - Mailing list pgsql-admin

From Iñigo Martinez Lasala
Subject Re: Can we load all database objects in memory?
Date
Msg-id 1238011785.3848.93.camel@coyote
Whole thread Raw
In response to Can we load all database objects in memory?  (DM <dm.aeqa@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: ries van Twisk
Date:
Subject: Re: [SQL] Can we load all database objects in memory?
Next
From: Iñigo Martinez Lasala
Date:
Subject: Re: [SQL] Can we load all database objects in memory?