Tomas,

You are correct.  I was assuming that each insert was issued as an implicit 
transaction, without the benefit of an explicit BEGIN/COMMIT batching many of 
them together, as I've seen countless times in tight loops trying to pose as a 
batch insert.

Bob



________________________________
 From: Tomas Vondra <t...@fuzzy.cz>
To: pgsql-performance@postgresql.org 
Sent: Friday, March 30, 2012 8:11 PM
Subject: Re: [PERFORM] database slowdown while a lot of inserts occur
 
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

Reply via email to