Here are the key features of FUJITSU Enterprise Postgres, the open source based database system designed to deliver the Quality of Service (QoS) that enterprises demand of their databases in the digital world, while supporting the openness and extensibility expected of open source platforms, all at a lower cost than traditional enterprise databases.
It is an enhanced distribution of PostgreSQL, the open source database platform, with improvements to support enterprise-level workloads and provide improved Deployment and Management, Availability, Performance, Data Governance, and Security, above and beyond the standard community edition of PostgreSQL.
With WAL duplication, if a storage failure occurs and the primary logs become corrupted or inaccessible, the secondary logs can be activated to recover the database transactions and get the system up and running faster, with no data loss.
The Connection Manager allows client and server processes to monitor each other's heartbeat, quickly detecting network issues.
The Connection Manager provides the following capabilities:
Because SQL is not relayed, SQL performance is less degraded compared to Pgpool-II, PgBouncer, etc.
Parallel Scan in FUJITSU Enteprise Postgres
OSS PostgreSQL performs operations at the specified degree of parallelism without regard to CPU utilization. Depending on the parameter setting value, performance degradation may occur due to CPU contention.
FUJITSU Enterprise Postgres achieves stable performance by dynamically adjusting the degree of parallelism according to CPU utilization - a lower degree of parallelism is used when CPU utilization is high, and higher degree when CPU utilization drops.
Global Meta Cache
The meta cache stores information about system catalogs and table definitions so that processes can access the meta cache to process queries instead of searching for the required tuples in the system catalog each time.
Usage of the meta cache increases in proportion to the number of tables and columns accessed, and as the number of connections increases, so does the amount of memory used if that information is stored on per-process memory.
The Global Meta Cache moves that information from per-process memory to shared memory, thus reducing overall system memory usage while maintaining query performance improvement provided by caching metadata.
The features below have been extended in order to enhance compatibility with Oracle: ×
|SQL||Queries||Outer join operator (+)|
Our PostgreSQL expert offer a range of services for your organization:
Read our most recent articles regarding all aspects of PostgreSQL and FUJITSU Enterprise Postgres.