pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <200410151657.i9FGvZQ13745@candle.pha.pa.us>
Permalink:  ../200410151657.i9FGvZQ13745@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200410151657.i9FGvZQ13745@candle.pha.pa.us

 · 

reply

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