Partitioning in Postgres and the risk of high partition counts
pganalyze pganalyze
3.68K subscribers
1,605 views
0

 Published On Jul 27, 2023

Find the article on our blog here: https://pganalyze.com/blog/5mins-post...

In E78 of “5mins of Postgres”, we're going to talk about partitioning in Postgres and how it can either kill performance or make it a lot better.

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:

Killing performance with PostgreSQL partitioning - by Hans-Jürgen Schönig
https://www.cybertec-postgresql.com/e...

Hans-Jürgen Schönig on Twitter
  / postgresql_007  

The Basics of Postgres Query Planning
https://pganalyze.com/docs/explain/ba...

How Migrating Our Database Eliminated Data Processing Incidents - by George Petropoulos
https://chartmogul.com/blog/how-migra...

George Petropoulos on GitHub
https://github.com/geopet85

AWS Database Migration Service
https://aws.amazon.com/dms/

5mins of Postgres E43: Logical replication in Postgres 15 & why the REPLICA IDENTITY matters
https://pganalyze.com/blog/5mins-post...

5mins of Postgres E37: New in Postgres 15: Logical replication column filters & database-wide ICU collations
https://pganalyze.com/blog/5mins-post...

show more

Share/Embed