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.
The following is the query/explai
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
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.
> Are there any way to optimize this type of query?
Um, have you vacuum analyzed the tables involved?
After upgrading to 7.0.2, one of my queries ran much slower on 7.0.2:
7.0.2 took 17 minutes (After 'optimization' by SET ENABLE_SEQSCAN=OFF)
6.5.3 took 2 minutes
The following is the query/explain under 6.5.3:
super=> select version();
version
