Re: n_ins_since_vacuum stats for aborted transactions

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: n_ins_since_vacuum stats for aborted transactions
Дата
Msg-id CAA5RZ0upB-TYCxqpbidgbHMSm_v0GHh39AQDUQmrdohpW6YDsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: n_ins_since_vacuum stats for aborted transactions  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: n_ins_since_vacuum stats for aborted transactions
Re: n_ins_since_vacuum stats for aborted transactions
Список pgsql-hackers
> Forget original purpose, is there presently a bug or not?

Yes, there is a bug. Accounting rows inserted as part of an aborted
transaction in
n_ins_since_vacuum is not correct, since the same rows are being
accounted for with n_dead_tup.

> Between the two options the one where we count dead tuples makes more sense on its face.

IIUC, I am saying the same thing, if an inserted row is rolled back,
it should only count as a
dead tuple (n_dead_tup) only, and not in n_ins_since_vacuum.

--
Sami Imseih
Amazon Web Services (AWS)



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