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

Re: database slowdown while a lot of inserts occur



On Thu, Mar 29, 2012 at 12:02 PM, Campbell, Lance <lance@xxxxxxxxxxxx> wrote:
> I forgot to mention that the slowdown in particular for other applications
> is when they are trying to insert or update tables unrelated to the
> application mentioned in my prior application that does the massive small
> inserts.

It sounds like you're just flooding your IO channels.  Can you
throttle your write rate in your main application that's inserting so
many inserts?  Something that sleeps 10ms between every hundred rows
or some such?

-- 
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