Re: Connections - Postgres 9.2

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Connections - Postgres 9.2
Дата
Msg-id c20a0e04-3f00-553c-e00b-9e4adeefd167@aklaver.com
обсуждение исходный текст
Ответ на Re: Connections - Postgres 9.2  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Connections - Postgres 9.2
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Any difference between commit/rollback when only temp tables and \copy are used