Shulou(Shulou.com)05/31 Report--

This article shows you an example analysis of Postgres-XL updates. The content is concise and easy to understand. It will definitely make your eyes shine. I hope you can gain something from the detailed introduction of this article.

October 25, 2018 2ndQuadrant released Postgres-XL 10R1 version. Postgres-XL is a massively parallel database that is based on PG Community Edition and is highly compatible with PG, supporting Business Intelligence workloads and read-write large transaction workloads.

PG-XL is completely open source. As we began to move toward full parallelism with PG Core, some of the new features of PG were added to PG-XL. Key features of this release include those found in Postgresql, such as parallel queries (PG 9.6) and declarative partitioning (PG10). In addition, PG-XL10R1 has also seen significant performance improvements with the release of new versions of PG in recent years. It mainly includes the following aspects.

PG10

Declarative table partitioning Improved query parallelism Significant general performance improvements Improved monitoring and control

PG9.6

Parallel execution of sequential scans, joins, and aggregates Avoid scanning pages unnecessarily during vacuum freeze operations Substantial performance improvements, especially in the area of scalability on multi-CPU-socket servers Full text search can now search for phrases (multiple adjacent words)

In addition, improvements include: fixing several bugs, PG-XL specific enhancements. Distributed planner code rewritten for PG code advancement.

The above is an example analysis of Postgres-XL updates. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserves, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.