Re: Vacuumlo improvements

Nathan Bossart <nathandbossart@gmail.com>

From: Nathan Bossart <nathandbossart@gmail.com>
To: Shawn McCoy <shawn.the.mccoy@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2026-05-14T03:10:28Z
Lists: pgsql-hackers

Attachments

On Tue, May 12, 2026 at 10:00:15PM -0500, Nathan Bossart wrote:
> Commit 64c604898e added the note about domains to the docs.  Unfortunately,
> neither that nor the corresponding thread [0] offer any clues as to why
> vacuumlo doesn't resolve domains.  The commit history for vacuumlo has been
> pretty quiet for a long time, so maybe it's just been overlooked.

It seems to be relatively easy to teach vacuumlo to handle domains over
oid.  Note that you need a recursive query because you can have domains
over domains.  Please test it out.  I noticed that vacuumlo's tests are
pretty sad, so this might be a good opportunity to change that.

-- 
nathan