pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rod Taylor <pg@rbt.ca>
To: Gaetano Mendola <mendola@bigfoot.com>
Cc: Scott Marlowe <smarlowe@qwest.net>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Page Miss Hits
Date: Mon, 02 Aug 2004 17:26:16 -0400
Message-ID: <1091481975.36221.138.camel@jester> (raw)
In-Reply-To: <410EA90C.7030707@bigfoot.com>
References: <Pine.GSO.4.58.0408021111320.12597@calliope>
	<1091463567.27166.44.camel@localhost.localdomain>
	<410E6F34.6040300@bigfoot.com>
	<1091468476.27166.48.camel@localhost.localdomain>
	<410EA90C.7030707@bigfoot.com>

> | ARC still helps, since it makes sure the shared_buffers don't all get
> | flushed from the useful small datasets when a seq scan gets executed.
> 
> I'm still not convinced. Why the last backend alive, have to throw away
> bunch of memory copied in the SHM? And again, the ARC is a replacement
> policy for a cache, which one ?

As you know, ARC is a recent addition. I've not seen any benchmarks
demonstrating that the optimal SHARED_BUFFERS setting is different today
than it was in the past.

We know it's changed, but the old buffer strategy had an equally hard
time with a small buffer as it did a large one. Does that mean the
middle of the curve is still at 15k buffers but the extremes are handled
better? Or something completely different?

Please feel free to benchmark 7.5 (OSDL folks should be able to help us
as well) and report back.




view thread (6+ messages)  latest in thread

Message-ID: <1091481975.36221.138.camel@jester>
Permalink:  ../1091481975.36221.138.camel@jester/
Also on:    postgresql.org/message-id/1091481975.36221.138.camel@jester

 · 

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: pg@rbt.ca, mendola@bigfoot.com, smarlowe@qwest.net
  Subject: Re: Page Miss Hits
  In-Reply-To: <1091481975.36221.138.camel@jester>

* 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