Re: help tuning queries on large database

On 1/6/06, peter royal <peter.royal@pobox.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.

--
Harry
http://www.hjackson.org
http://www.uklug.co.uk