Horton

Re: REPACK and naming

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Álvaro Herrera <alvherre@alvh.no-ip.org>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-development <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-17T13:36:34Z
Lists: pgsql-hackers 
Em qua., 17 de set. de 2025 às 10:17, David G. Johnston <
david.g.johnston@gmail.com> escreveu:

> That changes logical aspects of a table and so would be done as part of
> alter table, IMO. “AT tbl Rearrange columns (names list) “
>

If this command recreates entirely that table, it is not only a logical
aspect of that table.
REPACK/RETABLE recreates that table as a replacement for VACUUM FULL/CLUSTER
and ALTER TABLE REARRANGE COLUMNS would recreate that table too ?
and both would have USING INDEX to do what CLUSTER does today ? both would
have CONCURRENTLY ?

Being named REPACK or RETABLE or RECREATE TABLE or COMPACT or anything else
could do it all.

regards
Marcos