Pg_bulkload and speed

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Pg_bulkload and speed
Date: 2015-04-29 09:24:13
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A04F71C6F9B13@W2008DC01.ColliniConsulting.lan
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?

Thank you in advance for your kind interest!

Francesco

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ladislav Lenart 2015-04-29 10:24:58 Re: newsfeed type query
Previous Message Craig Ringer 2015-04-29 06:38:55 Re: BDR Selective Replication