public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jeff Davis <[email protected]>
To: Nathan Bossart <[email protected]>
To: [email protected]
Subject: Re: add PROCESS_MAIN to VACUUM
Date: Fri, 13 Jan 2023 15:24:09 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <20221230000028.GA435655@nathanxps13>
References: <20221230000028.GA435655@nathanxps13>

On Thu, 2022-12-29 at 16:00 -0800, Nathan Bossart wrote:
> The motivation for adding this option is to make it easier to VACUUM
> only a
> relation's TOAST table.  At the moment, you need to find the TOAST
> table by
> examining a relation's reltoastrelid, and you need USAGE on the
> pg_toast
> schema.  This option could also help make it possible to call only
> vac_update_datfrozenxid() without processing any relations, as
> discussed
> elsewhere [2].

For completeness, did you consider CLUSTER and REINDEX options as well?


-- 
Jeff Davis
PostgreSQL Contributor Team - AWS

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: add PROCESS_MAIN to VACUUM
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox