Joining between large & small tables?

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Joining between large & small tables?
Date: 2020-07-14 01:39:39
Message-ID: CAOC+FBUnp60kdRhQFe9JokapXT-qN=L6Zg_0Nv0fk35vi7_YbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Given a large large large table A and a small small temp table B is there
any benefit to doing SELECT * FROM a JOIN b USING (somecol) vs SELECT *
FROM b JOIN a USING (somecol)?

When you just want the intersection...

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2020-07-14 01:42:59 Re: Joining between large & small tables?
Previous Message Marlene Villanueva 2020-07-13 15:55:51