public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ilia Evdokimov <[email protected]>
To: VASUKI M <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Cc: Christoph Berg <[email protected]>
Cc: Robert Haas <[email protected]>
Cc: David Rowley <[email protected]>
Cc: Robert Treat <[email protected]>
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
Date: Wed, 21 Jan 2026 10:47:33 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAE2r8H7jVmsLaWi19ZuxmwR-8UjtN6Ejv7YmtDrPinCYtE8cUA@mail.gmail.com>
References: <CAE2r8H7+eACA+QxisuPY1jveA=YLuH7CE8F3TedmZfsKdYxOeA@mail.gmail.com>
<CABV9wwNYQ6V4-kKzPbJ0fGtgrq_+0z1kLiWQ8yqqDL-hEmphdQ@mail.gmail.com>
<CAE2r8H7jVmsLaWi19ZuxmwR-8UjtN6Ejv7YmtDrPinCYtE8cUA@mail.gmail.com>
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/
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Optional skipping of unchanged relations during ANALYZE?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox