| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: vacuumdb --missing-stats-only and permission issue |
| Date: | 2025-08-23 03:00:06 |
| Message-ID: | aKkutrB4yHWSnE7j@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2025-08-23 03:20:06 | Re: vacuumdb --missing-stats-only and permission issue |
| Previous Message | Fujii Masao | 2025-08-23 01:59:43 | Re: vacuumdb --missing-stats-only and permission issue |