Add n_tup_newpage_upd to pg_stat table views

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Add n_tup_newpage_upd to pg_stat table views
Дата
Msg-id CADkLM=ded21M9iZ36hHm-vj2rE2d=zcKpUQMds__Xm2pxLfHKA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Add n_tup_newpage_upd to pg_stat table views  (Andres Freund <andres@anarazel.de>)
Re: Add n_tup_newpage_upd to pg_stat table views  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
This patch adds the n_tup_newpage_upd to all the table stat views.

Just as we currently track HOT updates, it should be beneficial to track updates where the new tuple cannot fit on the existing page and must go to a different one.

Hopefully this can give users some insight as to whether their current fillfactor settings need to be adjusted.

My chosen implementation replaces the hot-update boolean with an update_type which is currently a three-value enum. I favored that only slightly over adding a separate newpage-update boolean because the two events are mutually exclusive and fewer parameters is less overhead and one less assertion check. The relative wisdom of this choice may not come to light until we add a new measurement and see whether that new measurement overlaps either is-hot or is-new-page.



Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: heapgettup() with NoMovementScanDirection unused in core?
Следующее
От: David Rowley
Дата:
Сообщение: Re: heapgettup() with NoMovementScanDirection unused in core?