Re: Are statistics gathered on function indexes?

Ray Ontko <rayo@ontko.com> writes:
>> It appears that "vacuum analyze verbose actor" causes the problem.
>> It appears that I have to say "vacuum analyze actor" in order to
>> clear out the ill effects of having said "vacuum analyze verbose actor".

I really, really doubt that "verbose" has anything to do with it.

What do you get from
    select * from pg_stats where tablename = 'actor' and
        attname = 'actor_full_name';

Do the results change significantly between the "good" state and the
"bad" state?  How about the results of
    select relpages, reltuples from pg_class where relname = 'actor';

It would seem that one or another of these statistical items is getting
set weirdly by something you are doing, but I have no idea what exactly
is going wrong...

            regards, tom lane