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
