Partitioning in Postgres and the risk of high partition counts

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

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

https://twitter.com/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/en/killing-performance-with-postgresql-partitioning/

*Hans-Jürgen Schönig on Twitter*

https://twitter.com/postgresql_007

*The Basics of Postgres Query Planning*

https://pganalyze.com/docs/explain/basics-of-postgres-query-planning

*How Migrating Our Database Eliminated Data Processing Incidents - by George Petropoulos*

https://chartmogul.com/blog/how-migrating-our-database-eliminated-data-processing-incidents/

*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-postgres-15-logical-replication-replica-identity

*5mins of Postgres E37: New in Postgres 15: Logical replication column filters & database-wide ICU collations*

https://pganalyze.com/blog/5mins-postgres-15-logical-replication-filters-database-wide-icu-collations