From: Gaetano Mendola <mendola@bigfoot.com>
To: Rod Taylor <pg@rbt.ca>
Subject: Re: Page Miss Hits
Date: Tue, 03 Aug 2004 00:13:56 +0200
Message-ID: <410EBCA4.9000508@bigfoot.com> (raw)
In-Reply-To: <1091481975.36221.138.camel@jester>
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>
<1091481975.36221.138.camel@jester>
Rod Taylor wrote:
>>| 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.
I know, I know.
We were discussing about the fact that postgres use a his own cache or not;
and for the OP pleasure then if is possible retrieve hit and miss information
from that cache.
For benchmarch may be is better that you look not at the particular implementation
done in postgresql but at the general improvements that the ARC replacement
policy introduce. If I'm not wrong till now postgres was using an LRU,
around you can find some articles like these:
http://www.almaden.ibm.com/StorageSystems/autonomic_storage/ARC/rj10284.pdfhttp://www.almaden.ibm.com/cs/people/dmodha/arcfast.pdf
where are showns the improvements.
As you wrote no one did benchmarks on demostrating with the "brute force" that
ARC is better but on the paper should be.
Regards
Gaetano Mendola
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: mendola@bigfoot.com, pg@rbt.ca
Subject: Re: Page Miss Hits
In-Reply-To: <410EBCA4.9000508@bigfoot.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