From:
"Inaam Rana" <inaamrana(at)gmail(dot)com>
To:
"ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc:
josh(at)agliodbs(dot)com, pgsql-patches(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: [HACKERS] Load distributed checkpoint
Date:
2007-02-27 06:37:40
Message-ID:
833c669b0702262237t7e627b2eva60673e1ce55343f@mail.gmail.com (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
On 2/26/07, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>
> Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
> > Can I have a copy of the patch to add to the Sun testing queue?
>
> This is the revised version of the patch. Delay factors in checkpoints
> can be specified by checkpoint_write_percent, checkpoint_nap_percent
> and checkpoint_sync_percent. They are relative to checkpoint_timeout.
>
> Also, checking of archive_timeout during checkpoints and some error
> handling routines were added.
One of the issues we had during testing with original patch was db stop not
working properly. I think you coded something to do a stop checkpoint in
immediately but if a checkpoint is already in progress at that time, it
would take its own time to complete.
Does this patch resolve that issue? Also, is it based on pg82stable or HEAD?
regards,
inaam
Regards,
> ---
> ITAGAKI Takahiro
> NTT Open Source Software Center
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>
--
Inaam Rana
EnterpriseDB http://www.enterprisedb.com
In response to
Responses
pgsql-hackers by date
Next :From: Warren TurkalDate: 2007-02-27 06:46:35
Subject : Re: conversion efforts (Re: SCMS question)
Previous :From : Simon RiggsDate : 2007-02-27 06:29:33
Subject : Re: COMMIT NOWAIT Performance Option
pgsql-patches by date
Next :From: Tom LaneDate: 2007-02-27 06:43:11
Subject : Re: POSIX shared memory support
Previous :From : Tom LaneDate : 2007-02-27 05:55:21
Subject : Re: Dead Space Map version 2