Re: Shared Memory Sizing

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Shared Memory Sizing
Date: 2002-06-27 17:45:23
Message-ID: 20020627134523.L16498@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 27, 2002 at 11:27:33AM -0400, Jan Wieck wrote:

> Here I disagree. The more shared buffer cache you have, the bigger the
> percentage of your database that neither causes read()'s nor memory
> copying from the OS buffer cache.

For what it's worth, truss on Solaris 7 indicates that copying from
OS buffer costs a few milliseconds (between 2 and 8 in our tests,
depending on load), at least in our tests.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Jenkins 2002-06-27 18:17:32 Re: script to keep views "correct"?
Previous Message Richard Huxton 2002-06-27 17:34:58 Re: script to keep views "correct"?