Re: Connections - Postgres 9.2 - Mailing list pgsql-general

From John R Pierce
Subject Re: Connections - Postgres 9.2
Date
Msg-id d55cc18a-733d-cc1c-c7c0-28f4a55bd253@hogranch.com
Whole thread Raw
In response to Re: Connections - Postgres 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Connections - Postgres 9.2
List pgsql-general
On 5/16/2016 2:11 PM, Adrian Klaver wrote:
Yes a connection consumes resources.

an idle connection consumes some memory, a process context, and a
network socket.   its not using CPU or disk IO.

True, but the existence of poolers says that can be an issue.

I note that MRTG style graph showed max 16, average 5 idle connections.   thats a rather small number to be concerned with.  if it was 100s, then I'd be worrying about it.



-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Connections - Postgres 9.2
Next
From: Adrian Klaver
Date:
Subject: Re: Connections - Postgres 9.2