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
