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...@lab.ntt.co.jp> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
