Re: Optional skipping of unchanged relations during ANALYZE?

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: VASUKI M <vasukianand0119(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Christoph Berg <myon(at)debian(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Robert Treat <rob(at)xzilla(dot)net>
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
Date: 2026-01-21 07:47:33
Message-ID: c57f96fc-e3de-4690-a4c7-bda6af16aa58@tantorlabs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Another concern with skipping ANALYZE on unchanged tables is extended
statistics.

If CREATE/ALTER STATISTICS is executed, it would still be desirable for
ANALYZE to collect the newly statistics and extended ones, even if the
table data itself has not changed.

What do you think about this?

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2026-01-21 07:50:03 Re: [PATCH] Reserve protocol 3.1 explicitly in pqcomm.h
Previous Message Fujii Masao 2026-01-21 07:38:58 Re: file_fdw: Support multi-line HEADER option.