agora inbox for pgsql-hackers@postgresql.org  

help / color / mirror / Atom feed

From: Antonin Houska <ah@cybertec.at>
To: Alvaro Herrera <alvherre@kurilemu.de>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: REPACK (ANALYZE) within transaction block segfaults
Date: Wed, 02 Sep 2026 10:47:26 +0200
Message-ID: <15397.1788338846@localhost> (raw)
In-Reply-To: <apfbHj9TkfvlOeJ3@alvherre.pgsql>
References: <apfbHj9TkfvlOeJ3@alvherre.pgsql>

Alvaro Herrera <alvherre@kurilemu.de> wrote:

> On 2026-Sep-02, Fujii Masao wrote:
> 
> > + * that's just consistent with VACUUM (FULL, ANALYZE), which is a
> > + * synonym for REPACK (ANALYZE).
> > 
> > Is VACUUM (FULL, ANALYZE) really a synonym for REPACK (ANALYZE)?
> 
> That's the intent, at least.  If there are things that work differently,
> I would strive to change them so that they do work the same.  However,
> some such changes might be too invasive for pg19, but I would still see
> about changing those in pg20.
> 
> Now, maybe there are things about VACUUM FULL ANALYZE that we don't like
> (perhaps, for instance, they exist solely because of even older
> backwards compatibility concerns) that we would prefer not to have in
> REPACK.  I don't know if anything of that sort exists, but if so, I
> would propose to seek decisions for each thing individually.

Maybe the question was about the wording - "synonym" might indicate that both
commands execute the same code. Perhaps the comment should rather say that
REPACK (ANALYZE) is (intended to be) a replacement of VACUUM (FULL, ANALYZE).

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com

view thread (25+ messages)  latest in thread

Message-ID: <15397.1788338846@localhost>
Permalink:  ../15397.1788338846@localhost/
Also on:    postgresql.org/message-id/15397.1788338846@localhost

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: pgsql-hackers@postgresql.org
  Cc: ah@cybertec.at, alvherre@kurilemu.de, masao.fujii@gmail.com, nathandbossart@gmail.com
  Subject: Re: REPACK (ANALYZE) within transaction block segfaults
  In-Reply-To: <15397.1788338846@localhost>

* 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