Re: database slowdown while a lot of inserts occur

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: database slowdown while a lot of inserts occur
Date: 2012-03-31 01:11:08
Message-ID: 4F7659AC.1000507@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2012-03-31 01:21:33 Re: database slowdown while a lot of inserts occur
Previous Message Josh Berkus 2012-03-31 00:51:33 Re: Linux machine aggressively clearing cache