From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc:
Andrew Dunstan <andrew(at)dunslane(dot)net>,
Zeugswetter Andreas ADI SD <ZeugswetterA(at)spardat(dot)at>,
Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,
pgsql-hackers(at)postgresql(dot)org, Gregory Stark <stark(at)enterprisedb(dot)com>
Subject:
Re: column ordering, was Re: [PATCHES] Enums patch v2
Date:
2006-12-21 16:59:47
Message-ID:
20900.1166720387@sss.pgh.pa.us (view raw or flat )
Thread:
2006-12-19 02:34:36 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-19 08:09:47 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2006-12-19 08:23:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-19 14:34:27 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 14:58:48 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2006-12-19 15:11:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 15:22:13 from Gregory Stark <stark(at)enterprisedb(dot)com>
2006-12-19 15:48:41 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 16:25:04 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 03:35:21 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2006-12-20 03:44:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 04:12:50 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 04:29:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 11:33:53 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-20 14:19:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:27:13 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 16:20:16 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-20 16:24:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 21:23:49 from Russell Smith <mr-russ(at)pws(dot)com(dot)au>
2006-12-21 16:26:30 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2006-12-20 12:06:54 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:15:05 from Stephen Frost <sfrost(at)snowman(dot)net>
2006-12-20 20:17:12 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 14:39:07 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 15:27:12 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 15:37:03 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 15:50:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:07:20 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:15:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:27:44 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-21 16:43:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 17:09:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-22 01:48:49 from Gregory Stark <gsstark(at)mit(dot)edu>
2006-12-22 02:28:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-22 09:25:08 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-30 04:46:27 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-02 05:43:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2006-12-21 16:47:56 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:59:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-21 16:06:53 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-21 16:11:46 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-21 16:18:02 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2006-12-20 12:26:59 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 13:20:14 from Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
2006-12-20 13:38:30 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:11:48 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-20 14:36:32 from Richard Huxton <dev(at)archonet(dot)com>
2006-12-20 13:59:21 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-19 15:19:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-12-20 01:39:58 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 11:03:11 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2006-12-20 14:49:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2006-12-19 08:51:01 from David Fetter <david(at)fetter(dot)org>
2006-12-19 09:58:48 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2006-12-20 02:00:48 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2006-12-20 01:23:02 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-02 03:50:12 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-02 15:54:44 from Neil Conway <neilc(at)samurai(dot)com>
2007-02-14 00:03:47 from Tom Dunstan <pgsql(at)tomd(dot)cc>
2007-02-21 17:06:10 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers pgsql-patches
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> I was envisiging the physical number to be fixed and immutable (ie
> storage position = permanent position).
There are two different problems being discussed here, and one of them
is insoluble if we take that position: people would like the system to
automatically lay out tables to minimize alignment overhead and access
costs (eg, put fixed-width columns first). This is not the same as
"I would like to change the display column order".
It's true that for an ADD COLUMN that doesn't already force a table
rewrite, forcing one to improve packing is probably bad. My thought
would be that we leave the column storage order alone if we don't have
to rewrite the table ... but any rewriting variant of ALTER TABLE could
optimize the storage order while it was at it.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Matthew T. O'ConnorDate: 2006-12-21 17:03:30Subject : Re: Autovacuum ImprovementsPrevious :From : Andrew DunstanDate : 2006-12-21 16:57:14Subject : Re: Release 8.2.0 done, 8.3 development starts
pgsql-patches by date
Next :From: Andrew DunstanDate: 2006-12-21 17:09:46Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2Previous :From : Martijn van OosterhoutDate : 2006-12-21 16:47:56Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2
