AW: VERY strange query plan (LONG) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: VERY strange query plan (LONG)
Date
Msg-id 11C1E6749A55D411A9670001FA687963368046@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers

> very strange numbers and no indices used) (I did run vacuume analyze)
> 
> explain
> select
>         txt.tid
> from
>         txt, txt_lexem1 tl1_0, txt_lexem11 tl11_0
> where
> tl1_0.lid =17700
> OR
> tl11_0.lid =172751
> ;
> NOTICE:  QUERY PLAN:

Did you forget to join the tids together, and the did=0 restrictions ?

Your statement looks very strange (cartesian product), and has nothing in 
common with the subselect statements you quoted.

Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: VERY strange query plan (LONG)
Next
From: Kaare Rasmussen
Date:
Subject: Re: Arrays and foreign keys