Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds
Дата
Msg-id aZSm77WEh8pxQYtf@nathan
обсуждение исходный текст
Ответ на Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds  (VASUKI M <vasukianand0119@gmail.com>)
Ответы Re: Proposal: ANALYZE (MODIFIED_STATS) using autoanalyze thresholds
Список pgsql-hackers
On Tue, Feb 17, 2026 at 04:12:58PM +0530, VASUKI M wrote:
> I would greatly appreciate thoughts before working on a prototype patch.

At the risk of substantially expanding the scope of these patches, I wonder
if a better long-term approach would be to first centralize the
autovacuum/autoanalyze prioritization code and share it via a system view
that vacuumdb could use in place of the giant query for
--missing-stats-only.  That would also give users visibility into
auto{vacuum,analyze}'s decisions.  TBH I'm not totally sold on the idea of
giving ANALYZE more options for this stuff, if for no other reason than I'm
not really following the concrete use-cases, but I wouldn't say I'm
mortally opposed to it.

-- 
nathan



В списке pgsql-hackers по дате отправления: