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.89) (envelope-from ) id 1hzZHm-0006aw-Oh for pgsql-bugs@arkaria.postgresql.org; Mon, 19 Aug 2019 04:28:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hzZHl-0002MK-16 for pgsql-bugs@arkaria.postgresql.org; Mon, 19 Aug 2019 04:28:49 +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 1hzZHj-0002MD-68 for pgsql-bugs@lists.postgresql.org; Mon, 19 Aug 2019 04:28:48 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hzZHf-0001YO-1m for pgsql-bugs@lists.postgresql.org; Mon, 19 Aug 2019 04:28:46 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id A37473A1; Mon, 19 Aug 2019 00:28:38 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 19 Aug 2019 00:28:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=LYgX8aArfy5gi7iVghvjzIV4YDu DXwwo4gfiziOHIdM=; b=FGzt19eH2AwnQs1p4hMPgRufBB8AV01FOhrpUAxXDpV I1L40f6+vOK/7GmhlAiKSrA+FdnnKXhg4eaIbPMno2LN8iahyBl9ReVs1auXhK12 KG9XNm4xgjltTrUSwGg61eofqRzBSKU4dHzyoh+qV4EI87Yd62RDHZr27J8IfaA5 f+UlOysM3aLin8eCXhCZ+MoMBWvQzN5DuUqf8FAa1GZNeit7nbEiz6N8gwsbnuWQ pDqraowgD8iv0H2llTSbLWk/UiFHYcC/505f+SvratHuSUbcQZ6e6lIp1/2fIbSj TJXaDTn/diNN86Wpd/cQN+oGkRji2GLtV+M/gtQcIJg== 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=fm3; bh=LYgX8a Arfy5gi7iVghvjzIV4YDuDXwwo4gfiziOHIdM=; b=ZEuojPd6XUYSBrKS3JqH/h RGtaqNbF0nY6PypIBh7hLU6mJOVLpC+qjcbVVqzaJ/Q48dg+JITWMxR4YOQcmS1e t1Fk/C2UJAPHRxiqFZRgNqeBeWJ1NVyyqQwnumWk6Qq0zVxnDc3whiQQ1xbyf4hg bM+CvSvQnSldXth/gI2rIXhTOBlb0Po082jiopoAQl6iu+x0pD+iHtRRAgt4ss7d EuKXnkqW3GeZzjlO6QhzqUVNDOT8ax6rAhdAs0KOfz3ah5BVrywxK+rnRFiFbu5o GjoMOZ/obtAGdXOG3azfq3sS9AI7PE0tPlGbgFGDYGsH++APahk5/+Uq9Z5pYMPw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrudefkedgkeefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepuddukedrvdeguddrvdehuddrudehfeenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fb99.ap.nuro.jp [118.241.251.153]) by mail.messagingengine.com (Postfix) with ESMTPA id 46731380083; Mon, 19 Aug 2019 00:28:35 -0400 (EDT) Date: Mon, 19 Aug 2019 13:28:32 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Andres Freund , Tom Lane , Dilip Kumar , jungleboogie0@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE' Message-ID: <20190819042832.GA1702@paquier.xyz> References: <20190818001858.ho3ev4z57fqhs7a5@alap3.anarazel.de> <20190819025953.GA15110@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="pWyiEgJYm5f9v55/" Content-Disposition: inline In-Reply-To: <20190819025953.GA15110@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --pWyiEgJYm5f9v55/ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Aug 18, 2019 at 10:59:54PM -0400, Alvaro Herrera wrote: > Hmm ... yeah, this is clearly not perfect. In my laptop, vacuumdb -j 1021 > works; 1022 and 1023 fail like this after opening a number of conns: > > So I agree that we need a fix. How would you detect how many fds can be opened by a user in this case? -- Michael --pWyiEgJYm5f9v55/ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl1aJXAACgkQnvQgOdby QH2X8RAAo2b83EKvdScluRbhHvtQuqPba3To4ITubQCMlm3XquXehrvoyq6DHvqw EdEm5qHnGQaJCrR9yrhgt6IHRKy/SE0/oJL/PxLujtkw0a2kMMYx0x0WWG/Rb93y UeTPhqvhtsyopKpNRggpt+RK7J1wHmxDgWH5jVvdHMDPO0THJjJln6ranIvgODDL cNJ4Ch/pBEVufjGmJsmosumaLA2/XVkM8WeOPTbpqfPaRjJJAvxCzLRul1aNDZM/ 64D069uFEsbbdHLYJXI1e5vkn8ymzTfCPiH7ouCcEDCVwrY7jzlx+IgH923UAL1W 32OFdn2Yvrn5ClNgxf3D2SyYp8FrVqZQCk9GOAq0u1+NLIX15T2EdKpSSlTrQPJm dCFQTerl+OJcLBtsJTXwIRFFzOTuXXNHUUn077904nvbR962o4p7wMAnLpgOXYhC 3qGZvszGZbd1pr/xCREf5A0ZeuMrYdjMKlWG8MhkSDkeQkMEDa40R4QBf8DHMY2S FIFJ+9rewOqd/JRQ74k0rL9hzNmUa6k/uSyeIVz3nMI+DUbax/FdFQeuAITcWXpk jvt4OmwCytNlI/GbeHX/yskdu2c7E5JEw3g4+M//f2ZLGqXn2Elg2TYAkKHGAybL 6QCRwcoA3+N9TgV+pF9mU3R8TspGiQ29HxFxElFEGnq4Egt4CkI= =rUM0 -----END PGP SIGNATURE----- --pWyiEgJYm5f9v55/--