Pre-sorting COPY FROM input

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Pre-sorting COPY FROM input
Date: 2013-03-15 17:31:27
Message-ID: 87zjy4fu34.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rick Otten 2013-03-15 18:06:02 Re: New server setup
Previous Message Ao Jianwang 2013-03-15 16:04:08 Re: Join the master table with other table is very slow (partitioning)