Re: database slowdown while a lot of inserts occur

[Andrew Dunstan <andrew@xxxxxxxxxxxx>]

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



--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance