| 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-07 01:08:25 |
| Message-ID: | 45b42ce40601061708m1232c537tf901a806a7a3213d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 1/6/06, peter royal <peter(dot)royal(at)pobox(dot)com> wrote:
> PostgreSQL 8.1.1
>
> shared_buffers = 10000 # (It was higher, 50k, but didn't help any,
> so brought down to free ram for disk cache)
> work_mem = 8196
> random_page_cost = 3
> effective_cache_size = 250000
I have played with both disk cache settings and shared buffers and I
found that if I increased the shared buffers above a certain value
performance would increase dramatically. Playing with the effective
cache did not have the same amount of impact. I am currently running
with
shared_buffers = 254288 # approx 2.1Gb
and this is on a smaller dataset than yours.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Lang | 2006-01-07 01:18:48 | Re: help tuning queries on large database |
| Previous Message | Tom Lane | 2006-01-06 23:47:55 | Re: help tuning queries on large database |