On 29.3.2012 21:27, Bob Lunney wrote: > Lance, > > May small inserts cause frequent fsyncs. Is there any way those small > inserts can be batched into some larger sets of inserts that use copy to > perform the load?
Not necessarily - fsync happens at COMMIT time, not when the INSERT is performed (unless each INSERT stands on it's own). Tomas -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
