From: Travis Kirstine <tkirstine@firstbasesolutions.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: superuser_reserved_connections and max_connections
Thread-Topic: superuser_reserved_connections and max_connections
Thread-Index: AQHRzjHPR8/q/gldWEinb5AfOgY/kQ==
Date: Fri, 24 Jun 2016 16:10:41 +0000
Message-ID: <1466784642535.32585@firstbasesolutions.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: multipart/alternative;
	boundary="_000_146678464253532585firstbasesolutionscom_"
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--_000_146678464253532585firstbasesolutionscom_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


We were getting a lot of "max connections reached" errors and noticed that =
all our users are super users, after some digging I found the

superuser_reserved_connections parameter was not set (default to 3) this le=
ad to some additional questions:


If all my users are  superusers are they effectively limited to the number =
of connections defined in the

superuser_reserved_connections  parameter?


Is there any significant difference between a superuser and non-superuser c=
onnection?


Any additional insight would be great.

--_000_146678464253532585firstbasesolutionscom_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none"><!--P{margin-top:0;margin-b=
ottom:0;} --></style>
</head>
<body dir=3D"ltr" style=3D"font-size:10pt;color:#000000;background-color:#F=
FFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>We were getting a lot of &quot;max connections reached&quot; errors and =
noticed that all our users are super users, after some digging I found the&=
nbsp;</p>
<p>superuser_reserved_connections parameter was not set (default to 3) this=
 lead to some additional questions:
<br>
</p>
<p><br>
</p>
<p>If all my users are&nbsp; superusers are they effectively limited to the=
 number of connections defined in the&nbsp;</p>
<p>superuser_reserved_connections &nbsp;parameter?</p>
<p><br>
</p>
<p>Is there any&nbsp;significant&nbsp;difference between a&nbsp;superuser a=
nd non-superuser connection?
</p>
<p><br>
</p>
<p>Any additional insight would be great.<br>
</p>
</body>
</html>

--_000_146678464253532585firstbasesolutionscom_--