aboutsummaryrefslogtreecommitdiff
path: root/src/bin/scripts/common.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2012-03-20 19:05:08 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2012-03-20 19:05:44 -0400
commit64c604898e812aa93c124c666e8709fff1b8dd26 (patch)
tree77fad7849276fa6c8e3396b256279222c81ec509 /src/bin/scripts/common.c
parent9d23a70d513aa1312135d6cedd444e7e3e933edb (diff)
downloadpostgresql-64c604898e812aa93c124c666e8709fff1b8dd26.tar.gz
postgresql-64c604898e812aa93c124c666e8709fff1b8dd26.zip
Improve the -l (limit) option recently added to contrib/vacuumlo.
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.
Diffstat (limited to 'src/bin/scripts/common.c')
0 files changed, 0 insertions, 0 deletions