With so many workloads being migrated to the cloud, this is a question we get all the time. For anyone making this move there are many choices to make and options to consider. In this post, I will step through those to help you decide on a path forward. First, recognize that not every workload is equally suited for cloud deployment. To properly prioritize workloads, it is recommended that...

EnterpriseDB supports a wide array of connectors to integrate your application with EDB Postgres, and our Connectors team has been hard at work, just releasing our Connectors 10.0.2 update. This release made a host of enhancements to all four supported connectors. In this post, I’ll bring you up to speed on our supported connectors, their Oracle compatibility, and new features in this release.

Ericsson CMS is a comprehensive platform for the end-to-end management of content operations for the television industry. In order to keep pace with the increasing demands for volume and performance, the organization replaced its legacy database system with EDB Postgres Advanced Server to ensure scalability, increase performance and reduce operational costs.

Here’s a step-by-step guide to install PostgreSQL on your machine using Postgres Installer.

There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequential Scans). Each of the past three releases (including PG-11, which is in its beta) have a parallel query as a major feature which in itself says how useful this feature is and the amount of work being done on this feature. You can read more about parallel...

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...