EuroDB is fully compatible with PostgreSQL 13.3.1, 12.3, 11.8, 10.13 and 9.6. Migration from the native implementation of this engine does not require any changes to the applications. Possible changes are simple, optional, and they aim to improve the use of the additional capabilities of EuroDB.

The following table includes some features which illustrate the difference in the capabilities of the engine used in the EuroDB compared to the native PostgreSQL implementation available in Red Hat®, Oracle® Linux, CentOS, and Scientific Linux.

Feature RHEL/CentOS/SL/OL EuroDB
Maximum BLOB size 2GB 4TB
Modification of cluster configuration parameters
using a query (ALTER SYSTEM)
no yes
Checksums of data files no yes
COPY to STDIN/STDOUT no yes
INSERT ... ON CONFLICT DO NOTHING / UPDATE no yes
Materialized views no yes
Support for partitioning no yes
JIT compilation of queries no yes
Efficiency of GIN indices low high
Size of GIN indices large small
Modification of the login type for the table
(LOGGED / UNLOGGED)
no yes
Private background processes no yes
Dynamic background processes no yes
Inheritance from foreign tables no yes
Aggregation of data based on grouping sets
(GROUPING SET)
no yes
Schema import from a foreign server no yes
Enhanced JSON/JSONB support no yes
Support for the LATERAL option
(access to the value of sub-queries in the parent query)
no yes
Refreshing materialized views no yes
Setting the minimum and maximum WAL size
(instead of the number of files)
no yes
Parallel pg_dump (multithreaded) no yes
Replication slots no yes
Support for conflict-free, no-key column updates
(NO KEY UPDATE)
no yes
Cascade replication no yes
Anonymous shared memory no yes
Fixed delay in replicas no yes
Modifiable simple views (UPDATE/INSERT/DELETE) no yes
Row numbering (WITH ORDINALITY) no yes
Modifiable references to foreign databases
(Writable Foreign Data Wrapper)
no yes
Abbreviated indices no yes
pg_basebackup bandwidth control no yes
BRIN indices no yes
Parallel database cleaning (VACUUM) no yes
Support for cold database start (pg_prewarm) no yes
Reduced blocking level for table modifications no yes
Table sampling (TABLESAMPLE) no yes
Skipping blocked rows no yes
Support for Kerberos 5 no yes
Filter handling on aggregated results no yes
Data transformation support (TRANSFORM) no yes
pg_rewind (restoring cluster nodes after failover) no yes
Support for regular expressions in trigram indexes no yes
Access to a readable WAL dump no yes
Support for defining partitions with primary keys, foreign keys, indices and triggers no yes
Default partition for partitioned tables no yes
Creating partitions using the so-called hash partitioning no yes
Automatic transfer of rows between partitions in case of a key change no yes