On 10/17/21 10:17, Magnus Hagander wrote:
On Sun, Oct 17, 2021 at 5:12 PM Florents Tselai <[email protected] <mailto:[email protected]>> 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
[email protected]


Reply via email to