Re: [PERFORM] Pre-sorting COPY FROM input

2013-03-15 Thread Heikki Linnakangas
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

[PERFORM] Pre-sorting COPY FROM input

2013-03-15 Thread 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? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.p