Скачать или смотреть 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...