[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: database slowdown while a lot of inserts occur





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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Home]     [Yosemite]

Powered by Linux