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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
