| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net>, Florents Tselai <florents(dot)tselai(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Force re-compression with lz4 |
| Date: | 2021-10-17 17:28:24 |
| Message-ID: | dcb6fb5e-844a-0e44-2b1b-879e8a49ac97@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 10/17/21 10:17, Magnus Hagander wrote:
> On Sun, Oct 17, 2021 at 5:12 PM Florents Tselai
> <florents(dot)tselai(at)gmail(dot)com <mailto:florents(dot)tselai(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florents Tselai | 2021-10-17 19:03:55 | Re: Force re-compression with lz4 |
| Previous Message | Magnus Hagander | 2021-10-17 17:17:14 | Re: Force re-compression with lz4 |