Re: fool-toleranced optimizer - Mailing list pgsql-hackers

From Neil Conway
Subject Re: fool-toleranced optimizer
Date
Msg-id 422E3D08.4020800@samurai.com
Whole thread Raw
In response to fool-toleranced optimizer  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: fool-toleranced optimizer
List pgsql-hackers
Oleg Bartunov wrote:
> I just noticed a little optimizer problem - in second query there is
> unused 'tycho t2' table alias which gets backend buried.

It's not an "unused table alias", it is specifying the cartesian product 
of `tycho' with itself. I don't see how this is an optimizer problem: 
it's a perfectly legitimate query, albeit one that is unlikely to 
execute very quickly.

-Neil


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: fool-toleranced optimizer
Next
From: Alvaro Herrera
Date:
Subject: Re: How to cast VARCHAR to BYTEA and vice-versa?