Re: effective_cache_size less than shared_buffers

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: effective_cache_size less than shared_buffers
Date: 2009-02-26 01:04:07
Message-ID: 49A5EA87.2080901@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Joshua D. Drake wrote:
> On Wed, 2009-02-25 at 17:21 -0600, Kevin Grittner wrote:
>> Should we log a warning at startup when effective_cache_size is less
>> than shared_buffers?
>
> I would say no. Although I could see an argument for the default
> effective_cache_size always being the same size as shared_buffers.

That's certainly not what we've meant historically by ECS. Generally
it's been the size of shared_buffers *and* the FS cache. If it were
just the size of shared_buffers, then we wouldn't need a 2nd setting,
would we?

--Josh

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2009-02-26 01:33:20 Re: effective_cache_size less than shared_buffers
Previous Message Tom Lane 2009-02-26 00:30:30 Re: Have \d show child tables that inherit from the specified parent