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 1pGTVA-0007KJ-40 for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Jan 2023 23:30:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pGTV8-0006Ys-MF for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Jan 2023 23:30:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pGTV8-0006Yj-BD for pgsql-hackers@lists.postgresql.org; Fri, 13 Jan 2023 23:30:22 +0000 Received: from mail-pj1-x1032.google.com ([2607:f8b0:4864:20::1032]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pGTV5-0001vF-VL for pgsql-hackers@postgresql.org; Fri, 13 Jan 2023 23:30:21 +0000 Received: by mail-pj1-x1032.google.com with SMTP id o1-20020a17090a678100b00219cf69e5f0so28474213pjj.2 for ; Fri, 13 Jan 2023 15:30:19 -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=hu6qrGSaYkULyVxdhdLUdITJJiyZqliN1qpWjDkWjI4=; b=T8j/+xFpprJByU7Iv49svf9kOAacOcGH1q0YpxuZHJz6vuFH2fFm/wwdcvcqaVCy3w TXrM6FF3qjMo7chGketoUCHOeMKDqg/pHUfJESabyZY/Sy5QNVuFGFX8iZ+fafU8MMPm r7tAsVjtChpGGfFnS8FtrPgoUWdf7CfQIRSh5UxB96/Tbh4DY0c5CN9NLvhbio/3USfj DjtYZtr7z/GN0S8GjKzr1jV43nuAWlxgcTQUfioUull/BHdrx9YfnhbQEZGL4dYxe4wk E28JhHq2QrOzAorPrL1aL2Ue4WeUqdOF+rfRGTNk2zW4y/mdoDnvJ5MZR8xCmYXlZ2Ui ldEg== 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=hu6qrGSaYkULyVxdhdLUdITJJiyZqliN1qpWjDkWjI4=; b=DZZ3QI54hz3dv5IaZtBpFOi7hhbm7qoVhIsWyK3HoobcAd7gWsgCzTJl/FPF7ICArO Qsa/YrxkZ3/eZsIf5OC5A1rOKDLbenKgEjx/A/C84jlfLBGzqiFInlpCtYwkrcItAnZY 6hNFHTU9v4+oMnicPCwEVbKn96YTk/3NX1Z/JDPRTlOAjX0lB//9pp0rmTHa/pjY5A95 L7GW+A6b7hiBuBAzh9tBKK3YdiM1qvuyemmzI9FefMRu+6wMTsreYKbCtaMhNJ005Zdv hlVKzU4AmHwDPIRPPf56y0nUVt+nkLnTG49o7BU0CDdWM/9sxmnSm0i0dItWudjOwXte NvQQ== X-Gm-Message-State: AFqh2kp4+/oGn4kA3yfE6Nb976Jh3JZNDz81Su5Ub57K1P8QGMY4sTaH Ad8ENUIUKT8wyqzg+j78iy4= X-Google-Smtp-Source: AMrXdXv7hkZt/n3ZGzsgQC69wrczwFPlaVn/qqmZVjTJ+eOwX8833UiOMoMkqi3gnld1d8ZVB3q3jA== X-Received: by 2002:a17:902:f70c:b0:194:75d6:c95d with SMTP id h12-20020a170902f70c00b0019475d6c95dmr3230417plo.37.1673652618837; Fri, 13 Jan 2023 15:30:18 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id u16-20020a170902e5d000b001871acf245csm14728139plf.37.2023.01.13.15.30.17 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 13 Jan 2023 15:30:18 -0800 (PST) Date: Fri, 13 Jan 2023 15:30:15 -0800 From: Nathan Bossart To: Jeff Davis Cc: pgsql-hackers@postgresql.org Subject: Re: add PROCESS_MAIN to VACUUM Message-ID: <20230113233015.GA2423532@nathanxps13> References: <20221230000028.GA435655@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com