Re: Optional skipping of unchanged relations during ANALYZE? - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id CAA5RZ0s0y+tEQHiV4VWp+yopdX9hwyuS8GopHsP9YmK0peLFOA@mail.gmail.com
Whole thread Raw
In response to Re: Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
Responses Re: Optional skipping of unchanged relations during ANALYZE?
List pgsql-hackers
> The idea of introducing explicit options such as ANALYZE (MISSING_STATS)
> and ANALYZE (MODIFIED_STATS) feels like a much cleaner direction.
> In particular, starting with MISSING_STATS as a SQL-level equivalent of
> vacuumdb --missing-stats-only seems like a well-scoped and low-risk
> first step.

> I’m happy to pivot in this direction and focus first on a clear,
> well-defined MISSING_STATS option for ANALYZE, and then revisit
> MODIFIED_STATS (possibly reusing autoanalyze-style thresholds) as a
> follow-up, once there is agreement on the semantics.

I agree with this.

Thanks!

Sami Imseih
Amazon Web Services (AWS)



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.