Tom Lane wrote: > lec <[EMAIL PROTECTED]> 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.
