Re: ANALYZE, pg_class.xmin && pg_class.reltuples - Mailing list pgsql-general

From Tom Lane
Subject Re: ANALYZE, pg_class.xmin && pg_class.reltuples
Date
Msg-id 297264.1637856473@sss.pgh.pa.us
Whole thread Raw
In response to ANALYZE, pg_class.xmin && pg_class.reltuples  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
Luca Ferrari <fluca1978@gmail.com> writes:
> I've a doubt about running ANALYZE and inspecting pg_class.xmin and
> pg_class.reltuples.
> ...
> So the pg_class record has changed its content, and in fact we are now
> 2 transaction away the table creation, but the pg_class.xmin is the
> same.

ANALYZE (and VACUUM) update the table's pg_class row non-transactionally.
See the comments for vac_update_relstats():


https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/vacuum.c;h=5c4bc15b441b36da99b0703500a3268086b40d9e;hb=HEAD#l1266

            regards, tom lane



pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Error message while trying to connect from PGAdmin 4
Next
From: Shaozhong SHI
Date:
Subject: function difference not found