Fujitsu Enterprise Postgres maintains the operating methods, interfaces for application development and SQL compatibility of PostgreSQL, while providing expanded features for enhanced reliability and operability.
This chapter explains the functionality extended by Fujitsu Enterprise Postgres.
Refer to "Appendix A List of Features" for feature differences between editions.
Additionally, Fujitsu Enterprise Postgres supports various open source software (OSS). Refer to "Appendix B OSS Supported by Fujitsu Enterprise Postgres" for information on OSS supported by Fujitsu Enterprise Postgres.
Fujitsu Enterprise Postgres has the following features:
Flexible database recovery
Not only does Fujitsu Enterprise Postgres recover data to its most recent form when a failure occurs, which is essential for databases, but it can also recover to any point in time. Additionally, backup/recovery can be performed using any copy technology.
Simple GUI-based installation and operation management
Fujitsu Enterprise Postgres uses GUI to simplify cumbersome database operations, and allows databases to be used intuitively.
High reliability by using database multiplexing
Database multiplexing protects important data and enables highly reliable database operation.
High reliability by using the failover feature integrated with the cluster software
Fujitsu Enterprise Postgres links with PRIMECLUSTER, thereby allowing highly reliable systems to be achieved by using failover.
Seamless migration from Oracle databases
Fujitsu Enterprise Postgres provides a compatibility feature with Oracle databases that localizes the correction of existing applications and allows easy migration to Fujitsu Enterprise Postgres.
Storage data protection using transparent data encryption
Information can be protected from data theft by encrypting data to be stored in the database.
Also, you to choose an external key management system as the storage location for your encryption keys.
Policy-based login security
By defining login security policies as profiles and assigning profiles to database users, you can achieve login management and password operation according to the security policy.
Data masking for improved security
The data masking feature changes the returned data for queries from applications, to prevent exposing actual data. This improves security for handling confidential data such as personal information.
Audit logs for improved security
Audit logs can be used to counter security threats such as unauthorized access and misuse of privileges for the database.
Management of access control by confidentiality management
Confidentiality management feature supports the design/management of access privileges and optimizes access control, thereby enhancing security.
Enhanced query plan stability
Allows you to control query planning for SQL statements. This feature is used to prevent performance degradation due to changes in the query plan of SQL statements, such as in core business operations where stabilizing performance is more important than improving the processing performance of SQL statements.
Increased aggregation performance using the in-memory feature
The following features help speed up scans even when aggregating many rows.
Vertical Clustered Index (VCI)
In-memory data
High-speed data load
Data from files can be loaded at high speed into Fujitsu Enterprise Postgres tables using the high-speed data load feature.
High availability by using Connection Manager
With the Connection Manager features, replication operation can be continued without being aware of the connection destination of the applications.
Memory usage reduction using Global Meta Cache
The Global Meta Cache feature loads some of meta cahe information in shared memory. This reduces overall system memory usage.
Memory usage reduction using Local Meta Cache Limit
Reduce memory consumption by limiting the metacache that is kept in local memory.
