Re: help tuning queries on large database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 1/9/06, Kelly Burkhart <kelly.burkhart@xxxxxxxxx> wrote:
> On 1/8/06, Ron <rjpeace@xxxxxxxxxxxxx> 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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux