Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
NOT EXISTS is taking almost double time than NOT IN .
I know IN has been optimised in 7.4 but is anything
wrong with the NOT EXISTS?
That's the expected behavior in 7.4. EXISTS in the style you are using
i
On Thu, 2003-11-13 at 12:00, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > Does the not exist query produce worse results in 7.4 than it did in
> > 7.3?
>
> EXISTS should work the same as before.
>
right. the original poster is asking if there is "something wrong with
exist" bas
Robert Treat <[EMAIL PROTECTED]> writes:
> Does the not exist query produce worse results in 7.4 than it did in
> 7.3?
EXISTS should work the same as before.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked
It is believed that the IN optimization can lead to faster IN times than
EXIST times on some queries, the extent of which is still a bit of an
unknown. (Incidentally is there an FAQ item on this that needs
updating?)
Does the not exist query produce worse results in 7.4 than it did in
7.3?
Robert
Robert Treat wrote:
It is believed that the IN optimization can lead to faster IN times than
EXIST times on some queries, the extent of which is still a bit of an
unknown. (Incidentally is there an FAQ item on this that needs
updating?)
Thanks every one for clarifying. Its really a nice
Rajesh Kumar Mallah wrote:
>
> Hi,
>
> NOT EXISTS is taking almost double time than NOT IN .
> I know IN has been optimised in 7.4 but is anything
> wrong with the NOT EXISTS?
>
> I have vaccumed , analyze and run the query many times
> still not in is faster than exists :>
Seems fine. In 7.4
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> NOT EXISTS is taking almost double time than NOT IN .
> I know IN has been optimised in 7.4 but is anything
> wrong with the NOT EXISTS?
That's the expected behavior in 7.4. EXISTS in the style you are using
it effectively forces a nestloop-with-
Hi,
NOT EXISTS is taking almost double time than NOT IN .
I know IN has been optimised in 7.4 but is anything
wrong with the NOT EXISTS?
I have vaccumed , analyze and run the query many times
still not in is faster than exists :>
Regds
Mallah.
NOT IN PLAN
tradein_clients=# explain analyze S