Re: database slowdown while a lot of inserts occur

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: database slowdown while a lot of inserts occur
Дата
Msg-id CAOR=d=34Lc0o-Njty_wDm3XsWhGzu+icFNUBqSNDmg8AmUWCsA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: database slowdown while a lot of inserts occur  ("Campbell, Lance" <lance@illinois.edu>)
Список 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 по дате отправления:

Предыдущее
От: Shrirang Chitnis
Дата:
Сообщение: Re: database slowdown while a lot of inserts occur
Следующее
От: "Campbell, Lance"
Дата:
Сообщение: Tablespaces on a raid configuration