Re: Connections - Postgres 9.2

John R Pierce <pierce@xxxxxxxxxxxx> · Mon, 16 May 2016 14:25:33 -0700



    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.

    
    -- 
john r pierce, recycling bits in santa cruz