Re: Force re-compression with lz4 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Force re-compression with lz4
Date
Msg-id dcb6fb5e-844a-0e44-2b1b-879e8a49ac97@aklaver.com
Whole thread Raw
In response to Re: Force re-compression with lz4  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Force re-compression with lz4
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Force re-compression with lz4
Next
From: Florents Tselai
Date:
Subject: Re: Force re-compression with lz4