Re: Joining between large & small tables?

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Joining between large & small tables?
Дата
Msg-id 258F84EA-9EF3-43C0-B3FC-82E9154EDE54@elevated-dev.com
обсуждение исходный текст
Ответ на Joining between large & small tables?  (Wells Oliver <wells.oliver@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Joining between large & small tables?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Joining between large & small tables?