Postgres Pro
Downloads
Home   >   mailing lists

RE: SQL 'in' vs join. - Mailing list pgsql-hackers

From Andrew Snow
Subject RE: SQL 'in' vs join.
Date
Msg-id JEEGIJPOJIGGIIHGKOKOKEJNCFAA.andrew@modulus.org
Whole thread Raw
In response to Re: SQL 'in' vs join.  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
Tree view 
> Now, given the two components, each with very low costs, it chooses to
> do a sequential scan on the table. I don't get it. 


Read the FAQ?

http://www.postgresql.org/docs/faq-english.html#4.23
"4.23) Why are my subqueries using IN so slow?")


- Andrew

pgsql-hackers by date:

Previous
From: "Andrew Snow"
Date:
Subject: RE: 8192 BLCKSZ ?]
Next
From: Sandeep Joshi
Date:
Subject: redundancy and disk i/o