From:
"Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Jim C(dot) Nasby" <jim(at)nasby(dot)net>
Cc:
"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>,"Bruce Momjian" <bruce(at)momjian(dot)us>,"ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>,"PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Load distributed checkpoint
Date:
2007-01-03 11:18:42
Message-ID:
E1539E0ED7043848906A8FF995BDA57901A355A0@m0143.s-mxs.net (view raw or flat )
Thread:
2006-12-07 06:05:52 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-07 12:19:29 from "Takayuki Tsunakawa" <tunakawa(at)soft(dot)fujitsu(dot)com>
2006-12-07 19:02:33 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2006-12-08 04:40:38 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-08 12:17:37 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-07 16:03:05 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-08 03:33:16 from Greg Smith <gsmith(at)gregsmith(dot)com>
2006-12-08 05:49:20 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-08 07:13:05 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-08 15:26:27 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-08 16:43:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-08 17:01:47 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-08 17:55:09 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-08 18:18:58 from Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
2006-12-08 18:30:09 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-11 10:38:16 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-11 21:31:57 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2006-12-11 21:58:17 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-12 09:22:05 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-12 15:03:23 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-10 14:49:08 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-12 17:15:06 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-12 17:38:18 from Gregory Stark <stark(at)enterprisedb(dot)com>
2006-12-12 17:47:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-22 18:53:13 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-22 21:13:49 from Gregory Stark <stark(at)enterprisedb(dot)com>
2006-12-22 22:34:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-26 03:21:12 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-28 09:18:56 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2006-12-26 09:58:26 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-27 04:10:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-28 01:11:52 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-28 17:50:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-28 17:54:57 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-28 18:03:50 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-28 18:49:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-28 20:55:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-28 21:28:48 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2006-12-29 20:28:32 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-29 21:43:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-30 02:02:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-30 04:08:04 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-01-03 11:18:42 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-01-10 04:51:32 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-27 21:24:06 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2006-12-27 22:26:45 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-27 22:54:57 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2006-12-28 11:35:52 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-13 06:32:43 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-13 09:27:38 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-13 19:34:07 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2006-12-08 02:05:18 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-08 03:59:36 from Greg Smith <gsmith(at)gregsmith(dot)com>
2006-12-08 05:21:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-08 05:22:14 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-08 10:43:59 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-11 12:18:26 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-11 12:42:06 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-11 09:30:57 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2006-12-11 12:22:44 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-18 05:47:07 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-27 22:07:56 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-09 02:11:22 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2007-01-11 18:02:38 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-19 09:17:10 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-19 17:00:05 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-20 03:19:51 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-20 12:05:41 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 01:07:52 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-22 02:48:43 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-22 03:26:22 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-20 16:06:46 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-01-10 04:40:10 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-19 09:31:27 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-20 04:06:37 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-20 11:10:56 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-20 11:17:05 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 12:14:50 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-20 13:48:46 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 20:29:30 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-21 00:52:38 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 06:15:47 from Greg Smith <gsmith(at)gregsmith(dot)com>
2006-12-22 09:38:49 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-21 02:55:42 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-21 08:14:13 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-21 09:46:36 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-21 10:26:41 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 10:29:13 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 12:05:33 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2006-12-22 21:33:43 from Greg Smith <gsmith(at)gregsmith(dot)com>
2006-12-21 14:04:13 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-22 00:24:11 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 03:19:49 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-22 06:20:45 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 07:05:39 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 07:48:27 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-22 08:28:13 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 18:56:07 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2006-12-26 03:13:44 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 09:09:33 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2006-12-22 11:08:55 from "Takayuki Tsunakawa" <tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com>
2006-12-22 12:51:31 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-26 18:20:19 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2007-02-27 00:40:48 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-27 01:48:51 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-27 02:10:01 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-27 06:37:40 from "Inaam Rana" <inaamrana(at)gmail(dot)com>
2007-02-27 08:08:39 from ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2007-02-02 22:54:58 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-patches
> > I believe there's something similar for OS X as well. The question
is:
> > would it be better to do that, or to just delay calling fsync until
the
> > OS has had a chance to write things out.
>
> A delay is not going to help unless you can suppress additional writes
> to the file, which I don't think you can unless there's very little
> going on in the database --- dirty buffers have to get written to make
> room for other pages, checkpoint in progress or no.
But checkpoint first writes all dirty pages, so we have more than
average
pages that can be replaced without a write. Thus we have a window where
we can wait until dirty pages have to be replaced again. Since the
bgwriter
is sleeping until fsync, only pages that have to be replaced will be
written.
Question is, how do we time that window.
Andreas
In response to
pgsql-hackers by date
Next :From: Zeugswetter Andreas ADI SDDate: 2007-01-03 11:56:11Subject : Re: effective_cache_size vs unitsPrevious :From : Mark Cave-AylandDate : 2007-01-03 09:15:41Subject : Re: WITH support
pgsql-patches by date
Next :From: Simon RiggsDate: 2007-01-03 15:35:44Subject : Re: [HACKERS] Patch to log usage of temporary filesPrevious :From : Peter EisentrautDate : 2007-01-03 08:52:29Subject : Re: xlog directory at initdb time
