Logo: Fujitsu and home icon
    Download trial version
    Fujitsu Logo
    ENQUIRE

      FUJITSU Enterprise Postgres is the enhanced version of PostgreSQL, for enterprises seeking a more robust, secure, and fully supported edition for business-critical applications.

      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

      Reliability and High Availability
      img-card-key-features-mirroring-controler
      Mirroring Controller
      Mirroring Controller is key in maintaining the high availability, business continuity, and integrity of your data. It continually monitors your system looking for a range of issues, and seamlessly switches to an alternate database server should an abnormality be detected.
      Read more in our blog >
      Read more in our White Paper >
      img-card-key-features-high-availability
      High Availability
      High Availability enables continuous job processing with minimum downtime when an error occurs. Synchronize data between servers, protecting important data from failures. Switches to the secondary server within a few seconds after a failure occurs on the primary server.
      Read more in PostgreSQL Insider >
      Read more in our White Paper >
       
      img-card-key-features-connection-manager
      Connection Manager
      This is a unique feature of FUJITSU Enterprise Postgres that allows application access and replication operation to be continued without being aware of the connection destination of the applications. In case of failure, Connection Manager reclaims SQL connections with the client and notifies applications of the error.
      See more details >
      Read more in the manual >
      img-card-key-features-high-speed-backup-recovery
      High-Speed Backup/Recovery
      Enables backup/recovery of clusters and selected tablespaces using any copy method specified by the user, to replace the conventional, file-level copy process and allow TB-scale operations.
      Read more in our White Paper >
      img-card-key-features-wal-duplication
      WAL duplication
      Solves PostgreSQL's single point of failure which can occur in case of disk failure because Write-Ahead Logging (WAL) is not duplicated. With FUJITSU Enterprise Postgres, WAL is duplicated in order to avoid data loss.
      See more details >

      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:

      • When a client error occurs, forces a reclaim of the SQL connection with the client
      • When a server error occurs, the application is notified as an SQL error.
      • Applications connect to the appropriate server without being aware of the server state (primary or standby)

      Because SQL is not relayed, SQL performance is less degraded compared to Pgpool-II, PgBouncer, etc.

      ×
      Enterprise-grade Security
      img-card-key-features-transparent-data-encryption
      Transparent Data Encryption
      Encrypts data at rest using Advanced Encryption Standard, a PCI DSS-compliant 256-bit encryption technology that is standard for the credit card industry. Existing applications do not need to be changed because data is automatically encrypted/decrypted.
      Learn more >
      Read more in our White Paper >
      img-card-key-features-data-masking
      Data Masking
      Policy-based data redaction on returned queries minimizes security risk by enabling user-based confidentiality, altering original data while maintaining its usability. It uses a powerful yet user-friendly policy approach that allows flexibility in the redaction of different types of data to different types of roles.
      Learn more >
      Read more in our White Paper >
      img-card-key-features-dedicated-audit-log
      Dedicated Audit Log
      Extends OSS PostgreSQL audit log, delivering in the key areas of data accountability, traceability, and the ability to audit. Compliant with all PCI DSS (Payment Card Industry Data Security Standard) requirements. Allows faster and easier analysis of audit log records.
      Learn more >
      Read more in our White Paper >
      img-card-key-features-governance-and-data-privacy
      Governance & Data Privacy
      FUJITSU Enterprise Postgres' unique security features takes PostgreSQL to the next level to protect you from data breaches and ensure you comply with data protection regulations such as GDPR.
      Read more in our eBook >
      Enhanced Performance
      In-Memory Columnar Index
      Provides almost 5x faster analytical queries for jobs with large amounts of data. Supports Hybrid Transactional Analytical Processing (HTAP) workloads to help businesses make more timely decisions.
      Read more in our blog >
      Read more in our White Paper >
      High-Speed Data Load
      This unique feature uses several parallel workers to perform data conversion, table creation, and index creation simultaneously. It makes the best use of available resources without the need to pre-configure and tune your environment.
      Read more in our blog >
      Read more in our White Paper >
      Parallel Scan
      Achieves high speed and stable operation through effective use of resources. In addition to PostgreSQL's parallel search, provides the ability to control the optimal degree of parallelism. Prevents resource contention, provides stable performance, and enables efficient scheduled aggregation and batch processing.
      See more details >
      Global Meta Cache
      Reduces overall system memory usage by caching information about system catalogs and table definition in global memory instead of client process memory. This is especially useful in environments with large databases and large number of connections.
      See more details >

      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.

      ×
      Interoperability / Application Development
      img-card-key-features-oracle-compatibility
      Oracle compatibility
      A ready-made alternative to Oracle for larger enterprise customers, with 90% compatibility attained for common applications, it also offers enhanced compatibility when migrating from Oracle systems.
      Our Migration Assessment outlines the requirements for your organization to migrate from Oracle.
      See details about Oracle compatibility >
      Read more in PostgreSQL Insider >
      Read more about Migration Assessment >
      img-card-key-features-integration-with-odbc
      Integration with ODBC, JDBC, and .NET Framework
      Applications written in a variety of programming languages can access the database.
      They provide high-performance connectivity solutions to access the data in a fast and easy way.
      Read more in our Datasheet >
      img-card-key-features-embedded-sql
      Embedded SQL in C and COBOL
      Programs written in C and COBOL can access data using embedded SQL with little to no modification.
      Read more in our White Paper >

      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
      Backed by Fujitsu
      img-card-key-features-fujitsu-services
      Fujitsu Services
      With access to some of the world’s top PostgreSQL talent, we can ensure that your system is ready for business. We can determine how well your system is performing, where efficiencies can be made moving forward, and how to minimize the risk of data breaches.
      See more details >
      Read more about our Services >
      img-card-key-features-24x7-support
      24 x 7 Support
      Put our highly skilled software support engineers on your side with Fujitsu PostgreSQL Support plan.
      Our support plans are a cost-effective way to support your open-source PostgreSQL database and deliver the high availability and fast performance that users demand.
      Read more about our Support >

      Services

      Our PostgreSQL expert offer a range of services for your organization:

      • Health Check – Identifies potential issues in your database before they become a problem, and offers practical solutions. Read more >
      • Operations Review – Helps you streamline your system using best-practice guidelines. Read more >
      • Consulting – Provides strategic advice to ensure your database system is fully meeting the needs of your organization. Read more >
      • Migration Assessment – Determines the feasibility of transferring your data to FUJITSU Enterprise Postgres. It outlines what can be migrated automatically without modification, what needs to be modified, and what resources will be required after migration. Read more >
      • Database Migration – Carries out the physical transfer of your data smoothly and seamlessly, providing all the necessary training and support. Upon completion, we provide a comprehensive report stating exactly what was in the original database, what was moved, and what is now in your new database, so all your data is accounted for throughout the process. Read more >
      ×

      Want to know more?

      Visit our Resources page to learn more about FUJITSU Enterprise Postgres and its advanced security, high availability, and improved performance capabilities.

      Thumbnail: White Paper Data Masking Thumbnail: White Paper Dedicated Audit Log Thumbnail: White Paper High Availability

       

      Go to Resources page >

      Read our Latest Blogs

      Read our most recent articles regarding all aspects of PostgreSQL and FUJITSU Enterprise Postgres.

      email: postgresql@fast.au.fujitsu.com

      All Rights Reserved. Copyright 2021 Fujitsu Australia Software Technology
      Twitter for Fujitsu Australia Software TechnologyLinkedIn for Fujitsu Australia Software Technology   ENQUIRE
      Privacy Statement