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
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
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
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
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
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
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