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