Обсуждение: Pre-sorting COPY FROM input

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?

On 15.03.2013 19:31, Florian Weimer wrote:
> 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