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

From Adrian Klaver
Subject Re: Connections - Postgres 9.2
Date
Msg-id 3385f929-f72a-fc26-dd40-2779efa0ee61@aklaver.com
Whole thread Raw
In response to Re: Connections - Postgres 9.2  (John R Pierce <pierce@hogranch.com>)
Responses Re: Connections - Postgres 9.2
List pgsql-general
On 05/16/2016 02:00 PM, John R Pierce wrote:
> On 5/16/2016 1:55 PM, Adrian Klaver wrote:
>>> Would the pool connection solve that IDLE connections? But more
>>> important than that, are the IDLE connections using the machine's
>>> resources ?
>>
>> 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.

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


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Lucas Possamai
Date:
Subject: Re: Connections - Postgres 9.2
Next
From: John R Pierce
Date:
Subject: Re: Connections - Postgres 9.2