From: Harry Jackson <harryjackson@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: help tuning queries on large database
Date: Sat, 7 Jan 2006 01:08:25 +0000
Message-ID: <45b42ce40601061708m1232c537tf901a806a7a3213d@mail.gmail.com> (raw)
In-Reply-To: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
References: <FC9B7CC4-F469-4BF5-8862-332E6C26BEA5@pobox.com>
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.orghttp://www.uklug.co.uk
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: harryjackson@gmail.com
Subject: Re: help tuning queries on large database
In-Reply-To: <45b42ce40601061708m1232c537tf901a806a7a3213d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox