Re: database slowdown while a lot of inserts occur
2012-04-01 02:20:03 GMT
To: pgsql-performance <at> 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:
> 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).
Sent via pgsql-performance mailing list (pgsql-performance <at> postgresql.org)
To make changes to your subscription: