Re: Incorrect accounting (n_tup_ins) of non-inserted rows

Поиск
Список
Период
Сортировка
От Ilya Matveychikov
Тема Re: Incorrect accounting (n_tup_ins) of non-inserted rows
Дата
Msg-id CAKh5naZqAL8yVG+8JVCB3DtQiwhq3FafXKpFtb18o-H5gKxzaA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Incorrect accounting (n_tup_ins) of non-inserted rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
2016-03-18 16:25 GMT+03:00 Tom Lane <tgl@sss.pgh.pa.us>:
> No, it's not a bug, and it's not going to be fixed.  For many of the
> intended applications of those counts (e.g, determining whether
> autovacuum/autoanalyze is needed), this is the correct behavior
> and ignoring actions of failed transactions would be incorrect.
>

Thank you for clarifying.

> The live/dead tuple counts do attempt to take transaction success
> into account; perhaps looking at those would be more helpful for
> your use-case?

I'll take a look on that counters, thanks.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #14031: Failed to Write to History File
Следующее
От: David Gould
Дата:
Сообщение: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.