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 1pU94Q-000515-UG for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 16:31:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pU94P-00062Z-Qb for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Feb 2023 16:31:17 +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 1pU94P-0005rX-E9 for pgsql-hackers@lists.postgresql.org; Mon, 20 Feb 2023 16:31:17 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pU94N-0004lk-7S for pgsql-hackers@postgresql.org; Mon, 20 Feb 2023 16:31:16 +0000 Received: by mail-io1-xd30.google.com with SMTP id bf15so1052315iob.7 for ; Mon, 20 Feb 2023 08:31:15 -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=AgCzYegrfR88ZMnfv4TxmK2I+9WrtnpqmHWlV6EPEn8=; b=r1GihanHfS3Lzf+f3iZMnUxTn50qawUgSc3OMxYcoZNXypIIVD+zE5zakrexHLCUjV ylnUIfsPKZc8EUoindj+qPi+ahGK6ua0s1Wua3RksKm1vT7bldzuG2iH7LrPrEv35QAE nJ1LSDLIOATBGm0cjg5MwoBcwwbUWj/Mwaew7hxSPA0j6LY4xEsg9rAc2JPgivAWH72r QcEWTO1i+LMQzX0GzpFvTVYzHTUZPpFWjIJVaQyR1KK7spsttP0SPFpM7xQoZqzeGz1s S8G4Fco+ycUaQ14/P1vag8p6fujtys4aYvNQmtd0LYoFW7g2OVTdqHwVutbtqy8iExxu o+Nw== 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=AgCzYegrfR88ZMnfv4TxmK2I+9WrtnpqmHWlV6EPEn8=; b=m8mPLvJtMNtALOe7SfftgElN1a9Htf8UAsYHYeAZXRN1G+lwXb1L7sIqsCXkRbu95z SO/+2czaoItgcloQgvAmdnqj1VQDlP8TyvpPceYx3REiV3ysQoo1tGqnE1up1PF8HU5g P5zIyvUDTHsNx0Qfomozf9WswoMS6PMh03OKzy0CABKxSJqyrAAzdt5y6Q7wR28mnXBr fJNlAYB7baniBT4z6Hswp6rQqyqk6rCNt/+Bg6wRmZ5H0MNDan/F59H/XfFGiSE/gwVa wSoikCX0x14Z9ZNKEk66Xh1eEs6p3a/DULrgYjlxxvGpFYkl4QELWXDta57sroFQpPSj f36Q== X-Gm-Message-State: AO0yUKXNtIJSdewExIYpj4werazVUaB87AYAwITipIHdFxaTVgXOvqdg urPrwslVTcgOxejGjPdQ3j5l5w== X-Google-Smtp-Source: AK7set8xvRGqzM6D+Z6pENQ6l2vyfB3T3eJpg2DSoPzGjMk7xvspfSpDK4ocPREVdGfJ0HgsxKBjTw== X-Received: by 2002:a6b:790c:0:b0:71f:4e1:74b6 with SMTP id i12-20020a6b790c000000b0071f04e174b6mr621056iop.4.1676910673475; Mon, 20 Feb 2023 08:31:13 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m3-20020a056602018300b007192441e5e6sm4392455ioo.45.2023.02.20.08.31.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 20 Feb 2023 08:31:13 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0DFDC800BC8; Mon, 20 Feb 2023 10:31:11 -0600 (CST) Date: Mon, 20 Feb 2023 10:31:11 -0600 From: Justin Pryzby To: Nathan Bossart Cc: Jeff Davis , pgsql-hackers@postgresql.org Subject: Re: add PROCESS_MAIN to VACUUM Message-ID: <20230220163111.GN1653@telsasoft.com> References: <20221230000028.GA435655@nathanxps13> <20230113233015.GA2423532@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230113233015.GA2423532@nathanxps13> 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 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 ? It seems like a good idea - it would allow simplifying an existing or future scripts which needs to reindex a toast table, saving the trouble of looking up the name of the toast table, and a race condition and server error log if the table itself were processed. I can imagine that might happen if a separate process used TRUNCATE, for example. -- Justin