Re: Inconsistency in vacuum behavior - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: Inconsistency in vacuum behavior
Date
Msg-id 20230119014915.GA13860@telsasoft.com
Whole thread Raw
In response to Re: Inconsistency in vacuum behavior  (Nikita Malakhov <hukutoc@gmail.com>)
Responses Re: Inconsistency in vacuum behavior
Re: Inconsistency in vacuum behavior
List pgsql-hackers
On Mon, Jan 16, 2023 at 08:12:18PM +0300, Nikita Malakhov wrote:
> Hi,
> 
> Currently there is no error in this case, so additional thrown error would
> require a new test.
> Besides, throwing an error here does not make sense - it is just a check
> for a vacuum
> permission, I think the right way is to just skip a relation that is not
> suitable for vacuum.
> Any thoughts or objections?

Could you check if this is consistent between the behavior of VACUUM
FULL and CLUSTER ?  See also Nathan's patches.

-- 
Justin



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Time delayed LR (WAS Re: logical replication restrictions)
Next
From: Peter Geoghegan
Date:
Subject: Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation