Re: Postgresql 9.0.2 explain analyze very slow (10x), compared to actual query time

Στις Friday 14 January 2011 16:41:18 γράψατε:
> Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
>
> > and NOT EXISTS
> >    (SELECT distinct mold.id from marinerstates
>
> Does that do better if you leave out the DISTINCT keyword?  Maybe
> use * instead of the column name?

Its already really fast, it doesn't matter. Anyways just tried without the distinct
...NOT EXISTS (SELECT 1 from ...
and its the same (high) speed. The other form (NOT IN) is the problem (in the case of postgresql-9.0.2).
(in 8.3 both queries are fast)

>
> -Kevin
>



--
Achilleas Mantzios