I have a big table which needs a Vacuum full, but I don't have enough disk space. I was looking online and came across some: pg_repack, pg_squeeze, ...

Am I mistaken or are all these extensions Linux only? Are there similar extensions for Postgresql running on Windows? I'm looking for an extensions which can remove bloat (deleted tuples, ... ) from a table without locking the table like Vacuum full does.

Any help is greatly appreciated.

  • You probably need to see if you can compile any of those extensions on Windows. pgcompacttable is written in Perl, so maybe it runs on Windows as well
    – user1822
    Aug 7, 2022 at 18:47
  • I think those don't do what you want anyway, they still take up extra space while the table is being rewritten.
    – jjanes
    Aug 7, 2022 at 23:51
  • It is not obvious to me how to make pgcompacttable run on Windows, but you can at least run it from Linux but point it at a db server running on Windows.
    – jjanes
    Aug 8, 2022 at 0:04
  • In other words, mainly all extensions are linux only? That's a bummer. Only thing I can do is dump the table to an other server and restore it in production. But with a table of this size, I really don't know how long the dump / restore will take. I can't put them offline for days...
    – Morph
    Aug 9, 2022 at 7:15


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.