Tom Lane wrote:
> lec <englim(at)pc(dot)jaring(dot)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.
I'll re-install 7.0.2 later & run the explain.
>
>
> > Are there any way to optimize this type of query?
>
> Um, have you vacuum analyzed the tables involved?
Yes.