Re: Controlling Load Distributed Checkpoints - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Controlling Load Distributed Checkpoints
Date
Msg-id 466965D6.3050100@enterprisedb.com
Whole thread Raw
In response to Re: Controlling Load Distributed Checkpoints  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-hackers
Andrew Sullivan wrote:
> On Fri, Jun 08, 2007 at 09:50:49AM +0100, Heikki Linnakangas wrote:
> 
>> dynamics change. But we must also keep in mind that average DBA doesn't 
>> change any settings, and might not even be able or allowed to. That 
>> means the defaults should work reasonably well without tweaking the OS 
>> settings.
> 
> Do you mean "change the OS settings" or something else?  (I'm not
> sure it's true in any case, because shared memory kernel settings
> have to be fiddled with in many instances, but I thought I'd ask for
> clarification.)

Yes, that's what I meant. An average DBA is not likely to change OS 
settings.

You're right on the shmmax setting, though.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPYable logs status
Next
From: Tom Lane
Date:
Subject: Re: COPYable logs status