Hans-Juergen Schoenig <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq