Re: sub-select in IN clause results in sequential scan - Mailing list pgsql-performance

From Robert Haas
Subject Re: sub-select in IN clause results in sequential scan
Date
Msg-id 603c8f070910300803t6b6e5effi84bbb249d91ee73c@mail.gmail.com
Whole thread Raw
In response to Re: sub-select in IN clause results in sequential scan  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
2009/10/30 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
> 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.

I prefer to have things posted to the list rather than some pastebin
that may go away, but I agree that the email was unreadable as posted.
 Maybe an attachment?

...Robert

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: database size growing continously
Next
From: Jeremy Harris
Date:
Subject: Re: database size growing continously