Thread

Re: REPACK and naming

Marcos Pegoraro <marcos@f10.com.br> — 2025-09-17T13:36:34Z

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