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