How partition-wise joins and aggregates improve Postgres query performance

Find the article on our blog here: pganalyze.com/...
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:
pganalyze.com
pganalyze.com/...
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/...
📑 What we have discussed in this episode of 5mins of Postgres:
Partitioning as a query optimization strategy? - by Ashutosh Bapat
ashutoshpg.blo...
Ashutosh Bapat - PostgreSQL Person of the Week
postgresql.lif...
Query Planning - on postgresql.org
www.postgresql...
Partition-wise joins: "divide and conquer" for joins between partitioned table - by Ashutosh Bapat
ashutoshpg.blo...
Allow partitionwise joins in more cases - postgresql commit
git.postgresql...
Partitioning use cases with PostgreSQL: partitionwise aggregate - by Adrien Nayrat
blog.anayrat.i...
Adrien Nayrat on Twitter
/ adrien_nayrat
5mins of Postgres E18: Partition pruning, prepared statements and generic vs custom query plans
pganalyze.com/...
5mins of Postgres E22: Reducing AWS Aurora I/O costs with table partitioning & understanding partition pruning
pganalyze.com/...
Partitioning in Postgres and the risk of high partition counts
pganalyze.com/...