Re: [GENERAL] Pg_bulkload and speed

2015-04-29 Thread Takashi Ohnishi
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, parall

Re: [GENERAL] Pg_bulkload and speed

2015-04-29 Thread Jim Nasby
On 4/29/15 4:24 AM, Job wrote: 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. There's a huge number of things that could account for thi

[GENERAL] Pg_bulkload and speed

2015-04-29 Thread Job
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 fo