On 12/09/2014 09:11 PM, Tom Lane wrote: > Josh Berkus <j...@agliodbs.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
