The first thing I made was vacuum/analyze them. Then I deleted and rebuilt the
indicies but the problem remained. So I created a new table (e_catalogo2) with new
indicies, I copied all data from the old table to the new one, weirdly the problem was
solved. In my opinion there is something wrong
NMB Webmaster <[EMAIL PROTECTED]> writes:
> I have two database quite similar, one has more tables than the other.
Are both of them vacuumed/analyzed recently? The slow plan seems to be
estimating many more rows out of the e/m join than the other one.
> My Postgres version is 7.2.3. Please help
