Re: was there a change in FreeBSD SHM implementation from

From: Vivek Khera <khera(at)kcilink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: was there a change in FreeBSD SHM implementation from
Date: 2002-07-12 14:01:18
Message-ID: 15662.57646.195189.255124@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "CS" == Curt Sampson <cjs(at)cynic(dot)net> writes:

CS> On Thu, 11 Jul 2002, Vivek Khera wrote:
>> Actually performance went down. Way down. I disagree with your
>> argument that increasing the cache will help, since the cache is not
>> needed if you don't pushd out your SHM pages in the first place and
>> need to reload them quickly.

CS> Ah, so your entire working data set can fit into your shared memory? In
CS> that case, yes, you are better off not decreasing it. I guess we should
CS> add a note to the FAQ for people using very small databases....

Sometimes it does, sometimes it does not. But I still disagree that
relying on the OS to cache pages that you could (and should) just as
well keep in the SHM segments already makes no sense.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-07-12 14:05:26 Re: MySQL vs. PostgreSQL
Previous Message Tom Lane 2002-07-12 13:39:16 Re: plpgsql Cursor Mismatched Parentheses