lec <englim@pc.jaring.my> writes:
> Under 7.0.2, there are no Hash Join or Hash
So, then, what *does* it do? Without the explain for 7.0.2 it's
impossible to tell what's happening.
> Are there any way to optimize this type of query?
Um, have you vacuum analyzed the tables involved?
regards, tom lane