From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Gregory Stark <stark(at)enterprisedb(dot)com>
Cc:
pgsql-hackers(at)postgresql(dot)org
Subject:
column ordering, was Re: [PATCHES] Enums patch v2
Date:
2006-12-19 15:48:41
Message-ID:
458809D9.5030109@dunslane.net (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
Gregory Stark wrote:
> "Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
>
>
>> I'm not a big fan of ordering columns to optimise record layout, except in the
>> most extreme cases (massive DW type apps). I think visible column order should
>> be logical, not governed by physical considerations.
>>
>
> Well as long as we're talking "should"s the database should take care of this
> for you anyways.
>
>
Sure, but the only sane way I can think of to do that would be have
separate logical and physical orderings, with a map between the two. I
guess we'd need to see what the potential space savings would be and
establish what the processing overhead would be, before considering it.
One side advantage would be that it would allow us to do the often
requested "add column at position x".
cheers
andrew
In response to
Responses
pgsql-hackers by date
Next :From: Zeugswetter Andreas ADI SDDate: 2006-12-19 15:58:22Subject : Re: pg_restore fails with a custom backup filePrevious :From : Richard HuxtonDate : 2006-12-19 15:46:23Subject : Re: Second attempt, roll your own autovacuum
pgsql-patches by date
Next :From: Martijn van OosterhoutDate: 2006-12-19 16:25:04Subject : Re: column ordering, was Re: [PATCHES] Enums patch v2Previous :From : Gregory StarkDate : 2006-12-19 15:22:13Subject : Re: [HACKERS] Enums patch v2
