Re: vacuumdb --missing-stats-only and permission issue

On Sat, Aug 23, 2025 at 05:32:30AM -0400, Corey Huinker wrote:
> On Fri, Aug 22, 2025 at 11:20 PM Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> On Sat, Aug 23, 2025 at 12:00 PM Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote:
>>> Hm. Maybe we should just document that the option requires SELECT
>>> privileges on pg_statistic and pg_statistic_ext_data (which are restricted
>>> to superusers by default). I suspect we have relatively limited
>>> opportunities for tuning the query, and I'd like to avoid invasive changes
>>> to v18 at this point.
>>
>> Yeah, adding a note about the permissions required for --missing-stats-only,
>> leaving the query unchanged in v18, and revisiting the issue in v19 seems
>> reasonable given the limited time before the v18 release.
>
> Rather than resorting to the redundant where-clause trick that we did in
> pg_dump.

Here's a patch for the documentation update.

--
nathan