Re: Add n_tup_newpage_upd to pg_stat table views

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Add n_tup_newpage_upd to pg_stat table views
Дата
Msg-id CAH2-Wzn-rnj4U8sFwr0Tu0sGutwvuuWo8EXyCrPpUJ=LxYuthA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add n_tup_newpage_upd to pg_stat table views  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Add n_tup_newpage_upd to pg_stat table views  (Michael Paquier <michael@paquier.xyz>)
Re: Add n_tup_newpage_upd to pg_stat table views  (Corey Huinker <corey.huinker@gmail.com>)
Список pgsql-hackers
On Fri, Mar 17, 2023 at 3:22 PM Peter Geoghegan <pg@bowt.ie> wrote:
> I think that this is pretty close to being committable already.

Attached revision has some small tweaks by me. Going to commit this
revised version tomorrow morning.

Changes:

* No more dedicated struct to carry around the type of an update.

We just use two boolean arguments to the pgstats function instead. The
struct didn't seem to be adding much, and it was distracting to track
the information this way within heap_update().

* Small adjustments to the documentation.

Nearby related items were tweaked slightly to make everything fit
together a bit better. For example, the description of n_tup_hot_upd
is revised to make it obvious that n_tup_hot_upd counts row updates
that can never get counted under the new n_tup_newpage_upd counter.

--
Peter Geoghegan

Вложения

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Add pg_walinspect function with block info columns
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Add pg_walinspect function with block info columns