Re: vacuumdb --missing-stats-only and permission issue - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: vacuumdb --missing-stats-only and permission issue
Date
Msg-id aKkutrB4yHWSnE7j@nathan
Whole thread Raw
In response to Re: vacuumdb --missing-stats-only and permission issue  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: vacuumdb --missing-stats-only and permission issue
List pgsql-hackers
On Sat, Aug 23, 2025 at 10:59:43AM +0900, Fujii Masao wrote:
> I tested by creating many tables with make installcheck and running
> vacuumdb --missing-stats-only on the regression database.
> Without the patch, the query to find tables to analyze took about 60 ms,
> but with the patch it took 18 seconds. That seems too slow,
> so probably we'll need to tune the query?

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.

-- 
nathan



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: vacuumdb --missing-stats-only and permission issue
Next
From: Fujii Masao
Date:
Subject: Re: vacuumdb --missing-stats-only and permission issue