Re: Controlling Load Distributed Checkpoints

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Controlling Load Distributed Checkpoints
Date: 2007-06-08 14:21:10
Message-ID: 466965D6.3050100@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-06-08 14:29:03 Re: COPYable logs status
Previous Message Tom Lane 2007-06-08 14:16:25 Re: COPYable logs status

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-06-08 14:29:03 Re: COPYable logs status
Previous Message Tom Lane 2007-06-08 14:16:25 Re: COPYable logs status