MUHAMMAD ASIF wrote: > We have noticed the following issue with vacuumlo database that have millions > of record > in pg_largeobject i.e.
[...] > ~/work/pg/postgresql-9.1.2/inst$ bin/vacuumlo vacuumlo_test > > WARNING: out of shared memory > Failed to remove lo 36726: ERROR: out of shared memory > > HINT: You might need to increase max_locks_per_transaction. This is not a question for the hackers list. vacuumlo handles all deletes in a single transaction, so max_locks_per_transaction can be exhausted. Yours, Laurenz Albe -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers