Re: Linux max on shared buffers?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Curt Sampson <cjs(at)cynic(dot)net>
Cc: Glen Parker <glenebob(at)nwlink(dot)com>, Pg-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Linux max on shared buffers?
Date: 2002-07-11 08:43:08
Message-ID: 20020711184308.A8033@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 11, 2002 at 05:07:29PM +0900, Curt Sampson wrote:
> Let's walk through an example. I have four pages total for caching.
> Let's look at a read scenario based on two for postgres and two for the
> OS, and one for postgres and three for the OS. Pn is a postgres buffer
> and OSn is an OS buffer; the numbers below those show which disk blocks
> are in which caches. We'll use an LRU algorithm for both caches and read
> the blocks in this order: 1 2 3 2 1 2 3.

Hmm, what about OS's that swap shared memory to disk. Wouldn't that change
things somewhat? Probably more in favour of giving more memory to the OS.

The other possibility would be to use mmap instead. That way you avoid the
double buffering altogether. Do you have any ideas about that?

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Curt Sampson 2002-07-11 09:04:20 Re: Linux max on shared buffers?
Previous Message Stephane Bortzmeyer 2002-07-11 08:33:19 Re: Flag for insentive use of Postgres?