On 10/17/21 10:17, Magnus Hagander wrote:
On Sun, Oct 17, 2021 at 5:12 PM Florents Tselai <florents.tse...@gmail.com <mailto:florents.tse...@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.kla...@aklaver.com


Reply via email to