Re: database slowdown while a lot of inserts occur

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Bob Lunney <bob_lunney(at)yahoo(dot)com>
Cc: "Campbell, Lance" <lance(at)illinois(dot)edu>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: database slowdown while a lot of inserts occur
Date: 2012-03-29 19:39:36
Message-ID: 4F74BA78.4090506@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 03/29/2012 03:27 PM, 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?

Or possibly a prepared statement called many times in a single
transaction, if you're not using that already. It's not as efficient as
COPY, but it's often a much less extensive change to the code.

cheers

andrew

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shrirang Chitnis 2012-03-29 20:17:38 Re: database slowdown while a lot of inserts occur
Previous Message Bob Lunney 2012-03-29 19:27:08 Re: database slowdown while a lot of inserts occur