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

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(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 12:35:18
Message-ID: 2f4958ff0910300535t1b555ee4m689b282d92307783@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-10-30 12:43:20 Re: database size growing continously
Previous Message Віталій Тимчишин 2009-10-30 10:18:26 Re: Modeling a table with arbitrary columns