| 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:48:34 |
| Message-ID: | c20a0e04-3f00-553c-e00b-9e4adeefd167@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-05-16 22:00:12 | Re: Any difference between commit/rollback when only temp tables and \copy are used |
| Previous Message | John R Pierce | 2016-05-16 21:25:33 | Re: Connections - Postgres 9.2 |