On Tue, Oct 03, 2023 at 06:31:27AM +0200, Laurenz Albe wrote: > On Tue, 2023-10-03 at 12:33 +1100, rob stone wrote: >> Would running CLUSTER on the table use the new parameters for the re- >> write? > > No, as far as I know. Note that under the hoods VACUUM FULL and CLUSTER use the same code paths when doing their stuff. > You'd need something like > > -- rewrite all tuples > UPDATE tab SET id = id; > -- get rid of the bloat > VACUUM (FULL) tab; I'm afraid so, and get ready for a burst of WAL that depends on the size of your relation if you are too aggressive with the updates. You could do that in periodic steps, as well. -- Michael
Attachment:
signature.asc
Description: PGP signature
