From:
"Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
To:
"Jeff Davis" <pgsql(at)j-davis(dot)com>,"Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc:
"Bruce Momjian" <bruce(at)momjian(dot)us>,"Gregory Stark" <stark(at)enterprisedb(dot)com>,"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 09:45:42
Message-ID:
E1539E0ED7043848906A8FF995BDA57901CAFF11@m0143.s-mxs.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
> Under normal operations, shutting down the database does a
> checkpoint, right? So unless you're in recovery mode, there's
> no additional cost.
> And I can't think of any reason you'd need to see any pages
> before the last checkpoint (unless you don't trust your disk
> and just want to check all the pages, which is more than we
> can do now anyway).
The problem is you don't necessarily have the info which pages changed
*after* the last checkpoint. Especially since in the mentioned scenario
you don't have full-page images. Maybe a suitable replacement for
full-page would be to sync the first WAL record for a page change before
writing the buffer (startup recovery would then check all pages it
touches). This syncing does not sound promising though.
And it is also not only one page we are looking for, but one per
controller (for battery backed) or one per phys disk.
Andreas
In response to
Responses
pgsql-hackers by date
Next :From: Gregory StarkDate: 2007-03-01 10:04:20Subject : Re: COMMIT NOWAIT Performance OptionPrevious :From : Andrew DunstanDate : 2007-03-01 09:21:58Subject : Re: Postgres Replication
