We encounter some confusion around which versions of EDB Postgres Backup and Recovery Tool (BART) are supported with which version of our database server, EDB Postgres Advanced Server (EPAS). This calls for publishing a BART support matrix to describe the BART/Database server version support as well as the support period for every release. BART 1.0 1.1 2.0 2.1 2.2 EPAS 9.1 YES YES NO NO NO EPAS 9...

Before declarative partitioning was introduced in PostgreSQL 10, one had to use table inheritance. One of the main drawbacks of using table inheritance is that ROW triggers are needed for the parent table to automatically route the inserted row to the right child table, which is cumbersome and slow. With declarative partitioning, when you insert a row into a partitioned table, that row is...

Thanks to the tireless work of Google Summer of Code student Shubham Barai with the support of reviewers, a mentor, and a committer, PostgreSQL 11 will ship with predicate lock support for hash indexes, gin indexes and gist indexes. These will make SERIALIZABLE transaction isolation much more efficient with those indexes, filling in some of the feature combination gaps and quirks that exist in my...

With a tradition going back to 1834, the Van Genechten Group is one of Belgium’s most successful privately owned companies. Its Packaging Division is one of Europe’s leading vendors of premium packaging products with production sites in seven countries.

Competitive pressures have brought profound change to the telecommunications industry. Telecom companies have seen a rise in new digital devices and changing business models for delivering services, while traditional voice and messaging products have become commoditized, pushing prices downward. As a result, telecommunications companies have been aggressive in their adoption of open source...

In this video, we will have a look at how parallel sequential scan can be used in EDB Postgres Advanced Server to enhance the performance of the queries.

Contributed by Richard Yen I recently got a few support cases from customers seeking to connect Postgres with LDAP (usually with some form of SSL/TLS encryption, to ensure security). I spent a bit of time trying to create a consistently reproducible environment where LDAP could be used to authenticate PostgreSQL connections, and wanted to write it down somewhere. The trickiest part was to get LDAP...

A good DBA is someone who knows how to monitor the databases EFFECTIVELY and when it comes to a production or business critical database, the job becomes even more crucial.

Technology managers are rapidly modernizing their data infrastructures to achieve greater flexibility in today’s hypercompetitive marketplace. They need flexibility over their licensing portfolio, ability to configure modern applications, and choice of deployment environments to keep pace with digital transformation.

PostgreSQL v10 Associate Certification Available PostgreSQL 10 was the most significant Postgres release in recent years. Available since October 2017, it provided database administrators flexibility, powerful new database features, and an array of new deployment choices. The release expanded deployment options and increased database performance. If you have had an opportunity to work with the new...