From: Harry Jackson <harryjackson@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: help tuning queries on large database
Date: Mon, 9 Jan 2006 15:40:31 +0000
Message-ID: <45b42ce40601090740q29e441ffh6407c38f614d5b50@mail.gmail.com> (raw)
In-Reply-To: <fa1e4ce70601090637h5425b570m4c8db256a24bb872@mail.gmail.com>
References: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
<7.0.1.0.2.20060108160633.026bd358@earthlink.net>
<fa1e4ce70601090637h5425b570m4c8db256a24bb872@mail.gmail.com>
On 1/9/06, Kelly Burkhart <kelly.burkhart@gmail.com> wrote:
> 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?
I think he means you can create a directory that mounts and area of
RAM. If you put the tables on it then it will be very fast. I would
not recommend it for anything you cannot afford to loose.
I have also tried it and found that it did not produce as good as
performance as I expected.
--
Harry
http://www.hjackson.orghttp://www.uklug.co.uk
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-performance@postgresql.org
Cc: harryjackson@gmail.com
Subject: Re: help tuning queries on large database
In-Reply-To: <45b42ce40601090740q29e441ffh6407c38f614d5b50@mail.gmail.com>
* 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