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

From Adrian Klaver
Subject Re: Connections - Postgres 9.2
Date
Msg-id c20a0e04-3f00-553c-e00b-9e4adeefd167@aklaver.com
Whole thread Raw
In response to Re: Connections - Postgres 9.2  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 05/16/2016 02:25 PM, John R Pierce wrote:
> 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.

Yeah, I failed to look at the scale of the y axis and just looked at the
relative numbers.

>
>
>
> --
> john r pierce, recycling bits in santa cruz
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Connections - Postgres 9.2
Next
From: "David G. Johnston"
Date:
Subject: Re: Any difference between commit/rollback when only temp tables and \copy are used