| From: | Harry Jackson <harryjackson(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: help tuning queries on large database |
| Date: | 2006-01-09 15:40:31 |
| Message-ID: | 45b42ce40601090740q29e441ffh6407c38f614d5b50@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 1/9/06, Kelly Burkhart <kelly(dot)burkhart(at)gmail(dot)com> wrote:
> 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?
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2006-01-09 15:48:21 | Re: Stats collector performance improvement |
| Previous Message | Jaime Casanova | 2006-01-09 15:30:21 | Re: 500x speed-down: Wrong query plan? |