Re: Linux max on shared buffers?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Linux max on shared buffers?
Дата
Msg-id 20020711184308.A8033@svana.org
обсуждение исходный текст
Ответ на Re: Linux max on shared buffers?  (Curt Sampson <cjs@cynic.net>)
Ответы Re: Linux max on shared buffers?  (Curt Sampson <cjs@cynic.net>)
Re: Linux max on shared buffers?  (GB Clark <postgres@vsservices.com>)
Список 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@svana.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: Flag for insentive use of Postgres?
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: Linux max on shared buffers?