From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: ries van Twisk <pg@rvt.dds.nl>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: [SQL] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 21:11:21 +0100
Message-ID: <1238011881.3848.94.camel@coyote> (raw)
In-Reply-To: <587E5DF3-5859-48DE-93F9-F7B05C37E6D8@rvt.dds.nl>
References: <eae6a62a0903251220p2edd379en50d17541edef065f@mail.gmail.com>
<587E5DF3-5859-48DE-93F9-F7B05C37E6D8@rvt.dds.nl>
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
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com, pg@rvt.dds.nl
Subject: Re: [SQL] Can we load all database objects in memory?
In-Reply-To: <1238011881.3848.94.camel@coyote>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox