Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple? - Mailing list pgsql-general

From Luca Ferrari
Subject Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?
Date
Msg-id CAKoxK+5YZMZZjt7kY0yqLE2J6+nrAE7BDE_BNYnfnvHP5e9qsg@mail.gmail.com
Whole thread Raw
In response to Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?
List pgsql-general
On Fri, Sep 27, 2019 at 3:52 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> n_live_tup/n_dead_tup should not be thought to be better than
> approximations.  Most operations adjust them only incrementally,
> and messages to the stats collector can get dropped entirely
> under heavy load, causing deltas to go missing.  There are
> also race conditions involved in some update scenarios.
>

Are you suggesting tha autovacuum made free space available so that
pg_stat_user_tables lags behind? Because I don't see last_autovacuum
changing in the mantime.

Luca



pgsql-general by date:

Previous
From: Christoph Berg
Date:
Subject: Re: pg12 rc1 on CentOS8 depend python2
Next
From: Adrian Klaver
Date:
Subject: Re: "Failed to connect to Postgres database"