Re: xmax not zero?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: xmax not zero?
Date: 2023-10-31 08:44:54
Message-ID: 5392fc2be0f09ca2cc063a6b25d0f9560d449808.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2023-10-31 13:58:17 Re: pg_checksums?
Previous Message Luca Ferrari 2023-10-31 07:23:02 Re: xmax not zero?