|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-partitioning-before-2gb-frontier/
课程评论：没有评论
课程名称：PostgreSQL 分区：2GB 界限之前 概述：分区是 PostgreSQL 的一个重要特性，不仅可以提高应用程序的性能，还能简化软件开发者或数据库管理员的工作。本课程的目的在于理解“分区在表大小超过 2GB 时才有意义”这一普遍说法的正确性。此外，网上有许多关于分区能够提高可维护性和可用性的论述，实际上这些意味着什么？从可维护性和可用性角度，分区能具体改善哪些方面？在我的实践中，开发者常常在判断何时引入分区时遇到困惑。因此，我希望这个课程能够帮助你在项目中识别出分区的必要性。 在本课程中，我们将探讨如何分析查询性能，以了解分区带来的潜在好处。我将展示分区在可用性和可维护性方面的具体优势。同时，我们还将讨论不同 PostgreSQL 版本中的分区方法和不同类型的分区。课程包含实际操作课程，其中你将找到有关性能分析和分区实施的逐步指导。
The partitioning is one of the important PostgreSQL features which may help you not only improve the performance of your application but also make your life easier as a software developer or database administrator. One of the reason why I created this course is to understand how right the popular statement that the partitioning make sense for tables which size is greater than 2GB. Also in the Internet it's possible to find many statements saying that the partitioning improves the maintainability and availability but what it means in practice. What exactly from the maintainability and availability point of view can be improved by using the partitioning. Another reason is in my practice it happened pretty often that the developers were experiencing issues with understanding when the partitioning has to be introduced. So I hope this course will help you to recognize the need in the partitioning in your projects.In this course we will look how we can analyze the query performance to understand we will get the benefits from the partitioning. Also I will show what particular advantages the partition may provide from availability and maintainability point of view. Also we will discuss different approaches for the partitioning among PostgreSQL versions and different types of the partitioning.There are practical lessons where you find the step by step instructions for the performance analysis and partitioning implementation.
