Re: Simple Column reordering - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Simple Column reordering
Date
Msg-id 63608.24.211.165.134.1172196465.squirrel@www.dunslane.net
Whole thread Raw
In response to Simple Column reordering  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: Simple Column reordering  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Simple Column reordering  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
>
> I propose that at CREATE TABLE time, the column ordering is re-ordered
> so that the table columns are packed more efficiently. This would be a
> physical re-ordering, so that SELECT * and COPY without explicit column
> definitions would differ from the original CREATE TABLE statement.
>
> This would be an optional feature, off by default, controlled by a
> USERSET GUC
>     optimize_column_order = off (default) | on
>


Umm, you want a GUC setting to enable standards-breaking behaviour and
that will be obsolete when we do column ordering right, which is not
likely to be more than one release away, and could even still happen in
this coming release?

I hope I haven't misunderstood.

cheers

andrew



pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: Grouped Index Tuples
Next
From: Alvaro Herrera
Date:
Subject: Re: Simple Column reordering