Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?
Дата
Msg-id CAKoxK+5YZMZZjt7kY0yqLE2J6+nrAE7BDE_BNYnfnvHP5e9qsg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple?
Список 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 по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: pg12 rc1 on CentOS8 depend python2
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: "Failed to connect to Postgres database"