EuroDB is fully compatible with PostgreSQL 11.5, 10.10, 9.6 and 9.5. 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.

FeatureRHEL/CentOS/SL/OLEuroDB
Maximum BLOB size2GB4TB
Modification of cluster configuration parameters
using a query (ALTER SYSTEM)
noyes
Checksums of data filesnoyes
COPY to STDIN/STDOUTnoyes
INSERT ... ON CONFLICT DO NOTHING / UPDATEnoyes
Materialized viewsnoyes
Support for partitioningnoyes
JIT compilation of queriesnoyes
Efficiency of GIN indiceslowhigh
Size of GIN indiceslargesmall
Modification of the login type for the table
(LOGGED / UNLOGGED)
noyes
Private background processesnoyes
Dynamic background processesnoyes
Inheritance from foreign tablesnoyes
Aggregation of data based on grouping sets
(GROUPING SET)
noyes
Schema import from a foreign servernoyes
Enhanced JSON/JSONB supportnoyes
Support for the LATERAL option
(access to the value of sub-queries in the parent query)
noyes
Refreshing materialized viewsnoyes
Setting the minimum and maximum WAL size
(instead of the number of files)
noyes
Parallel pg_dump (multithreaded)noyes
Replication slotsnoyes
Support for conflict-free, no-key column updates
(NO KEY UPDATE)
noyes
Cascade replicationnoyes
Anonymous shared memorynoyes
Fixed delay in replicasnoyes
Modifiable simple views (UPDATE/INSERT/DELETE)noyes
Row numbering (WITH ORDINALITY)noyes
Modifiable references to foreign databases
(Writable Foreign Data Wrapper)
noyes
Abbreviated indicesnoyes
pg_basebackup bandwidth controlnoyes
BRIN indicesnoyes
Parallel database cleaning (VACUUM)noyes
Support for cold database start (pg_prewarm)noyes
Reduced blocking level for table modificationsnoyes
Table sampling (TABLESAMPLE)noyes
Skipping blocked rowsnoyes
Support for Kerberos 5noyes
Filter handling on aggregated resultsnoyes
Data transformation support (TRANSFORM)noyes
pg_rewind (restoring cluster nodes after failover)noyes
Support for regular expressions in trigram indexesnoyes
Access to a readable WAL dumpnoyes
Support for defining partitions with primary keys, foreign keys, indices and triggersnoyes
Default partition for partitioned tablesnoyes
Creating partitions using the so-called hash partitioningnoyes
Automatic transfer of rows between partitions in case of a key changenoyes