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 1jM9it-0003PK-Sb for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 12:22:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jM9is-00035H-Os for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2020 12:22:26 +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 1jM9is-000359-CC for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2020 12:22:26 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jM9ip-0000eR-Hb for pgsql-hackers@postgresql.org; Wed, 08 Apr 2020 12:22:26 +0000 Received: by mail-lj1-x234.google.com with SMTP id r7so7342567ljg.13 for ; Wed, 08 Apr 2020 05:22:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=X8SRqTeOHumpADZeyGAxm1vBDvYDo0B1F18cbgFTlsU=; b=oxZh9+4ujvon1XN/n2N31aWOv4p7ssPzlIRbTCVJYRrGhBDh3DfPkq4TVylxL8A+V+ KM1PqiDy8flm5JOXFzkXLkCtyFrqJoY1yCgm70X9d1OIfR9ehjlV3FT5RtyhehR0JyHS pxlWI63AhWyC9e1jJBws+K8HoZuKKLKyMIJxuuNC7cByJSVzYJHEujQ2l0kyEhKqRyhE e1JHXnuEbZdt9BbbjmC+VeVl92Yy0ACxPmf8ShRTh/2u9y8YejrhZV14LiFMWK/r/E0q BwIwOLGlIxXsggtM49di0azDokFb5T4cjlFcBVC9wCUu+MRaovjy/ED7LDXszN4JfDyQ DF1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=X8SRqTeOHumpADZeyGAxm1vBDvYDo0B1F18cbgFTlsU=; b=CrSwPKQ1J8DpQNWo/tTP1LQ1uq973dg/nowypz8besG2x8GxjXcjN98nsuhtvaCZwb WcATJ8PAq/ZJ0TCEGf4QwDQhiuXaKScOhVN/HUvZ7aQG52fTnuUjaQ+Kgnhfd2N8owck cTrFZXhyDgn+OEWyHd6nPfG4SLi2OaiSv9iJQG11L/oPoKy/rW/GgvGPYG7zxUJBhpNd fJ4JzWBhkE9RDINXZcYPdTiKyDmpfjvBoOboVb8nZDy5X596OmaMLnAyeXt4kh1k8YrW 8AHBriUC13ASSEOXq//2wROjKyvm/UNKw8dfNae+7nXEYNsZMj90wU64prTv+1gUfnn+ 8Kvw== X-Gm-Message-State: AGi0Pubv+iDUgPUfpQF2XB2+NjfVxiWidCPKHnt37UfUXdMtiWm3j5RJ u8aNgZvIblqCoNLn65M+gqiK1uCk8U0+GhUKMVageYrfykrnESidZJ7UfBSvFelxxos0FgNdMx9 Oy7XMkGDnjpH0npsT8aE4EzCBYXl3dhMvBKk+EPYzbMug8j1CR0sOpeaQ4b2u6O6ja3XgUod3t9 EkHbgdF0CpIWzJBPf96bivTAkh6jt9F6fFsQXY9K7RS9iS6PXbEy7BiamNnoggT+Y184qGyOGuO 9Lo0MOvEy8/ue1zkFvSJbr3a/O3 X-Google-Smtp-Source: APiQypI0uzTTkmTO9hKzy+L5QIHyck+CTzsr/s3owbLvHzCTmfnJwOyHHXwwfwUT7jH2blLLf3qQkQ== X-Received: by 2002:a2e:8290:: with SMTP id y16mr4798873ljg.186.1586348542460; Wed, 08 Apr 2020 05:22:22 -0700 (PDT) Received: from localhost.localdomain ([157.33.140.123]) by smtp.gmail.com with ESMTPSA id 22sm13330218ljq.69.2020.04.08.05.22.18 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Apr 2020 05:22:21 -0700 (PDT) To: PostgreSQL-development From: tushar Subject: Vacuum o/p with (full 1, parallel 0) option throwing an error Message-ID: <58c8d171-e665-6fa3-a9d3-d9423b694dae@enterprisedb.com> Date: Wed, 8 Apr 2020 17:52:12 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US X-CLOUD-SEC-AV-Info: edb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, I just came across this scenario  where - vaccum o/p with (full 1, parallel 0) option not working --working postgres=# vacuum (parallel 1, full 0 ) foo; VACUUM postgres=# --Not working postgres=# vacuum (full 1, parallel 0 ) foo; ERROR:  cannot specify both FULL and PARALLEL options I think it should work. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company