Request a Demo
Home   >   mailing lists

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

From Christoph Berg
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id aW9dAW0GiLbMs6L9@msg.df7cb.de
Whole thread Raw
In response to Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
Responses Re: Optional skipping of unchanged relations during ANALYZE?
List pgsql-hackers
Tree view 
Re: VASUKI M
> I’m considering working on an optional mode where ANALYZE would skip
> relations that have not been modified since their last analyze, based
> on existing pg_stat counters (for example, mod_since_analyze = 0).

Make sure that doesn't skip tables that were never analyzed before.

Christoph

pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: David Geier
Date:
Subject: Re: Change copyObject() to use typeof_unqual