Re: Force re-compression with lz4

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Force re-compression with lz4
Дата
Msg-id dcb6fb5e-844a-0e44-2b1b-879e8a49ac97@aklaver.com
обсуждение исходный текст
Ответ на Re: Force re-compression with lz4  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Force re-compression with lz4
Список pgsql-general
Дерево обсуждения 
On 10/17/21 10:17, Magnus Hagander wrote:
> On Sun, Oct 17, 2021 at 5:12 PM Florents Tselai 
> <florents.tselai@gmail.com <mailto:florents.tselai@gmail.com>> wrote:

> 
>     Is there a smarter way to do this ?
> 
> 
> It should be enough to VACUUM FULL the table. (but it has to be VACUUM 
> FULL, not a regular vacuum). Or CLUSTER.

With the proviso that this will require double the existing space, 
~670GB, until the operation is completed.

> 
> -- 
>   Magnus Hagander
>   Me: https://www.hagander.net/ <http://www.hagander.net/>
>   Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>


-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления: