• Tom Lane's avatar
    Improve the -l (limit) option recently added to contrib/vacuumlo. · 64c60489
    Tom Lane authored
    Instead of just stopping after removing an arbitrary subset of orphaned
    large objects, commit and start a new transaction after each -l objects.
    This is just as effective as the original patch at limiting the number of
    locks used, and it doesn't require doing the OID collection process
    repeatedly to get everything.  Since the option no longer changes the
    fundamental behavior of vacuumlo, and it avoids a known server-side
    limitation, enable it by default (with a default limit of 1000 LOs per
    transaction).
    
    In passing, be more careful about properly quoting the names of tables
    and fields, and do some other cosmetic cleanup.
    64c60489
vacuumlo.sgml 4.17 KB