Re: Joining between large & small tables? - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Joining between large & small tables?
Date
Msg-id 258F84EA-9EF3-43C0-B3FC-82E9154EDE54@elevated-dev.com
Whole thread Raw
In response to Joining between large & small tables?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
> On Jul 13, 2020, at 7:39 PM, Wells Oliver <wells.oliver@gmail.com> wrote:
>
> 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...

No, planner will figure out how to join based on stats, not order. (With default planner options; there are ways to
workaround that in the rare case that the planner can't figure out the best way.) 


pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Joining between large & small tables?
Next
From: "David G. Johnston"
Date:
Subject: Re: Joining between large & small tables?