From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Timothy D. Witham <wookie@osdl.org>
Cc: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org
Cc: testperf-general@pgfoundry.org
Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability
Date: Fri, 15 Oct 2004 12:57:35 -0400 (EDT)
Message-ID: <200410151657.i9FGvZQ13745@candle.pha.pa.us> (raw)
In-Reply-To: <10202.1097858894@sss.pgh.pa.us>
Tom Lane wrote:
> > I've been thinking about implementing a scheme that helps you decide how
> > big the shared_buffers SHOULD BE, by making the LRU list bigger than the
> > cache itself, so you'd be able to see whether there is beneficial effect in
> > increasing shared_buffers.
>
> ARC already keeps such a list --- couldn't you learn what you want to
> know from the existing data structure? It'd be fairly cool if we could
> put out warnings "you ought to increase shared_buffers" analogous to the
> existing facility for noting excessive checkpointing.
Agreed. ARC already keeps a list of buffers it had to push out recently
so if it needs them again soon it knows its sizing of recent/frequent
might be off (I think). Anyway, such a log report would be super-cool,
say if you pushed out a buffer and needed it very soon, and the ARC
buffers are already at their maximum for that buffer pool.
--
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-performance@postgresql.org
Cc: pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, simon@2ndquadrant.com, wookie@osdl.org, josh@agliodbs.com, testperf-general@pgfoundry.org
Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability
In-Reply-To: <200410151657.i9FGvZQ13745@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