X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id AA2F89DC8AD
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon,  9 Jan 2006 10:37:03 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 78453-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon,  9 Jan 2006 10:37:06 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.197])
	by postgresql.org (Postfix) with ESMTP id 9592F9DC896
	for <pgsql-performance@postgresql.org>;
	Mon,  9 Jan 2006 10:37:00 -0400 (AST)
Received: by xproxy.gmail.com with SMTP id s14so2527128wxc
	for <pgsql-performance@postgresql.org>;
	Mon, 09 Jan 2006 06:37:05 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=EgZyn9uqc7KhGG6DeGRR8T+IbXTdQgu5VXT2EC6MyifiFL9mgrDlTR1LSv4X4yZo0eAE6mq9xfC2VHBJJfKcPxpQ4N7TWzVMraUb75MHHJpXWddtjGyJxrc61Usj8lQrsgwEse3TJWu8AY0YAaaQenm+Bs9wGlXpSEJOPdHMr8w=
Received: by 10.70.47.7 with SMTP id u7mr3827807wxu;
	Mon, 09 Jan 2006 06:37:05 -0800 (PST)
Received: by 10.70.14.7 with HTTP; Mon, 9 Jan 2006 06:37:04 -0800 (PST)
Message-ID: <fa1e4ce70601090637h5425b570m4c8db256a24bb872@mail.gmail.com>
Date: Mon, 9 Jan 2006 08:37:04 -0600
From: Kelly Burkhart <kelly.burkhart@gmail.com>
To: Ron <rjpeace@earthlink.net>
Subject: Re: help tuning queries on large database
Cc: pgsql-performance@postgresql.org
In-Reply-To: <7.0.1.0.2.20060108160633.026bd358@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_22338_28722305.1136817424951"
References: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
	<7.0.1.0.2.20060108160633.026bd358@earthlink.net>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200601/56
X-Sequence-Number: 16534

------=_Part_22338_28722305.1136817424951
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 1/8/06, Ron <rjpeace@earthlink.net> wrote:
>
> <snip>
> Among the other tricks having lots of RAM allows:
> If some of your tables are Read Only or VERY rarely written to, you
> can preload them at boot time and make them RAM resident using the
> /etc/tmpfs trick.


What is the /etc/tmpfs trick?

-K

------=_Part_22338_28722305.1136817424951
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 1/8/06, <b class=3D"gmail_sendername">Ron</b> &lt;<a href=3D"mailto:rjpe=
ace@earthlink.net">rjpeace@earthlink.net</a>&gt; wrote:<div><span class=3D"=
gmail_quote"></span><blockquote class=3D"gmail_quote" style=3D"border-left:=
 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex=
;">
&lt;snip&gt;<br>Among the other tricks having lots of RAM allows:<br>If som=
e of your tables are Read Only or VERY rarely written to, you<br>can preloa=
d them at boot time and make them RAM resident using the<br>/etc/tmpfs tric=
k.
</blockquote><div><br>
What is the /etc/tmpfs trick?<br>
<br>
-K <br>
</div><br></div><br>

------=_Part_22338_28722305.1136817424951--