Re: vacuumlo issue

Albe Laurenz <laurenz.albe@wien.gv.at>

From: "Albe Laurenz" <laurenz.albe@wien.gv.at>

To: "MUHAMMAD ASIF *EXTERN*" <anaeem.it@hotmail.com>, <pgsql-hackers@postgresql.org>

Date: 2012-03-20T14:53:37Z

Lists: pgsql-hackers

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