Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3422F6405FA
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Mar 2009 17:24:33 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 76085-01-9
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 25 Mar 2009 17:24:20 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62])
	by mail.postgresql.org (Postfix) with ESMTP id 6237064036F
	for <pgsql-admin@postgresql.org>; Wed, 25 Mar 2009 17:21:05 -0300 (ADT)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by hermes.vectorsf.com (Postfix) with ESMTP id 8F13E11C023C;
	Wed, 25 Mar 2009 21:11:24 +0100 (CET)
X-Virus-Scanned: amavisd-new at hermes.vectorsf.com
Received: from hermes.vectorsf.com ([127.0.0.1])
	by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 9yGKZv9yRwxx; Wed, 25 Mar 2009 21:11:19 +0100 (CET)
Received: from [192.168.1.21] (248.Red-88-1-38.dynamicIP.rima-tde.net
	[88.1.38.248])
	by hermes.vectorsf.com (Postfix) with ESMTP id 813FD11C020B;
	Wed, 25 Mar 2009 21:11:19 +0100 (CET)
Subject: Re: [SQL] Can we load all database objects in memory?
From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala <imartinez@vectorsf.com>
To: ries van Twisk <pg@rvt.dds.nl>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
In-Reply-To: <587E5DF3-5859-48DE-93F9-F7B05C37E6D8@rvt.dds.nl>
References: <eae6a62a0903251220p2edd379en50d17541edef065f@mail.gmail.com>
	<587E5DF3-5859-48DE-93F9-F7B05C37E6D8@rvt.dds.nl>
Content-Type: multipart/alternative; boundary="=-McFKuN8LhTeO2WuFCbc9"
Date: Wed, 25 Mar 2009 21:11:21 +0100
Message-Id: <1238011881.3848.94.camel@coyote>
Mime-Version: 1.0
X-Mailer: Evolution 2.26.0 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/229
X-Sequence-Number: 31729


--=-McFKuN8LhTeO2WuFCbc9
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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








--=-McFKuN8LhTeO2WuFCbc9
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.26.0">
</HEAD>
<BODY>
And I replied to all list also...<BR>
Sorry. :(<BR>
<BR>
-----Original Message-----<BR>
<B>From</B>: ries van Twisk &lt;<A HREF="mailto:ries%20van%20Twisk%20%3cpg@rvt.dds.nl%3e">pg@rvt.dds.nl</A>&gt;<BR>
<B>To</B>: DM &lt;<A HREF="mailto:DM%20%3cdm.aeqa@gmail.com%3e">dm.aeqa@gmail.com</A>&gt;<BR>
<B>Cc</B>: <A HREF="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</A>, <A HREF="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.org</A>, <A HREF="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</A><BR>
<B>Subject</B>: Re: [ADMIN] [SQL] Can we load all database objects in memory?<BR>
<B>Date</B>: Wed, 25 Mar 2009 15:07:21 -0500<BR>
<BR>
<PRE>
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:

&gt; Hi All,
&gt;
&gt; I have a database of 10GB.
&gt; My Database Server has a RAM of 16GB
&gt;
&gt; Is there a way that I can load all the database objects to memory?
&gt;
&gt; Thanks for your time and taking a look at this question.
&gt;
&gt;
&gt; Thanks
&gt; Deepak







</PRE>
</BODY>
</HTML>

--=-McFKuN8LhTeO2WuFCbc9--