Pre-sorting COPY FROM input

[Florian Weimer]

Does it make sense to pre-sort COPY FROM input to produce long runs of
increasing values of an indexed column, or does PostgreSQL perform
this optimization on its own?

[Heikki Linnakangas]

Post by Florian Weimer
Does it make sense to pre-sort COPY FROM input to produce long runs of
increasing values of an indexed column, or does PostgreSQL perform
this optimization on its own?

PostgreSQL doesn't do that sort of an optimization itself, so yeah, if
the random I/O of index updates is a problem, pre-sorting the input
should help.

- Heikki