Ryan Booz: Thoughts on PostgreSQL Partitioning and Sharding
For this month’s PGSQL Phriday #011, Tomasz asked us to think about PostgreSQL partitioning vs. sharding. This is a topic near and dear to me and I’m excited to think about it some this month. For 20+ years of database and application development, time-series data has always been at the heart of the products I ... Read more
本文讨论了PostgreSQL的分区和分片，介绍了使用原生分区和扩展工具创建分区表的方法，并讨论了分区的优势和注意事项。对于需要分片的情况，建议使用Citus或Azure CosmosDB for PostgreSQL。作者鼓励早期应用程序开始进行分区，并建议与已经进行过分区的人交流，以了解他们的经验。
