Request a Demo
Home   >   mailing lists

Re: REPACK and naming - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: REPACK and naming
Date
Msg-id CAB-JLwZEP7pVWtEjr21hyOrbWcywwSXYbW3xtPGwk_Rrqa0nUg@mail.gmail.com
Whole thread Raw
In response to REPACK and naming  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Mircea Cadariu
Date:
Subject: Re: [BUG] temporary file usage report with extended protocol and unnamed portals
Next
From: Álvaro Herrera
Date:
Subject: Re: REPACK and naming