> 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