Ray Ontko <rayo(at)ontko(dot)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
In response to
pgsql-admin by date
|Next:||From: Ray Ontko||Date: 2002-06-28 19:43:11|
|Subject: Re: Are statistics gathered on function indexes?|
|Previous:||From: Tom Lane||Date: 2002-06-28 18:46:32|
|Subject: Re: Are statistics gathered on function indexes? |