Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
Дата
Msg-id f8ddee9d35553f802b5c1b1968f6c4c72a1640f1.camel@cybertec.at
обсуждение исходный текст
Ответ на How to force "re-TOAST" after changing STORAGE or COMPRESSION?  (Dominique Devienne <ddevienne@gmail.com>)
Ответы Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: How to force "re-TOAST" after changing STORAGE or COMPRESSION?