Re: help tuning queries on large database

From: Kelly Burkhart <kelly(dot)burkhart(at)gmail(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: help tuning queries on large database
Date: 2006-01-09 14:37:04
Message-ID: fa1e4ce70601090637h5425b570m4c8db256a24bb872@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 1/8/06, Ron <rjpeace(at)earthlink(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matteo Beccati 2006-01-09 15:02:18 Re: 500x speed-down: Wrong query plan?
Previous Message Alessandro Baretta 2006-01-09 13:51:27 500x speed-down: Wrong query plan?