Re: database slowdown while a lot of inserts occur

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: database slowdown while a lot of inserts occur
Date: 2012-03-29 21:36:46
Message-ID: CAOR=d=34Lc0o-Njty_wDm3XsWhGzu+icFNUBqSNDmg8AmUWCsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Mar 29, 2012 at 12:02 PM, Campbell, Lance <lance(at)illinois(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Campbell, Lance 2012-03-30 14:45:36 Tablespaces on a raid configuration
Previous Message Shrirang Chitnis 2012-03-29 20:17:38 Re: database slowdown while a lot of inserts occur