Re: help tuning queries on large database - Mailing list pgsql-performance

From Harry Jackson
Subject Re: help tuning queries on large database
Date
Msg-id 45b42ce40601090740q29e441ffh6407c38f614d5b50@mail.gmail.com
Whole thread Raw
In response to Re: help tuning queries on large database  (Kelly Burkhart <kelly.burkhart@gmail.com>)
List pgsql-performance
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.org
http://www.uklug.co.uk

pgsql-performance by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: 500x speed-down: Wrong query plan?
Next
From: Szűcs Gábor
Date:
Subject: Re: Avoiding cartesian product