Re: Pg_bulkload and speed

Поиск
Список
Период
Сортировка
От Takashi Ohnishi
Тема Re: Pg_bulkload and speed
Дата
Msg-id 003701d08303$78dcef30$6a96cd90$@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Pg_bulkload and speed  (Job <Job@colliniconsulting.it>)
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: database split
Следующее
От: Frank Langel
Дата:
Сообщение: Success story full text search