join vs exists - Mailing list pgsql-performance

From AI Rumman
Subject join vs exists
Date
Msg-id AANLkTin4erNwsmyy052lb-ZNbvqPOLWMgS5V66q6Fd9T@mail.gmail.com
Whole thread Raw
List pgsql-performance
Which one is good - join between table or using exists in where condition?

Query 1;

Select a.*
from a
where exists
(
select 1 from b inner join c on b.id1 = c.id where a.id = b.id)

Query 2:
select a.*
from a
inner join
(select b.id from b inner join c on b.id1 = c.id) as q
on a.id = q.id

Any suggestion please.

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: B-Heaps
Next
From: venu madhav
Date:
Subject: Obtaining the exact size of the database.