Postgres Pro
Downloads
Home   >   mailing lists

Pre-sorting COPY FROM input - Mailing list pgsql-performance

From Florian Weimer
Subject Pre-sorting COPY FROM input
Date
Msg-id 87zjy4fu34.fsf@mid.deneb.enyo.de
Whole thread Raw
Responses Re: Pre-sorting COPY FROM input
List pgsql-performance
Tree view 
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?

pgsql-performance by date:

Previous
From: Ao Jianwang
Date:
Subject: Re: Join the master table with other table is very slow (partitioning)
Next
From: Rick Otten
Date:
Subject: Re: New server setup