A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The first line must be a #!-style line that indicates the shell to use. The rest of the function body will be executed by that shell in a separate process. The arguments are available as $1, $2, etc., ...

Our previous blog article, “The Part of PostgreSQL We Hate the Most,” discussed the problems caused by everyone’s favorite street-strength DBMS multi-version concurrency control (MVCC) implementation.

This article was written in collaboration with Bohan Zhang and originally appeared on the OtterTune website. In this article, we’ll dive into MVCC: what it is, how PostgreSQL does it, and why it is ...

This article describes how to back up PostgreSQL databases in Azure Virtual Machines by using the Azure CLI. You can also configure backup using Azure portal, Azure PowerShell, and REST API for ...

Database management systems have been a crucial component of infrastructures for many years now. PostgreSQL is an advanced, object-relational database management system that is frequently used to ...