Re: Pg_bulkload and speed - Mailing list pgsql-general

From Takashi Ohnishi
Subject Re: Pg_bulkload and speed
Date
Msg-id 003701d08303$78dcef30$6a96cd90$@lab.ntt.co.jp
Whole thread Raw
In response to Pg_bulkload and speed  (Job <Job@colliniconsulting.it>)
List pgsql-general
Hello,

> Due to speed up loading of a table of about 4 fields with 10 millions of record, are there some parameters to
optimize?
> In same machine it takes about 15 minutes, in other machines about one hour.
>
> Parallel mode is better than direct mode?
> Other interesting things?

Yes, parallel mode is typically faster than direct mode in pg_bulkload.
I wonder why there is so large difference in load speed as you noted...

Regards,

++++++++++++
Takashi Ohnishi <onishi_takashi_d5@lab.ntt.co.jp>




pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: database split
Next
From: Frank Langel
Date:
Subject: Success story full text search