Chapter 26. Regression Test

Table of Contents

Regression Environment

Directory Layout

Regression Test Procedure

Regression Analysis

Regression test instructions and analysis.

The PostgreSQL regression tests are a comprehensive set of tests for the SQL implementation embedded in PostgreSQL developed by Jolly Chen and Andrew Yu. It tests standard SQL operations as well as the extended capabilities of PostgreSQL.

These tests have recently been revised by Marc Fournier and Thomas Lockhart and are now packaged as functional units which should make them easier to run and easier to interpret. From PostgreSQL v6.1 onward the regression tests are current for every official release.

Some properly installed and fully functional PostgreSQL installations can fail some of these regression tests due to artifacts of floating point representation and time zone support. The current tests are evaluated using a simple "diff" algorithm, and are sensitive to small system differences. For apparently failed tests, examining the differences may reveal that the differences are not significant.

The regression testing notes below assume the following (except where noted):

• Commands are Unix-compatible. See note below.

• Defaults are used except where noted.

• User postgres is the Postgres superuser.

• The source path is /usr/src/pgsql (other paths are possible).

• The runtime path is /usr/local/pgsql (other paths are possible).