On Aug 19, 2013, at 9:07 AM, Dzmitry <dzmitry.nikitsin@xxxxxxxxx> 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 many can be waiting on IO instead of executing, there is still a rather low limit to how many threads it takes to saturate IO 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 actually being used? -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
