Re: sub-select in IN clause results in sequential scan
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: Anj Adu <
fotographs@xxxxxxxxx
>
Subject
: Re: sub-select in IN clause results in sequential scan
From
: Grzegorz Jaśkiewicz <
gryzman@xxxxxxxxx
>
Date
: Fri, 30 Oct 2009 12:35:18 +0000
Cc
: Robert Haas <
robertmhaas@xxxxxxxxx
>, Angayarkanni <
kangayarkanni@xxxxxxxxx
>,
pgsql-performance@xxxxxxxxxxxxxx
In-reply-to
: <
f2fd819a0910290840t79a1d742sb1ac9fb2b12f234b@xxxxxxxxxxxxxx
>
References
: <
f2fd819a0910281113k1d122905h4118f4719a24cce7@xxxxxxxxxxxxxx
> <
2f4958ff0910290254j567c46ffkcdf3f83b78a521f6@xxxxxxxxxxxxxx
> <
2a77004c0910290332x6cb5de43l284fb8060083a414@xxxxxxxxxxxxxx
> <
f2fd819a0910290710i324b153fxeb0b01ceb7831083@xxxxxxxxxxxxxx
> <
603c8f070910290835h10930c9dkb3e4677aeacd715b@xxxxxxxxxxxxxx
> <
f2fd819a0910290840t79a1d742sb1ac9fb2b12f234b@xxxxxxxxxxxxxx
>
for explains, use
http://explain.depesz.com/
besides, why are you using left join ?
equivlent of IN () is just JOIN, not LEFT JOIN.
And please, format your query so it readable without twisting eyeballs before sending.
Follow-Ups
:
Re: sub-select in IN clause results in sequential scan
From:
Robert Haas
References
:
sub-select in IN clause results in sequential scan
From:
Anj Adu
Re: sub-select in IN clause results in sequential scan
From:
Grzegorz Jaśkiewicz
Re: sub-select in IN clause results in sequential scan
From:
Angayarkanni
Re: sub-select in IN clause results in sequential scan
From:
Anj Adu
Re: sub-select in IN clause results in sequential scan
From:
Robert Haas
Re: sub-select in IN clause results in sequential scan
From:
Anj Adu
Prev by Date:
Re: Modeling a table with arbitrary columns
Next by Date:
Re: database size growing continously
Previous by thread:
Re: sub-select in IN clause results in sequential scan
Next by thread:
Re: sub-select in IN clause results in sequential scan
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
