Re: xmax not zero? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: xmax not zero?
Date
Msg-id 5392fc2be0f09ca2cc063a6b25d0f9560d449808.camel@cybertec.at
Whole thread Raw
In response to Re: xmax not zero?  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
On Tue, 2023-10-31 at 08:23 +0100, Luca Ferrari wrote:
> What puzzled me was that such xmax was non-zero for a
> while (days). Inspecting pg_class.reloptions I found that accidentally
> (?) disabled autovacuum on such table, my fault!
> I should have checked pg_stat_user_tables at first!

VACUUM won't modify "xmax", nor will it remove the row.

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: xmax not zero?
Next
From: Paul Förster
Date:
Subject: Re: pg_checksums?