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