Re: correct behavior of ANALYZE ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: correct behavior of ANALYZE ...
Date
Msg-id 5730.1188405879@sss.pgh.pa.us
Whole thread Raw
In response to correct behavior of ANALYZE ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
Responses Re: correct behavior of ANALYZE ...  (Hans-Juergen Schoenig <postgres@cybertec.at>)
List pgsql-hackers
Hans-Juergen Schoenig <postgres@cybertec.at> writes:
> i came across some interesting behavior of pg_stats and i am not sure
> if this is something we should treat the way we do it.

Setting target zero means "expend no work on this column".  In my book
that includes not doing anything to any pre-existing pg_stats entry.
What you propose would defeat the ability to analyze an unchanging
column once and then make ANALYZE skip over it henceforth.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hans-Juergen Schoenig
Date:
Subject: correct behavior of ANALYZE ...
Next
From: Josh Berkus
Date:
Subject: Re: Contrib modules documentation online