From:
Gregory Stark <stark(at)enterprisedb(dot)com>
To:
"Jeff Davis" <pgsql(at)j-davis(dot)com>
Cc:
"Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>, "Josh Berkus" <josh(at)agliodbs(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 00:07:54
Message-ID:
87zm6xu8px.fsf@stark.xeocode.com (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
"Jeff Davis" <pgsql(at)j-davis(dot)com> writes:
> On Wed, 2007-02-28 at 21:13 +0000, Gregory Stark wrote:
>> Hm that's an interesting thought. We only really have to check pages that
>> would have received a full page write since the last checkpoint. So if we made
>
> Do we ever do a partial page write, or is what you're saying equivalent
> to "we only have to check pages that have been written to since the last
> checkpoint"?
"full page writes" is a term of art in Postgres. When we first modify a page
we stuff a copy of the entire page in the WAL so that recovery can restore it.
We never write only part of a page to data files intentionally but if the
system crashes while it's in the process of being written only part of it
might end up getting written. Normally only the modified bits get put in WAL.
> And if it is the same, can't we get the pages that were written to from
> the ctids in the wal records?
yes, though it may still be convenient to use the full page write fields
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
In response to
pgsql-hackers by date
Next :From: Joshua D. DrakeDate: 2007-03-01 00:26:30Subject : Re: [HACKERS] Previous :From : Josh BerkusDate : 2007-03-01 00:06:47Subject : Re: COMMIT NOWAIT Performance Option
