> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
