Re: [GENERAL] tuple statistics update

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] tuple statistics update
Дата
Msg-id 22480.1492545978@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [GENERAL] tuple statistics update  (Tom DalPozzo <t.dalpozzo@gmail.com>)
Ответы Re: [GENERAL] tuple statistics update  (Tom DalPozzo <t.dalpozzo@gmail.com>)
Список pgsql-general
Tom DalPozzo <t.dalpozzo@gmail.com> writes:
> Hi, I'm using libpq to insert tuples in my table and keep looking at
> statistics through psql instead.
> I noticed that sometimes n_tuple_ins is not updated even after 1 min that
> my transaction committed.

If your session is just sitting, that's not surprising.  I think stats
updates are only transmitted to the collector at transaction end (and
even then, only if it's been at least N msec since the last transmission
from the current session).

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] tuple statistics update
Следующее
От: Rj Ewing
Дата:
Сообщение: [GENERAL] full text search on hstore or json with materialized view?