Sorry for confusion. I have 2 machines, each machine run 1 process, with 20 threads in each - total 40 threads. Every thread connected to postgres and insert data. I am using technology, that keep connection opens. It means every thread open 1 connection when it starts, and will closed it - only when killed. But threads performing background jobs - it means they running always, so I keep connection always open.
Thanks, Dzmitry On 8/19/13 6:17 PM, "Scott Ribe" <scott_r...@elevated-dev.com> wrote: >On Aug 19, 2013, at 9:07 AM, Dzmitry <dzmitry.nikit...@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 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_r...@elevated-dev.com >http://www.elevated-dev.com/ >(303) 722-0567 voice > > > > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin