Rod Taylor wrote:
>
>The big problem is a very poor estimate (off by a couple orders of
>magnitude). I was hoping someone with more knowledge in fixing those
>would jump in.
>
>
>
>
ANALYZE might be producing poor stats due to :
i) many dead tuples or
ii) high proportion of dead tuples in the first few pages of the table
Does a VACUUM FULL followed by ANALYZE change the estimates (or have you
tried this already)?
(p.s. - I probably don't qualify for the 'more knowledge' bit either...)
regards
Mark