Em sex., 10 de jan. de 2025 às 06:31, Antonin Houska <a...@cybertec.at> escreveu:
> Thus I understand Alvaro's objections against VACUUM (FULL, CONCURRENTLY). > > Therefore I can imagine adding a new command that acts like VACUUM (FULL, > CONCURRENTLY), but does not try to be CLUSTER (CONCURRENTL). > If VACUUM FULL and CLUSTER do the same, why not have a single command ? --VACUUM FULL would be RECREATE TABLE [ CONCURRENTLY ] table_name --CLUSTER would be RECREATE TABLE [ CONCURRENTLY ] table_name CLUSTERED [ON index_name] --Maybe someday reordering fields would be RECREATE TABLE [ CONCURRENTLY ] table_name CLUSTERED [ON index_name] [USING FIELDS (FLD4,FLD5,FLD3,FLD1,FLD2)] regards Marcos