Re: Controlling Load Distributed Checkpoints

Heikki Linnakangas <heikki@enterprisedb.com>

From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-hackers@postgresql.org
Date: 2007-06-08T14:21:10Z
Lists: 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