> So, group the inserts in transactions with maybe 1000 commands each. It
> will go much faster. It can then cache the rows and in the end just make
> sure all 1000 have been written out on disk.
More than that, he should be using COPY - it's 10x faster than even grouped
inserts.
Chris