Re: Bug in optimizer - Mailing list pgsql-bugs

Timo Nentwig wrote:

> This is very slow:
>
> SELECT urls.id FROM urls WHERE
> (
>     urls.id <> ALL (SELECT html.urlid FROM html)
> );
>
> ...while this is quite fast:
>
> SELECT urls.id FROM urls WHERE
> (
>     NOT (EXISTS (SELECT html.urlid FROM tml WHERE
>     (
>         html.urlid = urls.id
>     )))
> );

Are you using the version 7.4.x ?



Regards
Gaetano Mendola