Re: [PERFORM] Big number of connections

2016-04-04 Thread Mike Sofen
From: Jim Nasby Sent: Sunday, April 03, 2016 10:19 AM >>On 4/1/16 2:54 AM, jarek wrote: >> I'll be happy to hear form users of big PostgreSQL installations, how >> many users do you have and what kind of problems we may expect. >> Is there any risk, that huge number of roles will slowdown

Re: [PERFORM] Big number of connections

2016-04-04 Thread Moreno Andreo
Il 04/04/2016 15:33, Pavel Stehule ha scritto: PostgreSQL doesn't contain integrated pooler - so any connection to Postgres enforces one PostgreSQL proces. A performance benchmarks is showing maximum performance about 10x cores. With high number of connections you have to use low size of

Re: [PERFORM] Big number of connections

2016-04-04 Thread Pavel Stehule
Hi 2016-04-04 15:14 GMT+02:00 Mike Sofen : > From: Jim Nasby Sent: Sunday, April 03, 2016 10:19 AM > > >>On 4/1/16 2:54 AM, jarek wrote: > >> I'll be happy to hear form users of big PostgreSQL installations, how > >> many users do you have and what kind of problems we may

Re: [PERFORM] Big number of connections

2016-04-04 Thread Artem Tomyuk
there are two ways: 1. to write bash script with condition if number of conn. is > 1000 send me email and put that script in crontab 2. monitor it with external monitoring system like zabbix, nagios etc 2016-04-04 18:00 GMT+03:00 Moreno Andreo : > Il

Re: [PERFORM] Big number of connections

2016-04-04 Thread Artem Tomyuk
2016-04-04 17:43 GMT+03:00 Moreno Andreo : > s there a way to monitor active connections, or at least to report when > they grow too much? > (say, I have an 8-core system and want to track down if, and when, active > connections grow over 80) > You can achieve that just

Re: [PERFORM] Big number of connections

2016-04-04 Thread Pavel Stehule
2016-04-04 16:43 GMT+02:00 Moreno Andreo : > Il 04/04/2016 15:33, Pavel Stehule ha scritto: > >> >> >> PostgreSQL doesn't contain integrated pooler - so any connection to >> Postgres enforces one PostgreSQL proces. A performance benchmarks is >> showing maximum

Re: [PERFORM] Big number of connections

2016-04-04 Thread Moreno Andreo
Il 04/04/2016 16:54, Artem Tomyuk ha scritto: 2016-04-04 17:43 GMT+03:00 Moreno Andreo : s there a way to monitor active connections, or at least to report