Re: Connections - Postgres 9.2

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Connections - Postgres 9.2
Date: 2016-05-16 21:11:40
Message-ID: 3385f929-f72a-fc26-dd40-2779efa0ee61@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-05-16 21:25:33 Re: Connections - Postgres 9.2
Previous Message Lucas Possamai 2016-05-16 21:10:32 Re: Connections - Postgres 9.2