From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Jim Nasby <jim(at)nasby(dot)net>
Cc:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Robert Haas <robertmhaas(at)gmail(dot)com>,
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
Simon Riggs <simon(at)2ndquadrant(dot)com>, Noah Misch <noah(at)leadboat(dot)com>,
Andres Freund <andres(at)anarazel(dot)de>,
Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, david <david(at)fetter(dot)org>,
aidan <aidan(at)highrise(dot)ca>, stark <stark(at)mit(dot)edu>,
Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: 16-bit page checksums for 9.2
Date:
2012-03-01 00:48:47
Message-ID:
653.1330562927@sss.pgh.pa.us (view raw or flat )
Thread:
2012-01-04 13:35:19 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-01-05 15:46:22 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-06 18:26:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-06 19:35:01 from Andres Freund <andres(at)anarazel(dot)de>
2012-01-06 19:49:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-06 20:49:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-06 19:45:45 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-06 19:48:07 from Andres Freund <andres(at)anarazel(dot)de>
2012-01-06 19:53:38 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-06 20:03:49 from Andres Freund <andres(at)anarazel(dot)de>
2012-01-06 22:17:09 from Merlin Moncure <mmoncure(at)gmail(dot)com>
2012-01-06 23:48:32 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2012-01-06 23:49:04 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2012-01-06 23:48:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-06 20:47:12 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-06 21:44:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-07 10:14:30 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-07 10:26:42 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-07 10:55:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-07 11:09:53 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-08 14:03:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-11 22:12:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-26 20:20:39 from Noah Misch <noah(at)leadboat(dot)com>
2012-01-27 00:01:21 from Dan Scales <scales(at)vmware(dot)com>
2012-01-27 13:19:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-01-27 21:07:00 from Dan Scales <scales(at)vmware(dot)com>
2012-01-28 13:49:02 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-01-28 20:44:32 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-01-30 15:26:05 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-07 20:58:59 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-08 03:24:05 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-08 11:40:34 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-08 14:05:02 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-09 15:16:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-16 11:16:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-16 11:48:13 from Albert Cervera i Areny <albert(at)nan-tic(dot)com>
2012-02-16 13:53:48 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-17 22:13:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-18 11:39:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-19 16:35:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-19 19:17:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-19 22:04:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-19 23:33:19 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-20 00:20:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-19 23:57:20 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-20 00:42:01 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-20 09:18:44 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-20 13:57:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-20 17:53:55 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-02-20 18:22:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-20 22:49:25 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-02-20 23:02:37 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2012-02-21 10:07:40 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-21 14:48:42 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-22 13:32:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-22 23:17:53 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-22 23:51:00 from David Fetter <david(at)fetter(dot)org>
2012-02-23 01:39:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-02 16:58:01 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-02-20 23:09:01 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-20 23:23:42 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-21 04:21:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-02-22 07:06:49 from Noah Misch <noah(at)leadboat(dot)com>
2012-02-22 12:30:46 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 14:40:11 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 15:01:37 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 15:30:12 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 15:42:17 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 15:46:01 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 16:24:21 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 16:41:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-29 17:26:42 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 17:44:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-29 17:54:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-02-29 19:09:02 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 19:18:44 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-02-29 19:29:26 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 20:14:14 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-02-29 19:30:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-29 19:33:28 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2012-02-29 21:24:27 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-29 21:34:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-29 21:53:18 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-02-29 23:38:24 from Jim Nasby <jim(at)nasby(dot)net>
2012-03-01 00:48:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-29 21:55:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-29 22:52:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-01 12:41:04 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-01 17:42:43 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-03-01 18:28:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-01 18:40:44 from Josh Berkus <josh(at)agliodbs(dot)com>
2012-03-01 21:08:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-02 00:23:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-02 00:45:36 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-03-02 01:32:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-02 01:46:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-02 02:11:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-03-02 03:52:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-03-02 19:32:48 from Simon Riggs <simon(at)2ndquadrant(dot)com>
2012-02-29 19:28:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-02-19 21:49:48 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2012-03-02 19:45:09 from Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
2012-06-13 02:30:04 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-08-10 23:16:43 from Jeff Davis <pgsql(at)j-davis(dot)com>
2012-01-10 04:27:28 from Greg Smith <greg(at)2ndQuadrant(dot)com>
Lists:
pgsql-hackers
Jim Nasby <jim(at)nasby(dot)net> writes:
> On 2/29/12 3:53 PM, Alvaro Herrera wrote:
>> .. in fact this is precisely what killed Zdenek Kotala's idea of
>> upgrading.
> This is also why Simon has avoided the whole upgrade thing with his 16 bit checksum idea (otherwise presumably we'd be looking at bigger checksums anyway).
> I get that fussing around with the version field is ugly. If there was another way to do this without breaking pg_upgrade then it would be silly to mess with the version field. Unfortunately, there is no other way.
Fundamentally, what is going on here is that several of us think that we
need a page format upgrade infrastructure first, and then we can think
about adding checksums. Simon would like to cram checksums in without
building such infrastructure, regardless of the consequences in code
ugliness or future maintainability. Personally, I think that is a bad
tradeoff. Eventually we are going to have to build that infrastructure,
and the more we've kluged the page header format in the meanwhile, the
more unpleasant it's going to be.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Fujii MasaoDate: 2012-03-01 02:39:53Subject : Re: Client MessagesPrevious :From : Alvaro HerreraDate : 2012-03-01 00:48:27Subject : Re: Re: pg_stat_statements normalisation without invasive changes to the parser (was: Next steps on pg_stat_statements normalisation)
