From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, "Greg Smith" <gsmith(at)gregsmith(dot)com> |
Subject: | Re: Controlling Load Distributed Checkpoints |
Date: | 2007-06-06 14:14:14 |
Message-ID: | 87lkexf9vt.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:
> GUC summary and suggested default values
> ----------------------------------------
> checkpoint_write_percent = 50 # % of checkpoint interval to spread out writes
> checkpoint_write_min_rate = 1000 # minimum I/O rate to write dirty
> buffers at checkpoint (KB/s)
I don't understand why this is a min_rate rather than a max_rate.
> checkpoint_nap_duration = 2 # delay between write and sync phase, in seconds
Not a comment on the choice of guc parameters, but don't we expect useful
values of this to be much closer to 30 than 0? I understand it might not be
exactly 30.
Actually, it's not so much whether there's any write traffic to the data files
during the nap that matters, it's whether there's more traffic during the nap
than during the 30s or so prior to the nap. As long as it's a steady-state
condition it shouldn't matter how long we wait, should it?
> checkpoint_fsync_period = 30 # duration of the sync phase, in seconds
> checkpoint_fsync_delay = 500 # max. delay between fsyncs
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-06-06 14:21:32 | Re: Implicit casts with generic arrays |
Previous Message | Florian G. Pflug | 2007-06-06 14:11:13 | [RFC] GSoC Work on readonly queries done so far |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-06-06 15:03:25 | Re: Controlling Load Distributed Checkpoints |
Previous Message | Heikki Linnakangas | 2007-06-06 13:19:12 | Controlling Load Distributed Checkpoints |