# Monitor PostgreSQL transaction age even on quiet tables

> Review transaction age as well as space when supervising PostgreSQL vacuum work.

- Canonical URL: https://update.dsesecurity.com/updates/monitor-postgresql-transaction-age-even-on-quiet-tables/
- Publisher: Detection Systems & Engineering (DSE Security)
- Author: DSE Security Editorial Team
- Published: 2026-10-15T13:32:35+00:00
- Modified: 2026-10-15T13:36:15+00:00
- Last reviewed by DSE: 2026-10-15
- Resource type: Guide
- DSE priority: Information
- Topics: Business Continuity, IT
- Reading time: 2 minutes

## What you need to know

Review transaction age as well as space when supervising PostgreSQL vacuum work.

## Potentially affected

This applies to PostgreSQL 17 maintenance monitoring. It addresses transaction-age protection and does not establish universal alert thresholds or a safe reason to cancel a running vacuum.

## DSE recommendation

DSE recommends showing transaction age alongside space and workload indicators in the maintenance review.

## Article

Review transaction age as well as space when supervising PostgreSQL vacuum work.

## Source facts

PostgreSQL 17 vacuuming protects against transaction-ID and multixact-ID wraparound as well as reclaiming dead-row space. A table can therefore need vacuuming even when it receives few updates or deletes. Aggressive vacuuming freezes eligible old row versions, including pages a normal vacuum may skip. Anti-wraparound autovacuum work can be triggered even when ordinary autovacuum is disabled. The documented age queries measure transactions since the relevant cutoff, rather than elapsed calendar days.

Source: [PostgreSQL 17 — Routine Vacuuming](https://www.postgresql.org/docs/17/routine-vacuuming.html).

## Applicability

This applies to PostgreSQL 17 maintenance monitoring. It addresses transaction-age protection and does not establish universal alert thresholds or a safe reason to cancel a running vacuum.

## DSE recommendation

DSE recommends showing transaction age alongside space and workload indicators in the maintenance review. Assign an owner to investigate old relations, long-lived work, and unsuccessful vacuum progress. Treat a quiet or mostly static table as part of that review rather than excluding it because its file size is stable. Have a qualified administrator evaluate interventions and application impact before changing freeze settings or terminating maintenance. Record the reason for any temporary autovacuum configuration exception.

## Verification

Use a representative test database to inspect database and relation age, then observe how suitable vacuum work advances the recorded cutoff. Confirm the monitoring explains its units and identifies the oldest objects. Keep maintenance logs and unresolved blockers attached to the operational review.

## Official reference

[PostgreSQL 17 — Routine Vacuuming](https://www.postgresql.org/docs/17/routine-vacuuming.html). Reviewed October 15, 2026.

## Primary reference

- Name: PostgreSQL 17 — Routine Vacuuming
- Authority: www.postgresql.org
- URL: https://www.postgresql.org/docs/17/routine-vacuuming.html
- Source publication date: Not stated by the source

## Citation and use

Preferred citation: “Monitor PostgreSQL transaction age even on quiet tables,” DSE Security, https://update.dsesecurity.com/updates/monitor-postgresql-transaction-age-even-on-quiet-tables/
Publishing principles: https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/
Usage and citation policy: https://update.dsesecurity.com/usage/
Copyright © 2026 Detection Systems & Engineering. All rights reserved.