Re: Handle concurrent drop when doing whole database vacuum - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Handle concurrent drop when doing whole database vacuum
Date
Msg-id akKjVNL9LyTexpEi@nathan
Whole thread
In response to Re: Handle concurrent drop when doing whole database vacuum  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Handle concurrent drop when doing whole database vacuum
List pgsql-hackers
On Wed, Jun 24, 2026 at 08:40:22AM +0900, Michael Paquier wrote:
> I'd sure welcome Nathan and Jeff opinions (added now in CC) regarding
> this line of thoughts; they worked on MAINTAIN, even if the early
> relation ACL check when building a list of relations for a
> database-wide manual VACUUM predates that.

I'm mostly concerned about reopening the ability for folks to take strong
locks on catalogs without the necessary privileges, even if they are only
briefly held.  Commit a556549 fixed a real problem, so I'm nervous about
partially reverting it.  IOW my first reaction is that v1 is the right
idea, i.e., we should just skip the relation if it disappears.  I'm not
sure we even need to log it.

-- 
nathan



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: RFC: Logging plan of the running query
Next
From: Diego
Date:
Subject: [PATCH] - Re: libpq: decouple the .pgpass lookup port from the connection port