From:
"Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
"Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>,Gregory Stark <stark(at)enterprisedb(dot)com>,Josh Berkus <josh(at)agliodbs(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>,pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Subject:
Re: COMMIT NOWAIT Performance Option
Date:
2007-03-01 15:24:22
Message-ID:
20070301152421.GJ15006@nasby.net (view raw or flat )
Thread:
2007-02-26 22:56:58 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-26 23:06:19 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-27 04:05:45 from "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
2007-02-27 05:45:19 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-26 23:25:31 from Richard Huxton <dev(at)archonet(dot)com>
2007-02-26 23:58:11 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 00:20:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-27 07:07:22 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 00:27:09 from "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
2007-03-04 04:19:00 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-03-05 20:55:49 from "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
2007-02-27 02:44:34 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-02-27 03:06:47 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-27 04:04:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-27 10:49:32 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 17:32:09 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-27 17:36:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-27 18:37:30 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 19:16:59 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-27 17:32:38 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-27 19:36:18 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-27 19:56:16 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-27 21:01:46 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-27 22:17:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-27 22:30:01 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 00:49:37 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 01:32:52 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 01:36:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 01:57:16 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-27 20:13:26 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-27 20:32:57 from Dave Page <dpage(at)postgresql(dot)org>
2007-02-27 20:34:21 from Jordan Henderson <jordan_henders(at)yahoo(dot)com>
2007-02-27 20:56:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 01:30:19 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-28 01:51:04 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 01:40:33 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-28 01:46:48 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-02-28 01:50:28 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-28 02:13:11 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 03:43:53 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 11:10:04 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 15:27:48 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 15:47:04 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 15:57:03 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2007-02-28 16:23:49 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 16:38:51 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:19:20 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 17:31:27 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:20:17 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 17:16:39 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-01 02:16:21 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 17:16:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 17:28:57 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 17:34:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 19:10:11 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 19:12:24 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 19:27:08 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 19:35:09 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 19:41:42 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 19:48:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 19:52:11 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 23:49:59 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 19:48:10 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-02-28 19:54:16 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 20:10:24 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 20:39:18 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 20:44:36 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 20:55:13 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 20:17:02 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-02-28 20:37:11 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-03-01 09:45:42 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-03-01 10:04:20 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-01 13:24:47 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-03-01 13:51:43 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-02-28 20:08:00 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-02-28 21:13:08 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-28 21:46:26 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-03-01 00:02:50 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-01 00:40:56 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-03-01 02:22:58 from "J(dot) Andrew Rogers" <jrogers(at)neopolitan(dot)com>
2007-03-01 03:06:00 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-03-01 03:34:21 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-03-01 05:20:07 from "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
2007-02-28 22:36:38 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-01 00:07:54 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-03-01 15:24:22 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-28 10:40:29 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-28 23:23:32 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-03-01 00:06:47 from Josh Berkus <josh(at)agliodbs(dot)com>
2007-02-27 21:37:46 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-27 04:50:56 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-27 06:29:33 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-02-27 22:18:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-27 23:59:41 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-28 00:17:37 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-28 00:21:04 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-28 05:54:36 from "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
Lists:
pgsql-hackers
On Wed, Feb 28, 2007 at 12:16:10PM -0500, Bruce Momjian wrote:
> background writer, and I think after a server crash, all pages would
> have to be read and checked. The good news is that both of these are
Would they? If you're doing recovery you'd have to read all pages
dirtied since the last checkpoint... could there be pages other than
those that had been torn?
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2007-03-01 15:31:38Subject : Re: CLUSTER, using SHARE UPDATE EXCLUSIVE lock? Previous :From : Pavan DeolaseeDate : 2007-03-01 15:12:46Subject : Re: HOT - preliminary results
