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...)



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to