Re: Loading optimization - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: Loading optimization
Date
Msg-id Pine.LNX.4.30.0101061644320.8905-100000@chapelperilous.net
Whole thread Raw
In response to Loading optimization  (Gary Wesley <gary@db.stanford.edu>)
List 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.


pgsql-general by date:

Previous
From: "Ian deSouza"
Date:
Subject: Re: DROP SEQUENCE ?
Next
From: "Ian deSouza"
Date:
Subject: DROP SEQUENCE ?