PostgreSQL 9.4 extends the SQL standard by inserting two new clauses that facilitate many operations required during the development of applications: the WITHIN GROUP and FILTER clauses.

For PostgreSQL 10, I have worked on a feature called “identity columns”. This blog explores this feature.

repmgr is an open-source toolset from 2ndQuadrant, a leading specialist in PostgreSQL-related technologies and services. The product is used to automate, enhance, and manage PostgreSQL streaming replication. Streaming replication in PostgreSQL has been around since version 9.0. Natively setting up and managing streaming replication involves a number of manual steps which includes the following.

This article is the first in a series about migrating from Oracle to PostgreSQL. We will attempt to cover each of the topics of migration in some amount of depth and provide multiple options to the same issues and architectures.

When it comes to choosing a database platform in the healthcare industry, hospitals and large healthcare providers have historically chosen the familiar vendor, like Microsoft SQL Server. They know the name, their IT staff is typically comfortable with Microsoft products, and they feel that—if they had to—they could get support from Microsoft. Another database option that could offer more cost...

This article discusses how to perform benchmark tests using the open source tool, HammerDB, as an alternative to using pgbench. We will review: Hardware specifications Operating system configurations PostgreSQL configurations Benchmarking specifications Benchmarking results The standard tool used to benchmark PostgreSQL is pgbench. In an earlier post, we discussed how we can tune and benchmark...

There is no question that PostgreSQL adoption is increasing exponentially. Organizations of all sizes are deploying PostgreSQL for a variety of database workloads. As a result, you can find PostgreSQL everywhere—in your OS with Red Hat Enterprise Linux, Ubuntu, SUSE; on your platform in VMware, Heroku, Docker Hub; in your public cloud providers as a service, and even on Kubernetes distributions, such as Red Hat OpenShift.

In this post, we dig into why it's essential to monitor Postgres, and how to do it effectively

This technical blog explains how CREATE INDEX CONCURRENTLY (CIC) works and how it manages to avoid locking the table from updates. A unique distinguishing factor of CIC is that it can build a new index on the table, without blocking it from updates/inserts/deletes.

Deciding on a development framework for a new project is often done ad hoc, based on the available expertise and personal preferences of the developers involved in the project. However, the more rational approach for an enterprise would involve looking at specific criteria that the development framework should satisfy. The “general science” of making such a choice is simple and well-established...