| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Thomas Finneid <tfinneid(at)fcon(dot)no> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: caching indexes and pages? |
| Date: | 2009-01-22 15:34:29 |
| Message-ID: | 603c8f070901220734k616e9fd2vc42604ebbcbbf449@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> I tried work_mem and maintenance_work_mem but it does not seem to make much
> difference yet. Admittedly I had set it to 100M and 80M, so after reading a
> little bit more I have found that I could easily set it to several GBs. But
> I am not sure those are the correct config parameters to use for this. I
> havent found any others that are relevant so far.
You probably want to increase shared_buffers by quite a large amount
and maybe make work_mem not quite so big.
If you have 2GB of memory you might set shared_buffers to 1GB,
work_mem 16MB, maintenance_work_mem 64MB?
...Robert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Baguette | 2009-01-22 15:36:31 | Slow HashAggregate : How to optimize ? |
| Previous Message | Thomas Finneid | 2009-01-22 12:35:31 | Re: caching written values? |