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 me , it is very important to
> me to tune this query.

I'd recommend an update, myself.  7.2.3 is old...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to