Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
EDB Postgres Advanced Server 13 Release Notes¶
With this release of EDB Postgres Advanced Server 13, EnterpriseDB continues to lead as the only worldwide company to deliver innovative and low cost open-source-derived database solutions with commercial quality, ease of use, compatibility, scalability, and performance for small or large-scale enterprises.
EDB Postgres Advanced Server 13 is built on open-source PostgreSQL 13, which introduces myriad enhancements that enable databases to scale up and scale out in more efficient ways. PostgreSQL 13 has significant performance improvements, which includes an improved indexing and lookup system, a level up on query planning when using extended statistics, improved performance for queries that use aggregates or partitioned tables, and providing more ways to monitor activity within a PostgreSQL database. And along with highly requested features like parallelized vacuuming, incremental sorting, PostgreSQL 13 has a multitude of other new features and capabilities.
EDB Postgres Advanced Server 13 adds a number of new features that will delight developers and DBAs alike, including:
Automatic LIST Partitioning
PARTITION number
orSUBPARTITION number
clauses while creating a HASH partition tableForward declarations in the package body
CREATE INDEX
syntax contains column name and constantUSING INDEX
clause inCREATE TABLE
andALTER TABLE
EDB Loader handles unique constraint violations
STATS_MODE
aggregate functionSupport for
utl_http.end_of_body
exceptionEDB Loader supports any connection parameters with the
-c
orCONNSTR
option
Installers and Documentation¶
EDB Postgres Advanced Server v13 is packaged and delivered as interactive installers for Windows; visit the EnterpriseDB website:
RPM Packages are available for Linux from:
Debian/Ubuntu Packages are available for download from:
To request the credentials required to access EDB repositories, visit:
Documentation is provided on the EDB website, visit:
Supported Platforms¶
EDB Postgres Advanced Server v13 installers support 64 bit Linux and Windows server platforms. The Advanced Server 13 RPM packages are supported on the following 64-bit Linux platforms:
Red Hat Enterprise Linux (x86_64) 7.x and 8.x
CentOS (x86_64) 7.x and 8.x
OEL (x86_64) 7.x and 8.x
PPC64LE 8 running CentOS/RHEL 7.x
The EDB Postgres Advanced Server 13 native packages are supported on the following 64-bit Linux platforms:
Debian 9.x and 10.x
Ubuntu 18.04 and 20.04
Graphical installers are supported on the following 64-bit Windows platforms:
Windows 2019
Windows Server 2016
Additional information about supported platforms is available on the EDB website:
Component Certification¶
The following components are included in the EDB Postgres Advanced Server v13 release:
EPAS 13.1.4
BART 2.6
Cloneschema 1.14
Connectors JDBC 42.2.12.3, ODBC 12.02.0000.02, .NET 4.1.5.1, OCL 13.1.4.1
Edb-Modules 1.0
EDBPlus 39.0.0
EFM 4.0
Hdfs_fdw 2.0.7
Mongo_fdw 5.2.8
MySQL_fdw 2.5.5
MTK 54.0.0
Parallel Clone 1.8
PEM 7.16
PgAdmin 4.27
PgAgent 4.2.0
PgBouncer 1.14
PgPool 4.1.2
PostGIS 3.0.2
Procedural Language Packs – PL/Perl 5.26, PL/Python 3.7, PL/TCL 8.6
Slony 2.2.8
EDB Postgres Advanced Server v13 Features¶
The major highlights of this release are :
Automatic LIST Partitioning is an extension to LIST partitioning that allows a database to automatically create a partition for any new distinct value of the LIST partitioning key. A new partition is created when data is inserted into the LIST partitioned table and the inserted value does not match any of the existing table partitions.
Additional
smallint
,int
,bigint
, andnumeric
variants in theMEDIAN
aggregate function.Added support for
CREATE INDEX
syntax that contains a column name and number, i.e.(col_name,1)
.Added support to alter the owner of the directory -
ALTER DIRECTORY <dir_name> OWNER TO <role_name>
.CSV and XML audit logs have been made consistent. It has been observed that there is a difference in terms of number of fields in the CSV and XML formatted audit logs. Now the audit log is consistent across both formats.
Default behaviour for
dbms_output
made compatible with Redwood. By default, thedbms_output
behaviour isoff
in Oracle; in EPAS it is alwayson
. In this release, EPAS adds a GUC to control the default behaviour forDBMS_OUTPUT
package.You can log the number of processed statements with
edb_log_every_bulk_value
. Currently, during bulk execution EPAS did not identify the number of rows processed whenedb_log_every_bulk_value
wasoff
. This feature allows EPAS to log it both in the audit log file and server log file. This will help you analyze the logs for such cases.Previously, EDB Loader would abort the whole operation if any record insertion fails due to a unique constraint violation. This is fixed by using speculative insertion to insert rows. This behavior is enforced if
handle_conflicts
(a new parameter) istrue
and indexes are present.SYSDATE
now behaves in a more compatible manner.SYSDATE
output changes at every nesting level, so multiple copies of SYSDATE in the same SQL query will return the same value each time.SYSDATE
changes on successive statements in the same procedure, or within a nested function call.PARALLEL [n] | NOPARALLEL
option forCREATE TABLE
andINDEX
. Advanced Server now supports thePARALLEL [n] | NOPARALLEL
clause in theCREATE TABLE
,ALTER TABLE
,CREATE INDEX
, andALTER INDEX
commands to enable or disable parallelism on an index or a table.PARTITION [n]
orSUBPARTITION [n]
while creating a table. This feature allows you to automatically create[n]
hash partitions at a subpartition level.EDB Loader supports any connection parameters. You can use the EDB Loader
-c
orCONNSTR
options to specify any connection parameters supported by libpq. This includes SSL connection parameters.The
STATS_MODE
function takes a set of values as an argument and returns the value that occurs with the highest frequency. If multiple values appear with the same frequency, theSTATS_MODE
function arbitrarily chooses the first value and returns only that one value.Added support for DBMS_SQL function/procedures (
DEFINE_COLUMN_LONG
,COLUMN_VALUE_LONG
andLAST_ERROR_POSITION
).Added support for function
to_timestamp_tz()
.Added support for function/procedure specification inside package body.
Added support for FM format in
to_number
function.Added support for
AES192
andAES256
in theDBMS_CRYPTO
package.Added support for the spell mode in
to_char(timestamptz, text)
function.Allow creating a compound trigger having WHEN clause with NEW/OLD variables and STATEMENT level triggering events. Enhanced Redwood compatible view.
Log matched line of
pg_hba.conf
on successful client authentication. Enhancedpg_catcheck
to test for and raise an error if a relation’srelfilenode
is missing from thedata
directory.Added support for utl_http.end_of_body exception. This feature declares the end_of_body exception into utl_http package and throws the same from read_line, read_text, and read_raw package procedures when no data is left in the response body.
The UNIQUE and PRIMARY KEY constraint clauses now have a CREATE INDEX statement. This new syntax allows users to specify explicit index details like fillfactor, etc. Columns specified in the constraint and the columns specified in the index must be the same.
For information about Advanced Server features that are compatible with Oracle databases, see the following guides:
Database Compatibility for Oracle Developer’s SQL Guide
Database Compatibility for Oracle Developer’s Reference Guide
Database Compatibility for Oracle Developer’s Built-in Package Guide
Database Compatibility for Oracle Developer’s Tools and Utilities Guide
Database Compatibility Table Partitioning Guide
Database Compatibility Stored Procedural Language Guide
Community PostgreSQL 13 Updates¶
EDB Postgres Advanced Server 13 integrates all of the community PostgreSQL 13 features. To review a complete list of changes to the community PostgreSQL project and the contributors names, see the PostgreSQL 13 Release Notes at:
How to Report Problems¶
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone:
US: +1-732-331-1320 or 1-800-235-5891UK: +44-2033719820Brazil: +55-2139581371India: +91-20-66449612