Re: sub-select in IN clause results in sequential scan

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: Anj Adu <fotographs(at)gmail(dot)com>, Angayarkanni <kangayarkanni(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: sub-select in IN clause results in sequential scan
Date: 2009-10-30 15:03:47
Message-ID: 603c8f070910300803t6b6e5effi84bbb249d91ee73c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2009/10/30 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Harris 2009-10-30 18:57:04 Re: database size growing continously
Previous Message Merlin Moncure 2009-10-30 12:43:20 Re: database size growing continously