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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
