Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Joining between large & small tables?
Date
Msg-id CAKFQuwZQT7w4SFZXmZsLn=iV-wYXUBXPekx2Fe-q_BUki8kqZw@mail.gmail.com
Whole thread Raw
In response to Joining between large & small tables?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
On Mon, Jul 13, 2020 at 6:40 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)?

https://www.postgresql.org/docs/12/explicit-joins.html

David J.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Joining between large & small tables?
Next
From: Aditya Toshniwal
Date:
Subject: PG12 Server on crash on creating FTS dictionary