Re: database slowdown while a lot of inserts occur - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: database slowdown while a lot of inserts occur
Date
Msg-id CAOR=d=34Lc0o-Njty_wDm3XsWhGzu+icFNUBqSNDmg8AmUWCsA@mail.gmail.com
Whole thread Raw
In response to Re: database slowdown while a lot of inserts occur  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-performance
On Thu, Mar 29, 2012 at 12:02 PM, Campbell, Lance <lance@illinois.edu> 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?

pgsql-performance by date:

Previous
From: Shrirang Chitnis
Date:
Subject: Re: database slowdown while a lot of inserts occur
Next
From: "Campbell, Lance"
Date:
Subject: Tablespaces on a raid configuration