Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] ARC Memory Usage analysis

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Greg Stark" <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] ARC Memory Usage analysis
Date: 2004-10-27 02:30:34
Message-ID: 1098844234.31930.45.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
On Mon, 2004-10-25 at 23:53, Tom Lane wrote:
> Greg Stark <gsstark(at)mit(dot)edu> writes:
> > Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> >> Another issue is what we do with the effective_cache_size value once we
> >> have a number we trust.  We can't readily change the size of the ARC
> >> lists on the fly.
> 
> > Huh? I thought effective_cache_size was just used as an factor the cost
> > estimation equation.
> 
> Today, that is true.  Jan is speculating about using it as a parameter
> of the ARC cache management algorithm ... and that worries me.

Because it's so often set wrong I take it.  But if it's set right, and
it makes the the database faster to pay attention to it, then I'd be in
favor of it.  Or at least having a switch to turn on the ARC buffer's
ability to look at it.

Or is it some other issue, having to do with the idea of knowing
effective cache size cause a positive effect overall on the ARC
algorhythm?


In response to

pgsql-performance by date

Next:From: Anjan DaveDate: 2004-10-27 03:12:20
Subject: Re: can't handle large number of INSERT/UPDATEs
Previous:From: Curt SampsonDate: 2004-10-27 01:32:13
Subject: Re: [PATCHES] ARC Memory Usage analysis

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2004-10-27 03:23:11
Subject: pg_dump test success
Previous:From: Bruce MomjianDate: 2004-10-27 01:42:19
Subject: Re: 8.0b4: COMMIT outside of a transaction echoes ROLLBACK

pgsql-patches by date

Next:From: Ed L.Date: 2004-10-27 03:27:13
Subject: Re: HP-UX PA-RISC/Itanium 64-bit Patch and HP-UX 11.23 Patch
Previous:From: Curt SampsonDate: 2004-10-27 01:32:13
Subject: Re: [PATCHES] ARC Memory Usage analysis

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group