On Wed, Jun 27, 2018 at 6:25 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote:
> > >> Other parameters are set to default value. Moreover, I have specified the >> primary key constraint during table creation. This is the only possible >> index being created before data loading and I am sure there are no other >> indexes apart from the primary key column(s). >> > When doing initial bulk data loads, I would suggest not applying ANY constraints or indexes on the table until after the data is loaded. Especially unique constraints/indexes, those will slow things down A LOT. > > The main factor is using COPY instead INSERTs. > > +1 to COPY. -- Don Seiler www.seiler.us
