Vacuum ignores large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Vacuum ignores large objects
Date: 1999-06-03 22:04:53
Message-ID: 7188.928447493@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 1999-06-03 22:15:16 Re: [HACKERS] Priorities for 6.6
Previous Message David Sauer 1999-06-03 21:40:51 idea for compiling