Horton

Re: Loading optimization

Brett W. McCoy <bmccoy@chapelperilous.net>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: Gary Wesley <gary@db.stanford.edu>
Cc: <pgsql-general@postgresql.org>
Date: 2001-01-06T21:45:26Z
Lists: pgsql-general 
On Wed, 3 Jan 2001, Gary Wesley wrote:

> Is there any advantage to having data sorted before populating it into a
> table?

None at all, AFAIK.  In fact, if you are doing a bulk copy, you should
build your indexes after the data is loaded -- you'll get ebtter
performance during the load.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
This sentence no verb.