Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres crashes on insert in 40 different threads - Mailing list pgsql-admin

From Scott Ribe
Subject Re: postgres crashes on insert in 40 different threads
Date
Msg-id ED6CA3D8-8424-4069-A6D7-A9473D9F569F@elevated-dev.com
Whole thread Raw
In response to Re: postgres crashes on insert in 40 different threads  (Dzmitry <dzmitry.nikitsin@gmail.com>)
Responses Re: postgres crashes on insert in 40 different threads  (Dzmitry <dzmitry.nikitsin@gmail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Dzmitry
Date:
Subject: Re: postgres crashes on insert in 40 different threads
Next
From: Dzmitry
Date:
Subject: Re: postgres crashes on insert in 40 different threads