EDB VS Postgres Pro

EDB Postgres Pro 16

Postgres Pro
Function Name Enterprise Note
EDB Enterprise
(Certified) /
Enterprise 1C

Cleaning RAM and disk memory (cleaning

files in external memory before deleting,
clearing row versions (page cleaning) before
Yes Yes
deleting, clearing RAM before freeing,
clearing write-ahead log before deleting or
overwriting)
Built-in integrity monitoring of executable
files, configuration files and system catalog Yes Yes
tables
High Availability
Built-in load balancer No Yes
Built-in High Availbility Cluster (BiHA) No Yes
Master with an arbitrary number of replicas Yes Yes
Allows logging transactions regardless of the outcome of the parent
Autonomous Transactions Yes Yes
transaction. Used when implementing a guaranteed operations audit.
Support for moving tables. Allows you to perform resource-intensive data
Movable tables pg_transfer No Yes processing on auxiliary servers and quickly transfer processed data to the
main server.
Allows you to schedule and control jobs, as well as manage their execution
Task Manager pgpro_scheduler Yes Yes
in a Postgres Pro database
Allows consistent reading of data on a slave server when using
WAITLSN command waitlsn No Yes
asynchronous replication.
Allows you to reduce the amount of disk space occupied by frequently
Table Reorganization Utility pg_repack No Yes
updated tables.
Warm standby Yes Yes
Hot standby Yes Yes
Non-disruptive update Yes Yes
Rebuilding indexes without locking a table Online index rebuild Yes Yes
Changing table structure without locking Online table redefinition Yes Yes All versions of Postgres support transactional DDL
Multiple backup copies Duplexed backup sets Yes Yes In Postgres it is implemented using the operational system disk subsystem
Block change tracking
Tracking block changes for incremental
for fast incremental Yes Yes
copies
backup
Backup compression in acordance with Unused block
No Yes
internal organization compression in backups

Block-level media
Recovering individual blocks No Yes
recovery
Automatic block recovery Automatic Block Repair No Yes
Parallel backup and
Parallel backup and recovery Yes Yes
recovery
Point in time recovery Point-in-time recovery Yes Yes
Recovering a tablespace to a a specific point Tablespace point-in-time
No No Table spaces cannot be restored separately
in time recovery
Trial recovery Trial recovery No Yes
Retrospective functions Flashback No No In Postgres, it is implemented by a replica with a lag of applying changes
Online indexing /
Instant indexes rebuilding Parallel index Yes Yes
build/scans
Active-Active Yes Yes Multimaster
3 types incremental backup Yes
backup in S3 Object storage Yes
Integration with External backup systems Yes
Instant data schema change Online schema change Yes Yes
Full and Incremental backup merge Yes
Parallel backup/resore Yes
RAC (like in Oracle) No No
Scalability and performance
Automatic Workload
Automatic load control Yes Yes
Management
Allows building highly loaded industrial-level systems with a large number of
64-bit transaction IDs No Yes
transactions
"Lazy" placement of temporary tables on Allows you to reduce the load on the I/O subsystem when temporary tables
No Yes
disk are actively used.
Using machine learning to optimize queries based on the cost of their
Query optimization (AQO module) AQO No Yes execution. Better optimizes complex queries and minimizes execution time of
complex queries.
Query replaning Replan No Yes
Quality of Service
Service Quality Management No No
Management
Cost optimizer based on disk operations and
Yes Yes
CPU time analysis
Query results cache on the server Query Results Cache Yes Yes Prepare Statements
Query result cache in a procedural language No No

Application-level database cache No No

Buffer cache in flash memory No No
Optimized partitioning mechanism, as well as functions for creating and
managing partitions. Allows you to effectively manage large volumes of data
Sectioning Yes Yes
using a flexible approach depending on their characteristics. In Postgres Pro -
interval and Ref partitioning
OLAP Yes Yes
R & SQL Yes Yes PL/R, RPostgreSQL
Data Mining No No
Advanced data compression capabilities No Yes
Basic Table
Table compression No Yes
Compression
Bitmapped index,
bitmapped join index,
Bitmap-based indexes Yes No The bitmap is built at query time based on any index type
and bitmap plan
conversions
Parallel Query Execution Parallel query/DML Yes Yes
Parallel statistics
Parallel statistics gathering Yes Yes
gathering
Parallel index
Parallel index build/scans Yes Yes
build/scans
Parallel Data Pump
Parallel Data Pump Export/Import Yes Yes
Export/Import
In-Memory Parallel
In-Memory Parallel Execution No No
Execution
Parallel Statement
Parallel Statement Queuing No No
Queuing

Broadcasting Transactions from the Log Xstream Yes Yes

Parallel capture and

Parallel capture of transactions from the log No No
apply via Xstream
Transportable
Transportable tablespaces tablespaces, including No No
cross-platform
Transportable tables No Yes
Summary management -
Rewriting requests from materialized
Materialized View Query No No
representations
Rewrite
 Asynchronous Change
Asynchronous change data capture No No
Data Capture
Covering Indexes Yes Yes
Accelerating two-phase commit No Yes
Pagenispect extension pagenispect Yes Yes
String comparison pg_trgm Yes Yes Provides fuzzy string comparison, supports substring search
Allows you to export table statistics during unloading and restore them
Tables export dump_stat No Yes instead of performing VACUUM ANALYZE after restoring the database or
updating the server
Full-text search hunspell-dict Yes Yes Includes a number of hunspell dictionaries for full text search
Searching phrases in full-text search Yes Yes
Shared ispell dictionary shared-ispell No Yes Ispell shared dictionary is a dictionary located in a shared memory segment
Adds support for scheduler hints that allow you to disable or enable certain
Scheduler hints plantuner Yes Yes
indexes when executing a query - scheduler hints
Columnar storage in memory vops Yes Yes
Optimizing access to tables in memory In-memory OLTP No Yes
Multiple instances on one server Multi-instance support Yes Yes
Partitioned Table
Parallel work with partitioned tables Yes Yes
Parallelism
Large memory pages allocation Large Page Allocation Yes Yes
OS mechanisms are used in order not to complicate existing DBMS
Buffer pool extension on SSD Buffer Pool Extension Yes Yes
mechanisms
Baselines, SQL Plan freeze Yes
Delayed log flush to disk Delayed durability Yes Yes Asynchronous wal writer mode
Table&Index compression Yes
Optimization for multicore systems Yes
Global indexes In development
Star shema optimization No
Sharding Yes Shardman and citus
Pluggable Toasts No Yes
Drop BLOB limitations No Yes
Security
Data encryption and masking Yes Yes In PG - dynamic and static masking

Virtual private database Virtual Private Database Yes Yes

Detailed audit Fine-grained auditing Yes Yes pgaudit

Additional protection options Database Vault No Yes
Secure External
External password store Yes Yes
Password Store
Row-level protection Row-level security Yes Yes
User-defined roles User-defined roles Yes Yes
Superuser izolation Yes
TDE Yes in version 17
Code wrap Yes No
SQL Firewall Yes No
Development platform
R Integration R integration Yes Yes PL/R, RPostgreSQL
Active Directory
Active Directory Integration Yes Yes
integration
Native .NET Data
.NET Data Provider Yes Yes
Provider - ODP.NET

.NET Stored Procedures .NET Stored Procedures Yes No

Stored procedures in Perl, Python, Tcl,

Yes Yes
JavaScript
Integration with external non-relational data PolyBase Yes Yes FWD
JSON support JSON Yes Yes
Query language for the jsonb data type, introduced in PostgreSQL version
JSONB support (jsquery module) jsquery Yes Yes
9.4
Query store Query Store Yes Yes Implemented by pg_stat_statements
XML support XML support Yes Yes
XML Indexing XML indexing Yes Yes

Accessing data on the file system Filestream and FileTable Yes Yes FDW

Message queue support Service Broker Yes Yes pgq etc.

PL/pgSQL, PL/Perl,
​P L/pgSQL, PL/Perl, PL/Python, PL/Tcl Yes Yes
PL/Python, PL/Tcl
Support Oracle objects Yes Yes
Support Oracle PL/SQL FULL Part
Oracle -PG Migration tool Yes Yes
Bfiles, Sfiles Yes
SQL/JSON Yes
Vector data in version 17
Manageability
Diagnostics and monitoring Yes Yes Mamonsu, PPEM
Optimization and customization Yes Yes
Real-time request monitoring Yes Yes Mamonsu, PPEM
Automatic updates No No
Performance analysis and load reproduction No No

Database Resource
Resource management Yes Yes
Manager
Limiting the resources of individual
Instance Caging No No
databases within an instance
SQL Plan Management SQL Plan Management Yes Yes sr_plan
Dedicated admin
Dedicated admin connection Yes Yes
connection
Plan guides and plan
Execution plans stabilization Yes Yes sr_plan
freezing
Distributed partitioned
Distributed partitioning Yes Yes Partitioning, child tables as FDW
views
Parallel indexed
Parallel work with indexes Yes Yes
operations
Administration Tools
SQL Management
Instance Management Tools Yes Yes Administrative functions
Objects
SQL Command Prompt
Command line Yes Yes psql
Tool
Traces Creation and Analyses SQL Profiler Yes Yes Using built-in utilities
GUI tool for DBA and monitoring Yes Yes EM
SQL Server Agent SQL Server Agent Yes Yes pgpro_scheduler
Integration and replication
Replication Basic Replication Yes Yes
Multi-master Advanced Replication Yes Yes
Transferring data between databases using
Yes Yes
queues
Transparent integration with external
Database Gateways Yes Yes FDW
systems

Integration with external messaging systems Messaging Gateway Yes Yes FDW

Track changes Change data capture Yes Yes Logical Decoding

Asynchronous command-level replication Merge replication Yes Yes Logical replication (pg_logical, etc.)
Full database copy transfer Snapshot replication Yes Yes By creating and deploying a backup

Transaction-level synchronous replication Transactional replication Yes Yes Logical replication (pg_logical, etc.)

Replication of data block changes (without

Binary replication Yes Yes Physical (streaming) replication
conflicts)
Network
Proxy server, connection multiplexing Yes Yes
Infiniband support Infiniband Support No Yes
Content Management
Spatial data Yes Yes
Semantic Technologies
Semantic data No No
(RDF/OWL)
Spatial data
Spatial indexes Spatial indexes Yes Yes
Parallel spatial index
Parallel creation of spatial indexes No No
builds
Multimaster replication
Multimaster replication of spatial types of SDO_GEOMETRY Yes Yes
objects
Planar and geodetic
Planar and geodetic datatypes Yes Yes Including PostGIS
datatypes
Advanced spatial
Spatial libraries Yes Yes PostGIS
libraries
Import/Export spatial
Import/Export spatial data formats Yes Yes PostGIS
data formats
Extensibility
Ability to extend any DBMS components
Yes Yes
without changing the kernel