Re: JOIN on partitions is very slow

Поиск
Список
Период
Сортировка
От daya airody
Тема Re: JOIN on partitions is very slow
Дата
Msg-id CAFg0VMAu71RxMsZtntPe4sQ4cGAdm=tWsVWK-rLmNiaj4W-v+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JOIN on partitions is very slow  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-performance
Дерево обсуждения


As none of the columns of the joined table are used, most probably
this should be re-written as an EXISTS condition.
Then neither GROUP BY nor DISTINCT is needed.

 
I need the columns from joined tables. To keep it simple, I didn't include them in the query. EXISTS solution won't work for me.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ekaterina Amez
Дата:
Сообщение: Re: Best way to delete big amount of records from big table
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Best way to delete big amount of records from big table