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 1pFhrt-00041L-Pi for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Jan 2023 20:38:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFhrs-0001z9-Fi for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Jan 2023 20:38:40 +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 1pFhrs-0001yz-2E for pgsql-hackers@lists.postgresql.org; Wed, 11 Jan 2023 20:38:40 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pFhrp-0002nD-Hh for pgsql-hackers@postgresql.org; Wed, 11 Jan 2023 20:38:39 +0000 Received: by mail-il1-x12e.google.com with SMTP id bp26so8471720ilb.3 for ; Wed, 11 Jan 2023 12:38:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=NH+JFZvtdrmvQSYzcRjbMmhSNVwHCecO1+TWdrHZX4A=; b=xhl3iSZege2CTBr7xwQqv0eOaCPbBD9yHticwyUSE8Y84/KvoDQlM+hvgZti6D3VgU XIxgdGfYS9TXeKsxquNkkWYsL/Ir7tA8ZXXTguulAI4mEtnDaWN1ycgo+B+OhEoD0/Rp l82tgpksMC94Cc9uBxwtVVVfs2fVHKXnr4xepcr6rQBKhDTqNKSGrbPIwcons4Gy8tcf s1jOgoqmMrKBt+J8Zesz9O/+3ZEAu6M/2aoEqHuiwy0op+OaBcBa+Ixa6NfDv3hF7wg3 zVLF8j4GEubej3rz5cPvp2w/d4ETc2ThV+c3Xx3Nw37x9dR7Tbk43xuD9Sg2EWxoz58Z b1Vg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=NH+JFZvtdrmvQSYzcRjbMmhSNVwHCecO1+TWdrHZX4A=; b=NUpkvPgVRBpyI8rW876x1VFJhurs0PNquJVY2i+6lvb1ft5djmuxtVWEa7ZL+H9PjB 7NJG9GDiCuABPd21M3U7TeO6SadqkpT2dSzjUNol6p7R5UREoVGkwgopwxwvznXEw5/a NJwfZp0rUztTUc/1ZcQH9Z2nXfR4P8FLhnpuvK0ZhpGddh7rP1qdB+yrkOxkPWLMmB05 TdRKXSmfym/xHkvOBDz7HPcft/CoZwRg8mpxsFaInvgvZZsHIg+nLzGkUQ8zAa3eXr1q qurjhk9LflaxXAMDuinZKGr331TBtTQsLIhc9Dmhcg/k611pvtCSddvtpKi8Guyq/RbE 62Bg== X-Gm-Message-State: AFqh2krU2H5CtiEHROywwLpZdK44MgGEaaDeph9BBFbCi5S6ZWJ1OqYa YGILBkV95wdAh3pdZaape1ff0g== X-Google-Smtp-Source: AMrXdXvzMUzgNAL9taJ2uvSgh+GeknnTv5NgQLKtMe2gFvR7jUvqVIOLN1S6oouN+dK52Jnw/o65mQ== X-Received: by 2002:a05:6e02:218d:b0:30c:2266:cfca with SMTP id j13-20020a056e02218d00b0030c2266cfcamr49398948ila.9.1673469515839; Wed, 11 Jan 2023 12:38:35 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id e10-20020a026d4a000000b0038ac4923addsm4714930jaf.53.2023.01.11.12.38.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Jan 2023 12:38:35 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 4C78E800E60; Wed, 11 Jan 2023 14:38:34 -0600 (CST) Date: Wed, 11 Jan 2023 14:38:34 -0600 From: Justin Pryzby To: Andres Freund Cc: Peter Geoghegan , pgsql-hackers@postgresql.org, Robert Haas , Melanie Plageman , David Rowley Subject: Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode Message-ID: <20230111203834.GM9837@telsasoft.com> References: <20230111182720.ejifsclfwymw2reb@awork3.anarazel.de> <20230111185854.5srlvequbxbg5p6c@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230111185854.5srlvequbxbg5p6c@awork3.anarazel.de> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 11, 2023 at 10:58:54AM -0800, Andres Freund wrote: > Hi, > > On 2023-01-11 10:35:19 -0800, Peter Geoghegan wrote: > > On Wed, Jan 11, 2023 at 10:27 AM Andres Freund wrote: > > > Therefore I'd like to add an option to the VACUUM command to use to disable > > > the use of the ringbuffer. Not sure about the name yet. > > > > Sounds like a good idea. > > Any idea about the name? The obvious thing is to reference ring buffers in the > option name, but that's more of an implementation detail... > > Some ideas: > > USE_RING_BUFFERS on|off > REUSE_BUFFERS on|off +1 for either of these. I don't think it's an issue to expose implementation details here. Anyone who wants to change this will know about the implementation details that they're changing, and it's better to refer to it by the same/similar name and not by some other name that's hard to find. BTW I can't see that the ring buffer is currently exposed in any user-facing docs for COPY/ALTER/VACUUM/CREATE ? -- Justin