From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Chantal Ackermann <chantal.ackermann@biomax.de>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] optimizing query
Date: Sun, 26 Jan 2003 19:54:25 -0500 (EST)
Message-ID: <200301270054.h0R0sP721325@candle.pha.pa.us> (raw)
In-Reply-To: <25976.1043335579@sss.pgh.pa.us>
Tom Lane wrote:
> > postgresql.conf:
> > shared_buffers: 121600
> > max_connections: 64
> > max_fsm_relations = 200
> > max_fsm_pages = 40000
> > effective_cache_size = 8000
>
> Try increasing sort_mem.
>
> Also, I'd back off on shared_buffers if I were you. There's no evidence
> that values above a few thousand buy anything.
Increasing shared_buffers above several thousand will only be a win if
your entire working set will fit in the larger buffer pool, but didn't
in the previous size. If you working set is smaller or larger than
that, pushing it above several thousand isn't a win. Is that a more
definitive answer?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
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-general@postgresql.org
Cc: pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, chantal.ackermann@biomax.de, sszabo@megazone23.bigpanda.com, pgsql-performance@postgresql.org
Subject: Re: [PERFORM] optimizing query
In-Reply-To: <200301270054.h0R0sP721325@candle.pha.pa.us>
* 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