Vacuum ignores large objects

Is there a reason why vacuum won't vacuum large objects? AFAIK they
are not really different from ordinary relations, and could be vacuumed
the same way. If you do a lot of lo_writes to a large object, its file
size grows without bound because of invalidated tuples, so it'd sure
be nice for LOs to be vacuumable...

Trying to force the issue doesn't work either:

lotest=> vacuum xinv150337;
NOTICE: Vacuum: can not process index and certain system tables
VACUUM

Really. I thought they were just bit buckets. I didn't realize they
actually contain transaction id's and versions.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Added to TODO:

o Allow large object vacuuming

Is there a reason why vacuum won't vacuum large objects? AFAIK they
are not really different from ordinary relations, and could be vacuumed
the same way. If you do a lot of lo_writes to a large object, its file
size grows without bound because of invalidated tuples, so it'd sure
be nice for LOs to be vacuumable...

Trying to force the issue doesn't work either:

lotest=> vacuum xinv150337;
NOTICE: Vacuum: can not process index and certain system tables
VACUUM

regards, tom lane

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026