pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Mark Kirkwood <markir@paradise.net.nz>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Date: Tue, 21 Mar 2006 23:03:26 +1200
Message-ID: <441FDD7E.7050106@paradise.net.nz> (raw)
In-Reply-To: <20060321103219.GD15742@pervasive.com>
References: <20060317221116.GA14661@juniper.net>
	<8F6490E1-64E2-406B-A559-7DA8BA1EB197@khera.org>
	<20060321103219.GD15742@pervasive.com>

Jim C. Nasby wrote:
> On Mon, Mar 20, 2006 at 02:15:22PM -0500, Vivek Khera wrote:
> 
>>I think FreeBSD has a hard upper limit on the total ram it will use  
>>for disk cache.  I haven't been able to get reliable, irrefutable,  
>>answers about it, though.
> 
> 
> It does not. Any memory in the inactive queue is effectively your 'disk
> cache'. Pages start out in the active queue, and if they aren't used
> fairly frequently they will move into the inactive queue. From there
> they will be moved to the cache queue, but only if the cache queue falls
> below a certain threshold, because in order to go into the cache queue
> the page must be marked clean, possibly incurring a write to disk. AFAIK
> pages only go into the free queue if they have been completely released
> by all objects that were referencing them, so it's theoretically
> posisble for that queue to go to 0.

Exactly.

The so-called limit (controllable via various sysctl's) is on the amount 
of memory used for kvm mapped pages, not cached pages, i.e - its a 
subset of the cached pages that are set up for immediate access (the 
others require merely to be shifted from the 'Inactive' queue to this 
one before they can be operated on - a relatively cheap operation).

So its really all about accounting, in a sense - whether pages end up in 
the 'Buf' or 'Inactive' queue, they are still cached!

Cheers

Mark

view thread (46+ messages)  latest in thread

Message-ID: <441FDD7E.7050106@paradise.net.nz>
Permalink:  ../441FDD7E.7050106@paradise.net.nz/
Also on:    postgresql.org/message-id/441FDD7E.7050106@paradise.net.nz

copy link · copy postgr.es

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: markir@paradise.net.nz, jnasby@pervasive.com, vivek@khera.org
  Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
  In-Reply-To: <441FDD7E.7050106@paradise.net.nz>

* 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