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.
5 key capabilities for today's enterprise workloads
Compare the features of the latest versions here
Mirroring Controller
This is a feature designed to enhance data availability and reliability through synchronous replication. It ensures data is consistently mirrored between the primary and standby databases, maintaining high availability and disaster recovery capabilities. This ensures minimal data loss in the event of a primary server failure while guaranteeing data consistency between servers
WAL duplication
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.
×Connection Manager
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.
×Policy-based login security
Login security policies simplify management and improve database security.
×Confidentiality management
Fujitsu Enterprise Postgres simplifies the design of security controls on database objects by implementing concepts such as confidentiality object, confidentiality role, and confidentiality matrix.
×Cloud-based key management
Allows management of Transparent Data Encryption keys using cloud key management services, increasing data security, reducing the risk of data leaks, and improving governance by diving the roles of DBA and Master Encryption Key Admninistrator.
×Policy-based password management
Restricts access to accounts at the database layer instead of application layer by setting password restrictions and establishing rules for password complexity, preventing unauthorized logins and improving database security.
×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.
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.
×Oracle compatibility
The features below have been extended in order to enhance compatibility with Oracle: ×
Category | Item | |
SQL | Queries | Outer join operator (+) |
DUAL table | ||
Functions | DECODE | |
SUBSTR | ||
NVL | ||
Package | UTL_FILE | |
DBMS_OUTPUT | ||
DBMS_SQL | ||
DBMS_ALERT | ||
DBMS_ASSERT | ||
DBMS_PIPE | ||
DBMS_RANDOM | ||
DBMS_UTILITY | ||
PLUNIT | ||
PLVCHR | ||
PLVDATE | ||
PLVLEX | ||
PLVSTR | ||
PLVSUBST |
Services
Our PostgreSQL expert offer a range of professional services for your organization:
Want to know more?
Visit our Resource Center page to learn more about Fujitsu Enterprise Postgres and its advanced security, high availability, and improved performance capabilities.
Read our most recent articles regarding all aspects of PostgreSQL and Fujitsu Enterprise Postgres.