Blog

The regression tests are a comprehensive set of tests for the SQL implementation in PostgreSQL. They test standard SQL operations as well as the extended capabilities… Read More »PostgreSQL Regression Tests

This chapter explains what just-in-time compilation is, and how it can be configured in PostgreSQL. What Is JIT compilation? Just-in-Time (JIT) compilation is the process of turning some… Read More »PostgreSQL Just-in-Time Compilation (JIT)

Logical replication is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key). We use the term… Read More »PostgreSQL Logical Replication

This chapter explains how the Write-Ahead Log is used to obtain efficient, reliable operation. Reliability Reliability is an important property of any serious database system,… Read More »PostgreSQL Reliability and Write-Ahead Log

PostgreSQL can devise query plans which can leverage multiple CPUs in order to answer queries faster. This feature is known as parallel query. Many queries cannot… Read More »PostgreSQL Parallel Query

Query performance can be affected by many things. Some of these can be controlled by the user, while others are fundamental to the underlying design… Read More »PostgreSQL Performance Tips

This chapter describes the behavior of the PostgreSQL database system when two or more sessions try to access the same data at the same time. The goals… Read More »PostgreSQL Concurrency Control

This chapter discusses how to monitor the disk usage of a PostgreSQL database system. Determining Disk Usage Each table has a primary heap disk file where most… Read More »PostgreSQL Monitoring Disk Usage

A database administrator frequently wonders, “What is the system doing right now?” This chapter discusses how to find that out. Several tools are available for monitoring database… Read More »PostgreSQL Monitoring Database Activity

Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several… Read More »PostgreSQL High Availability and Replication

As with everything that contains valuable data, PostgreSQL databases should be backed up regularly. While the procedure is essentially simple, it is important to have a clear… Read More »PostgreSQL Backup and Restore

PostgreSQL, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive… Read More »PostgreSQL Routine Database Maintenance Tasks