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 1pU9kG-00070Y-Et for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 17:14:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pU9kF-0001Ei-3M for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 17:14:31 +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 1pU9kE-0001EY-Mw for pgsql-hackers@lists.postgresql.org; Mon, 20 Feb 2023 17:14:30 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pU9k8-0005EN-4R for pgsql-hackers@postgresql.org; Mon, 20 Feb 2023 17:14:30 +0000 Received: by mail-pl1-x62a.google.com with SMTP id p1so195783plg.7 for ; Mon, 20 Feb 2023 09:14:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=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=pm+b1nBkd0Cj/XAnD2EcB/FfPzUgOu2NHuJih2UF9hA=; b=by6+KynFrpNRHg9NPRv7emvRdIJ/DIdEefd3oDSm3G/HRTEF34PhGJM9HVonkGtwe/ PkpK9DkxTclfOD9b+x3BO/7ugZ24BOX+IZDMPchx2VlcyExRi+WF41SwQTlXnrND1VFU kXw1NTLoT3AzfUvlPDALvmKbj5pZPcrAL2YY0A5PP0hDOJkibBvxEruDxaZSNCvBiw9x MJfZaSfAw3/NsJfUcdUKKaCq3yTNGodjtNXubop4RPrH+zd7GBG7G6yTl83Xv+r6+2gD sNueGzwqHmjItBSCcThabq69UehSFW4cvOngmaJsFZUzsEx/nhMPiawCN7QHFtZDbPu9 PBXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=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=pm+b1nBkd0Cj/XAnD2EcB/FfPzUgOu2NHuJih2UF9hA=; b=8EEMuW+Ls/MvH7jG/AJZcQrBqgb75YZQiJZdB9r3JQoj/sdCbyQLdWjzm8jhMU1y8M +zW9KnCDopoTZniH785j3f9kDZd/wpuBqZr3TM/yz5MmxJVHfH0brXHZNxAOSHl43LRW mDui9g9E6BSUlO5LdCd/UTaj+UYvxr1CvphhBf2ViLQS5M5izmv3jjCaggn6J41g5cox bmcnzYX/tjiu/9fxuJm+8nDSV8lCQcRZBEonm/n2l/NxvKJHqpqa9fuJ7kmu2sGVS/W5 ejpYZYSd/eICvUHHHcnv0A2KzIQOE9wVnVHHwxLM2ge2kFPXzPqpmoiZjxCBEyeIrNu7 uw0g== X-Gm-Message-State: AO0yUKXZ6/KtAx6wkrWoWloDYuRTuE2KMdVe6Uhy8FxvYL6kulXQExCO m7BALoxUM5pSOagHHTvRNC0= X-Google-Smtp-Source: AK7set/L6CUmXn/4IgDbw7II/1s22/TPtH+RLxq7SLXc0KK4Up8Qx/BfbxkNNF2B9iwi3L/PHziPpg== X-Received: by 2002:a17:902:ea03:b0:19a:6f28:ec2c with SMTP id s3-20020a170902ea0300b0019a6f28ec2cmr4063894plg.62.1676913262142; Mon, 20 Feb 2023 09:14:22 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id y9-20020a170902ed4900b0019a256bfe96sm8172528plb.242.2023.02.20.09.14.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Feb 2023 09:14:21 -0800 (PST) Date: Mon, 20 Feb 2023 09:14:19 -0800 From: Nathan Bossart To: Justin Pryzby Cc: Jeff Davis , pgsql-hackers@postgresql.org Subject: Re: add PROCESS_MAIN to VACUUM Message-ID: <20230220171419.GA3404133@nathanxps13> References: <20221230000028.GA435655@nathanxps13> <20230113233015.GA2423532@nathanxps13> <20230220163111.GN1653@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230220163111.GN1653@telsasoft.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Feb 20, 2023 at 10:31:11AM -0600, Justin Pryzby wrote: > On Fri, Jan 13, 2023 at 03:30:15PM -0800, Nathan Bossart wrote: >> On Fri, Jan 13, 2023 at 03:24:09PM -0800, Jeff Davis wrote: >> > For completeness, did you consider CLUSTER and REINDEX options as well? >> >> I have not, but I can put together patches for those as well. > > Are you planning to do that here, on this thread ? Yes, I just haven't made time for it yet. IIRC I briefly looked into CLUSTER and decided that it was probably not worth the effort, but I still think it's worth adding this option to REINDEX. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com