Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jMRU7-0005j3-Dk for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2020 07:20:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jMRU6-0000gi-7c for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2020 07:20:22 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jMRU6-0000gb-0W for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2020 07:20:22 +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 1jMRU3-0001NA-GI for pgsql-hackers@postgresql.org; Thu, 09 Apr 2020 07:20:21 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 1C7B55C01E0; Thu, 9 Apr 2020 03:20:18 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 09 Apr 2020 03:20:18 -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=fm1; bh=/asAIXX993uU1ZeyxxJ7mDqwG2a 6Hg2OrhxApBY8fVw=; b=Lnkry10XcIGH+fT+qpWirYKdJanXegyRTuHZO/kWglf BsfphVxY5iZjdsum+nva3F4OcSU4U2coGemvExndz/MAiaCoe0+FV/94uF9DkmI2 4HkNB8DGY+8GiaMdxZ4UsZhUshsRgCtTE2/aZ+HH2IPvRPBD6B4tDzGPKI/hD02u b79N1knEyIqwRvhg4w1hcNvgpeJJO8K53B8tELqnukVMAcKVE9/dYUKYSotmEFVa EMZhCE9HpFG/TWWcAnHZklKLGEd7WU1X+O3qjhtYrqKvzgX+bWwFefJ/v/im5NQZ 9q075owDVq8MgXBfSBPOfyt2cFCPrtmPDFKOA9OIulg== 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=/asAIX X993uU1ZeyxxJ7mDqwG2a6Hg2OrhxApBY8fVw=; b=0XbZnc0OT9pj3hUG6OhCUf QwlzYMj+7RXz2gzEF/RAKSTq6GKHcNV4ihe52nDw/thQzeuRBWvISo9Av3+EF5AR 1X/5NoNPPu0lHObpGsIO4Rl0sem3xBLraXkz42No67vLBnYTA88lJ1vGA1jWPrkt +04ExQfLAxn8zxGzqfNH9C0OVnhbx8B1rDiot9QE3CeAlPeixT8TXYmRtHvMCN5M KNZ7u7C6hvMFIVwEWdmbZcsQljgUyoz8xkHkykwH3ySkgytBbcg1uBNnu25OXOvT 1XxtvzvCRrQT7rz0QClH/tQiOC+H6vdGvKc92sFIQIKuoQoE6crAQwV5jKvshQ8g == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduhedrudekgdduudeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlse hprghquhhivghrrdighiii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 9C0FE328005D; Thu, 9 Apr 2020 03:20:15 -0400 (EDT) Date: Thu, 9 Apr 2020 16:20:13 +0900 From: Michael Paquier To: Amit Kapila Cc: tushar , Justin Pryzby , Mahendra Singh Thalor , Robert Haas , PostgreSQL-development Subject: Re: Vacuum o/p with (full 1, parallel 0) option throwing an error Message-ID: <20200409072013.GS1606@paquier.xyz> References: <20200408164154.GD2228@telsasoft.com> <20200408183854.GG2228@telsasoft.com> <20200409013654.GM1606@paquier.xyz> <20200409064426.GQ1606@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="JHjDRUnf1JOMxzko" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --JHjDRUnf1JOMxzko Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Apr 09, 2020 at 12:33:57PM +0530, Amit Kapila wrote: > We can add more tests to validate the syntax, but my worry was to not > increase test timing by doing (parallel) vacuum. So maybe we can do > such syntax validation on empty tables or you have any better idea? Using empty tables for positive tests is the least expensive option. -- Michael --JHjDRUnf1JOMxzko Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl6OzK0ACgkQnvQgOdby QH3ciA//bckqdCdvsjDGNNqVcM/Ul9OcEQ9QDKxcduio2JVmtT4HCxJCLTaeo5QU 8WUiv4F66fRqOvAA24cDDa2i9DdJ72zqR23EEAaxHMV86FDjwpPmFTl9jUUZIyNF aS5h2+hV79U5rCJYiQSk1f+V4glsgxOq4gTA/rvP7cDsqtfi8uFhILZ1U23H1Qkv LH1yz6vmngZ+/XD2WIY+H4AnXyhjd4AULreIfdHmsZBLUusGBgH5Fdtmk56jL5Fq FGSkR9by5FaN7T8JGVAY54WFy6egN8J0dqVhl6RBc6de44Jc3C450GXEmY9BYpKo 7ngsG0sAIVDu44UKwufsoXP/VD7AzybNv0Z7TwzgEZK7gdG995XwnqxpmKDB0Zih FUpaMQO9vQp7XYm6nHGZPG6NT0wb+jZrC60kACBhLHLz6mY/e6nc2pzVGdU0J2rK ltvuDbuwVWnikJXtI5uGpHo5FvKF9w7wp5uUEJ0MrIpbZMJeEkpnP5NqjBasNUoW 98r6ytAApwhywXFi7IC2ExjXta2aifmZRinXipT/hhEIAuervDtNU0iP+5w+PZ2S PsBLlh0ZwQtLHWEsydXBp9gQLyHmefXV2o2MZaWG9vU1QDOfLmre4cefxZjgD9L2 nEGWBbAGoN47WR86rmW2MT+fSnIgwRqHqNqUb9nRcK/3nXDr65k= =55SD -----END PGP SIGNATURE----- --JHjDRUnf1JOMxzko--