| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Shawn McCoy <shawn(dot)the(dot)mccoy(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Vacuumlo improvements |
| Date: | 2026-05-14 03:10:28 |
| Message-ID: | agU9JPim3XNwRJ4b@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-teach-vacuumlo-to-handle-domains-over-oid.patch | text/plain | 1.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-05-14 03:34:34 | Re: pgbench: make verbose error messages thread-safe |
| Previous Message | Nisha Moond | 2026-05-14 03:05:06 | Improve conflict detection when replication origins are reused |