Re: JOIN on partitions is very slow - Mailing list pgsql-performance

From Michael Lewis
Subject Re: JOIN on partitions is very slow
Date
Msg-id CAHOFxGodwHOJcn8ioEFfvh_kxZqXCJDP24PxXEkn3uhqFgQBKQ@mail.gmail.com
Whole thread Raw
In response to JOIN on partitions is very slow  (daya airody <daya.airody@gmail.com>)
Responses Re: JOIN on partitions is very slow  (daya airody <daya.airody@gmail.com>)
List 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 by date:

Previous
From: daya airody
Date:
Subject: JOIN on partitions is very slow
Next
From: Arya F
Date:
Subject: Partitions to improve write/update speed for tables with indexes?