On Aug 19, 2013, at 9:21 AM, Dzmitry <dzmitry.nikitsin@xxxxxxxxx> wrote: > 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. So, 40 threads, not 440? Was 440 connections a typo, or are there 400 connections you aren't telling us about? -- 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
