Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group