Re: database slowdown while a lot of inserts occur - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: database slowdown while a lot of inserts occur
Date
Msg-id 4F7659AC.1000507@fuzzy.cz
Whole thread Raw
In response to Re: database slowdown while a lot of inserts occur  (Bob Lunney <bob_lunney@yahoo.com>)
Responses Re: database slowdown while a lot of inserts occur  (Bob Lunney <bob_lunney@yahoo.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Linux machine aggressively clearing cache
Next
From: Tomas Vondra
Date:
Subject: Re: database slowdown while a lot of inserts occur