Re: Pg_bulkload and speed

From: "Takashi Ohnishi" <onishi_takashi_d5(at)lab(dot)ntt(dot)co(dot)jp>
To: "'Job'" <Job(at)colliniconsulting(dot)it>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pg_bulkload and speed
Date: 2015-04-30 05:06:52
Message-ID: 003701d08303$78dcef30$6a96cd90$@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)lab(dot)ntt(dot)co(dot)jp>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Meel Velliste 2015-04-30 08:13:28 Finding new or modified rows since snapshot
Previous Message Jim Nasby 2015-04-29 23:30:36 Re: database split