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