Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jAIED-0005oY-0v for pgsql-docs@arkaria.postgresql.org; Fri, 06 Mar 2020 19:01:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jAIE9-0000yY-L3 for pgsql-docs@arkaria.postgresql.org; Fri, 06 Mar 2020 19:01:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jAID3-0000ND-Rb for pgsql-docs@lists.postgresql.org; Fri, 06 Mar 2020 19:00:33 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jAID1-00063c-JR for pgsql-docs@lists.postgresql.org; Fri, 06 Mar 2020 19:00:33 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 7BF1422458; Fri, 6 Mar 2020 14:00:30 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Fri, 06 Mar 2020 14:00:30 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=V7CDXlFBHCRzaxDH3WHDYS7LYuE ovHOcTX1oNqoVOZE=; b=cIjALZi6uwQHYdb8A5A//xrPx2xy056dxyu7xfeVgj/ NuVpX5kGLdBdhBgpIVqDBjv/A/NdpVhcetGTazYXIAsWi8TZo4PnoQ/iLr5xU42/ 7G1OrL62Yi+/Rg/L/Uwkg8Gb/LDhU5S3Zn1AtpyFy8rFTQd1skfoBLFO3faHGRKR yjGbRrqRL+sXQkawY+9sqVErszvePmaUSOyj26kVM/cBfHFl4aRniWQ+d7o4iUNO W4P997dqRW6/MBwd+nyQ/02Ig6JqYUIiSK02nKwf/cnwW4SEBRuBfONK81Gg+2Jl x3sYzoChOs2XOYTCl5xo32hZev75FW7EdIus980EiDA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=V7CDXl FBHCRzaxDH3WHDYS7LYuEovHOcTX1oNqoVOZE=; b=zY0NsoRZ0oK+uaHf7Fc5/l r/3v9kjxND8cWCgsoqiiwjUtmk5e/6lxFk5mk3Y8e3TXAa/VE4UuTypSlZjfNl1j kR1davvW7b67/06BLYLZsmKfiTvhU/bRaFOmCfn1EO4REpJyZ2j1tCc1QCG0+pgl eC3GT6W7ipcwhzeRj1RlStQM97FY+D0sdl2UEQwnCtjOIshpFxbWqijTzbu9Oh3B 4uFgHsrBXLYauKF04pmyjtGi56TQ+17lVwailh4Nd26VXe7OLVaIr7B4FTWlq4mF +6J0RCiUOmKXzlF8ogeY5s9FeK6YErmhsSKcMN2Mlg3Y+U77zRlK21Chwc0hFCCA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrudduvddguddvfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecukfhppe dujedvrdehkedrledvrddugeelnecuvehluhhsthgvrhfuihiivgepfeenucfrrghrrghm pehmrghilhhfrhhomheprghnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Received: from intern.anarazel.de (unknown [172.58.92.149]) by mail.messagingengine.com (Postfix) with ESMTPA id 9A1BF306075F; Fri, 6 Mar 2020 14:00:29 -0500 (EST) Date: Fri, 6 Mar 2020 10:06:57 -0800 From: Andres Freund To: Tatsuo Ishii Cc: pgsql-docs@lists.postgresql.org Subject: Re: No mention about somaxconn Message-ID: <20200306180657.fybtyz72lyxjn4kr@alap3.anarazel.de> References: <20200303.104856.428069491336830601.t-ishii@sraoss.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200303.104856.428069491336830601.t-ishii@sraoss.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2020-03-03 10:48:56 +0900, Tatsuo Ishii wrote: > Currently there's no mention about net.core.somaxconn parameter needs > to be adjusted if max_connections is large and UNIX domain socket is > used for connection. Since the default for the kernel parameter is > small (typically 128), it is easy to hit the limitation and you will > get errors something like: > > could not connect to server: Resource temporarily unavailable > > I don't know if this should be applied to other OS as well though. Yea, that'd be good. Care to suggest a patch? Greetings, Andres Freund