Re: logical column ordering

On 12/09/2014 09:11 PM, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> Question on COPY, though: there's reasons why people would want COPY to
>> dump in either physical or logical order. If you're doing COPY to
>> create CSV files for output, then you want the columns in logical order.
>> If you're doing COPY for pg_dump, then you want them in physical order
>> for faster dump/reload. So we're almost certainly going to need to have
>> an option for COPY.
>
> This is complete nonsense, Josh, or at least it is until you can provide
> some solid evidence to believe that column ordering would make any
> noticeable performance difference in COPY. I know of no reason to believe
> that the existing user-defined-column-ordering option makes any difference.

Chill, dude, chill. When we have a patch, I'll do some performance
testing, and we'll see if it's something we care about or not. There's
no reason to be belligerent about it.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com