---
title: "Regression Tests"
id: regress
pg_version: "20devel"
---

<a id="regress"></a>

# Regression Tests

## Table of Contents

- [31.1. Running the Tests](regress-run.md)
  - [31.1.1. Running the Tests Against a Temporary Installation](regress-run.md#regress-run-temp-inst)
  - [31.1.2. Running the Tests Against an Existing Installation](regress-run.md#regress-run-existing-inst)
  - [31.1.3. Running Specific Tests](regress-run.md#regress-subset)
  - [31.1.4. Additional Test Suites](regress-run.md#regress-additional)
  - [31.1.5. Locale and Encoding](regress-run.md#regress-run-locale)
  - [31.1.6. Path Substitution](regress-run.md#regress-run-path-substitution)
  - [31.1.7. Custom Server Settings](regress-run.md#regress-run-custom-settings)
  - [31.1.8. Extra Tests](regress-run.md#regress-run-extra-tests)
- [31.2. Test Evaluation](regress-evaluation.md)
  - [31.2.1. Error Message Differences](regress-evaluation.md#regress-evaluation-message-differences)
  - [31.2.2. Locale Differences](regress-evaluation.md#regress-evaluation-locale-differences)
  - [31.2.3. Date and Time Differences](regress-evaluation.md#regress-evaluation-date-time-differences)
  - [31.2.4. Floating-Point Differences](regress-evaluation.md#regress-evaluation-float-differences)
  - [31.2.5. Row Ordering Differences](regress-evaluation.md#regress-evaluation-ordering-differences)
  - [31.2.6. Insufficient Stack Depth](regress-evaluation.md#regress-evaluation-stack-depth)
  - [31.2.7. The "random" Test](regress-evaluation.md#regress-evaluation-random-test)
  - [31.2.8. Configuration Parameters](regress-evaluation.md#regress-evaluation-config-params)
- [31.3. Variant Comparison Files](regress-variant.md)
- [31.4. TAP Tests](regress-tap.md)
  - [31.4.1. Environment Variables](regress-tap.md#regress-tap-vars)
- [31.5. Test Coverage Examination](regress-coverage.md)
  - [31.5.1. Coverage with Autoconf and Make](regress-coverage.md#regress-coverage-configure)
  - [31.5.2. Coverage with Meson](regress-coverage.md#regress-coverage-meson)

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