Signiant Support

Running vacuumlo with limit option on 11.x Windows Manager Print


Problem


Customer has millions of large objects on a Windows 11.x manager that need to be removed but vacuumlo eats up way too many resources to do this. How can I use vacuumlo from a 12.x manager so that the -l (limit) option will remove the objects in smaller batches?

Resolution


Attached is a zip file of the files needed. It contains the following:
- vacuumlo.exe - Make a copy of the current <Signiant>\db\pgsql\bin\vacuumlo.exe and place the new file here
- libinitl-8.dll - Copy this to <Signiant>\db\pgsql\bin\
- msvcr120.dll - Copy this to C:\Windows\System32\

You can then run vacuumlo with the -l option.

Attachments

vacuumlo.zip vacuumlo.zip