Includes enhancements to effectively implement the divide and conquer strategy, including native logical replication, declarative table partitioning, and improved query parallelism. More on what’s new here.
Transition relations are row sets that include all of the rows inserted, deleted, or modified by the current SQL statement, and are used in triggers to see a view of what the statement did.
Postgres now has a monitoring role that can be used for external monitoring tools. There’s also now an easy way to check B-tree indexes for corruption.
Postgres keeps a lot of details about its data and usage patterns under the covers. In this talk, the author of pghero looks at how Postgres could start to self index with such data.
Dashboards are great for your users, except when they’re slow. This post walks through an approach to rollup your data to provide more performant dashboards across larger data.
No comments:
Post a Comment