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.
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.
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.
Enhanced query plan stability
The following features can control SQL statement query plans:
Optimizer hints
Locked statistics
These features are used for curbing performance deterioration caused by changes in SQL statement query plans, such as with mission-critical jobs that emphasize performance stability over improved SQL statement processing performance.
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.