On Tue, 2006-03-21 at 15:56, Tom Lane wrote: > Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes: > > I've also found that modest increases in commit_siblings and > > commit_delay help a lot on certain types of imports. > > On a data import? Those really should have zero effect on a > single-process workload. Or are you doing multiple concurrent imports? That, and it's a machine that's doing other things. Also, a lot of the imports are NOT bundled up into groups of transactions. i.e. lots and lots of individual insert queries.
