Re: JOIN on partitions is very slow

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: JOIN on partitions is very slow
Дата
Msg-id CAHOFxGodwHOJcn8ioEFfvh_kxZqXCJDP24PxXEkn3uhqFgQBKQ@mail.gmail.com
обсуждение исходный текст
Ответ на JOIN on partitions is very slow  (daya airody <daya.airody@gmail.com>)
Ответы Re: JOIN on partitions is very slow  (daya airody <daya.airody@gmail.com>)
Список pgsql-performance
Are you able to tweak the query or is that generated by an ORM? What version of Postgres? Which configs have you changed from default? How many partitions do you have? Is there an index on company name?

Anytime I see distinct keyword, I expect it to be a performance bottleneck and wonder about rewriting the query. Even just using group by can be much faster because of how it gets executed.

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

Предыдущее
От: daya airody
Дата:
Сообщение: JOIN on partitions is very slow
Следующее
От: Arya F
Дата:
Сообщение: Partitions to improve write/update speed for tables with indexes?