Working with Large Databases

• CFS (Compressed File System)Built-in data compression that operates at the database page level. Saves storage space without performance loss and reduces disk load when working with cold data, features automatic parameter tuning.
• ILM (Information Lifecycle Management)Automates the movement of rarely accessed or modified tables and partitions into archive storage, compresses them, and lowers storage costs while preserving performance of active data.
• Shardman — Horizontal ScalingEnables database scaling across multiple nodes. Automatically distributes large volumes of data and queries across the cluster while maintaining availability and consistency.
• LOBs (large objects) EnhancementsRemoves typical limitations associated with large objects. Supports very large files, advanced access operations, and full control over storage and processing.

Performance

• Automatic Configuration TuningSelects optimal database parameters based on available memory, number of CPU cores, and workload type.
• Resource PrioritizationDynamically allocates CPU time and I/O resources to user groups according to predefined priorities when computing resources are scarce.

Reliability and Scalability

• BiHA — High-Availability Cluster Management
  Does not require third-party tools. Ensures continuous database operation by automatically switching to a standby node in case of failures. Simplifies cluster administration and reduces downtime risk.
• Proxima — Proxy Server with Connection PoolingActs as a connection pool and proxies sessions to a new master or to less loaded nodes for read operations. Reduces latency, optimizes routing, and simplifies cluster scaling. Also provides fast key-based access for applications via the Redis protocol.
• Shardman / Citus — Horizontal ScalingA distributed database management system that provides horizontal scaling to accommodate data growth. Distributes the load across nodes while ensuring fault tolerance and data consistency.

Manageability

• PPEM — Graphical Management PlatformProvides a single-pane-of-glass interface for database administration. Displays key processes and enables fast response to system changes. Allows users to create and manage databases, monitor activity, configure settings, and track performance trends.
• AQE / AQO EnterpriseAutomatically adjusts query execution plans based on real statistics. Continuously learns and improves query performance, with efficiency increasing as more workload data is collected.
• MultiplanEnables users to save and reuse specific query execution plans. Used to optimize performance and improve query management.

Streamlined Migration

• Oracle-Style PackagesFacilitate migration from Oracle to Postgres Pro by allowing code to be ported with minimal changes, thanks to support for familiar package structures.
• Additional System PackagesProvide extended functionality and enhancements beyond Standard PostgreSQL.
• Collections SupportSupports Oracle-style collections, including varray, nested table, and associative array.
• ora2pgpro UtilityAutomates database and application code migration from Oracle to Postgres Pro. Scans database structure, generates SQL scripts, and helps estimate migration complexity.

Is Postgres Pro Enterprise suitable for my company’s needs?
If you run a high-load infrastructure requiring high availability and flexibility, Postgres Pro Enterprise is the right choice. We can help audit your workloads and recommend the optimal configuration.

How does Postgres Pro Enterprise differ from Postgres Pro Standard?
The Enterprise edition includes the BiHA high-availability cluster, CFS data compression, ILM for information lifecycle management, the Proxima proxy server, and the PPEM management console. It also provides extended support and enhanced security features.

Are there tools for detecting excessive access rights?
Yes. Postgres Pro Enterprise supports privilege analysis, user activity auditing, and access control, including the detection of redundant privileges.

What are the licensing options?
Both perpetual and annual licenses are available with different support levels. Free editions are offered for educational purposes. Learn more.

Can I test the solution?
Yes, you can test Postgres Pro Enterprise free of charge. Simply request a consultation on our website.

Can I migrate to Postgres Pro Enterprise from another database?
Yes. Migration from other databases is supported. Built-in tools help transfer data and code, including utilities for Oracle and other systems. Learn more.

Is extended technical support available?
Yes, 24/7 support is available from a team of PostgreSQL Major Contributors. It includes consulting, SLAs, and assistance at the core level. Learn more.

How often is Postgres Pro Enterprise updated?
Updates are released faster than any other solution on the market — within two weeks of each PostgreSQL release. Additional enhancements and bug fixes are also included.

How does it differ from vanilla PostgreSQL?
Postgres Pro Enterprise is an enterprise-grade extension of PostgreSQL. It includes BiHA clustering, CFS compression, advanced security, and direct support from core developers. It is fully compatible with community PostgreSQL, but designed for more demanding business workloads.

Request a Demo