From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:03:25
Message-ID:
21062.1181142205@sss.pgh.pa.us (view raw or flat )
Thread:
2007-06-06 13:19:12 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-06 14:14:14 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-06-06 15:03:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-06 18:05:35 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-07 09:28:03 from Hannu Krosing <hannu(at)skype(dot)net>
2007-06-06 18:26:11 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-07 08:36:53 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-07 18:58:50 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-07 19:28:27 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-06-07 20:49:17 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-07 20:56:14 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-06-08 00:33:38 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-06-08 00:43:18 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-06-08 01:19:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-12 19:49:06 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-06-12 19:51:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-12 20:08:01 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-06-08 08:50:49 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-08 14:10:43 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2007-06-08 14:21:10 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-08 14:33:50 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-08 15:06:09 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2007-06-08 18:36:54 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-06-07 12:23:06 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-07 14:16:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-07 17:23:41 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-07 17:43:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-06-07 17:59:28 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-11 06:27:48 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-06-11 07:51:51 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-14 07:39:37 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-06-14 11:45:21 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-06-14 13:22:06 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-14 15:58:33 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-14 17:50:17 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-06-15 02:37:14 from "Gregory Maxwell" <gmaxwell(at)gmail(dot)com>
2007-06-15 04:53:41 from Greg Smith <gsmith(at)gregsmith(dot)com>
2007-06-15 09:14:20 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-06-15 09:33:47 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-06-15 10:55:02 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2008-03-11 20:05:01 from Bruce Momjian <bruce(at)momjian(dot)us>
2008-04-15 09:19:43 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2008-04-15 13:16:40 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-04-16 04:22:13 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2008-04-16 22:02:38 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-05-04 04:40:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-04 23:12:32 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-05-04 23:35:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-05 02:43:13 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-05-05 04:23:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-05-05 05:37:28 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-07-04 08:37:10 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-04 16:05:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-07-04 16:22:23 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2008-07-07 01:29:15 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2008-07-16 05:19:22 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-07-10 01:39:29 from Greg Smith <gsmith(at)gregsmith(dot)com>
2008-07-10 07:06:12 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2007-06-11 09:27:30 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-09 07:39:19 from "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
2007-06-10 19:49:24 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-06-13 18:05:23 from "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
2007-06-13 22:09:02 from PFC <lists(at)peufeu(dot)com>
2007-06-14 11:40:51 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-06-13 22:04:57 from "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
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)
> checkpoint_nap_duration = 2 # delay between write and sync phase, in
> seconds
> checkpoint_fsync_period = 30 # duration of the sync phase, in seconds
> checkpoint_fsync_delay = 500 # max. delay between fsyncs
> I don't like adding that many GUC variables, but I don't really see a
> way to tune them automatically.
If we don't know how to tune them, how will the users know? Having to
add that many variables to control one feature says to me that we don't
understand the feature.
Perhaps what we need is to think about how it can auto-tune itself.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2007-06-06 15:23:00Subject : Re: Implicit casts with generic arrays Previous :From : Bruce MomjianDate : 2007-06-06 14:41:23Subject : Re: TOAST usage setting
pgsql-patches by date
Next :From: Greg SmithDate: 2007-06-06 18:05:35Subject : Re: Controlling Load Distributed Checkpoints Previous :From : Gregory StarkDate : 2007-06-06 14:14:14Subject : Re: Controlling Load Distributed Checkpoints
