Re: postgres crashes on insert in 40 different threads

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: postgres crashes on insert in 40 different threads
Дата
Msg-id ED6CA3D8-8424-4069-A6D7-A9473D9F569F@elevated-dev.com
обсуждение исходный текст
Ответ на Re: postgres crashes on insert in 40 different threads  (Dzmitry <dzmitry.nikitsin@gmail.com>)
Ответы Re: postgres crashes on insert in 40 different threads
Список pgsql-admin
On Aug 19, 2013, at 9:07 AM, Dzmitry <dzmitry.nikitsin@gmail.com> wrote:

> Yes- I need so many threads...

This is not at all clear from your answer. At most, 1 thread per logical core can execute at any one time. And while
manycan be waiting on IO instead of executing, there is still a rather low limit to how many threads it takes to
saturateIO capacity. If you actually tried to *run* 550 processes at the same time, you'd just be wasting time on
contention.

So, back to the question I just asked a minute ago in the prior email, do you have any idea how many pg connections are
actuallybeing used? 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






В списке pgsql-admin по дате отправления:

Предыдущее
От: Dzmitry
Дата:
Сообщение: Re: postgres crashes on insert in 40 different threads
Следующее
От: Dzmitry
Дата:
Сообщение: Re: postgres crashes on insert in 40 different threads