Re: Connections - Postgres 9.2

Поиск
Список
Период
Сортировка
Искать
От
Adrian Klaver
Тема
Re: Connections - Postgres 9.2
Дата
в 21:48:39
Msg-id
c20a0e04-3f00-553c-e00b-9e4adeefd167@aklaver.com
Ответ на
Re: Connections - Postgres 9.2 (John R Pierce)
Список
Дерево обсуждения
Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Charles Clavadetscher <clavadetscher@swisspug.org>
Re: Connections - Postgres 9.2 Francisco Olarte <folarte@peoplecall.com>
Re: Connections - Postgres 9.2 Charles Clavadetscher <clavadetscher@swisspug.org>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 John R Pierce <pierce@hogranch.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 John R Pierce <pierce@hogranch.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 Venkata Balaji N <nag1010@gmail.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Francisco Olarte <folarte@peoplecall.com>
Re: Connections - Postgres 9.2 "David G. Johnston" <david.g.johnston@gmail.com>
Re: Connections - Postgres 9.2 Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
Re: Connections - Postgres 9.2 Melvin Davidson <melvin6925@gmail.com> 
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 по дате отправления
Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Connections - Postgres 9.2
Следующее
От: David G. Johnston
Дата:
FAQ