How partition-wise joins and aggregates improve Postgres query performance
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
In E81 of “5mins of Postgres” we're talking about how partition-wise joins can improve your Postgres query performance. We also look at partitionwise-aggregates and their impact on query planning time and query execution time.
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
Partitioning as a query optimization strategy? - by Ashutosh Bapat
https://ashutoshpg.blogspot.com/2023/...
Ashutosh Bapat - PostgreSQL Person of the Week
https://postgresql.life/post/ashutosh...
Query Planning - on postgresql.org
https://www.postgresql.org/docs/15/ru...
Partition-wise joins: "divide and conquer" for joins between partitioned table - by Ashutosh Bapat
https://ashutoshpg.blogspot.com/2017/...
Allow partitionwise joins in more cases - postgresql commit
https://git.postgresql.org/gitweb/?p=...
Partitioning use cases with PostgreSQL: partitionwise aggregate - by Adrien Nayrat
https://blog.anayrat.info/en/2021/09/...
Adrien Nayrat on Twitter
/ adrien_nayrat
5mins of Postgres E18: Partition pruning, prepared statements and generic vs custom query plans
https://pganalyze.com/blog/5mins-post...
5mins of Postgres E22: Reducing AWS Aurora I/O costs with table partitioning & understanding partition pruning
https://pganalyze.com/blog/5mins-post...
Partitioning in Postgres and the risk of high partition counts
https://pganalyze.com/blog/5mins-post...