Postgres Pro
Downloads
Home   >   mailing lists

Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
Date
Msg-id f8ddee9d35553f802b5c1b1968f6c4c72a1640f1.camel@cybertec.at
Whole thread Raw
In response to How to force "re-TOAST" after changing STORAGE or COMPRESSION?  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
List pgsql-general
Tree view 
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.

You'd need something like

  -- rewrite all tuples
  UPDATE tab SET id = id;
  -- get rid of the bloat
  VACUUM (FULL) tab;

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
Next
From: Michael Paquier
Date:
Subject: Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?