Re: Shared Memory Sizing - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Shared Memory Sizing
Date
Msg-id 20020627134523.L16498@mail.libertyrms.com
Whole thread Raw
In response to Re: Shared Memory Sizing  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Shared Memory Sizing  (Curt Sampson <cjs@cynic.net>)
List 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@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110




pgsql-general by date:

Previous
From: Randall Barber
Date:
Subject: Geometry Functions
Next
From: Richard Huxton
Date:
Subject: Re: script to keep views "correct"?