[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: xmax not zero?
From:       Laurenz Albe <laurenz.albe () cybertec ! at>
Date:       2023-10-31 8:44:54
Message-ID: 5392fc2be0f09ca2cc063a6b25d0f9560d449808.camel () cybertec ! at
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]