Vacuum ignores large objects - Mailing list pgsql-hackers

From Tom Lane
Subject Vacuum ignores large objects
Date
Msg-id 7188.928447493@sss.pgh.pa.us
Whole thread Raw
Responses Re: [HACKERS] Vacuum ignores large objects  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] Vacuum ignores large objects  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: David Sauer
Date:
Subject: idea for compiling
Next
From: Don Baccus
Date:
Subject: Re: [HACKERS] Priorities for 6.6