Postgres Pro
Downloads
Home   >   mailing lists

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

From Grzegorz Jaśkiewicz
Subject Re: sub-select in IN clause results in sequential scan
Date
Msg-id 2f4958ff0910300535t1b555ee4m689b282d92307783@mail.gmail.com
Whole thread Raw
In response to Re: sub-select in IN clause results in sequential scan  (Anj Adu <fotographs@gmail.com>)
Responses Re: sub-select in IN clause results in sequential scan
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Віталій Тимчишин
Date:
Subject: Re: Modeling a table with arbitrary columns
Next
From: Merlin Moncure
Date:
Subject: Re: database size growing continously