Re: [SQL] Can we load all database objects in memory?
От | Iñigo Martinez Lasala |
---|---|
Тема | Re: [SQL] Can we load all database objects in memory? |
Дата | |
Msg-id | 1238011881.3848.94.camel@coyote обсуждение исходный текст |
Ответ на | Re: [SQL] Can we load all database objects in memory? (ries van Twisk <pg@rvt.dds.nl>) |
Список | pgsql-admin |
And I replied to all list also...
Sorry. :(
-----Original Message-----
From: ries van Twisk <pg@rvt.dds.nl>
To: DM <dm.aeqa@gmail.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [ADMIN] [SQL] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 15:07:21 -0500
Sorry. :(
-----Original Message-----
From: ries van Twisk <pg@rvt.dds.nl>
To: DM <dm.aeqa@gmail.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [ADMIN] [SQL] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 15:07:21 -0500
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 system. Ries On Mar 25, 2009, at 2:20 PM, DM 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
В списке pgsql-admin по дате отправления: