Re: User Interface for WAL usage data

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: User Interface for WAL usage data
Дата
Msg-id 20200406163420.GE2228@telsasoft.com
обсуждение исходный текст
Ответ на Re: User Interface for WAL usage data  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: User Interface for WAL usage data
Список pgsql-hackers
On Thu, Apr 02, 2020 at 08:29:31AM +0200, Julien Rouhaud wrote:
> > > "full page records" seems to be showing the number of full page
> > > images, not the record having full page images.
> >
> > I am not sure what exactly is a difference but it is the records
> > having full page images.  Julien correct me if I am wrong.

> Obviously previous complaints about the meaning and parsability of
> "full page writes" should be addressed here for consistency.

There's a couple places that say "full page image records" which I think is
language you were trying to avoid.  It's the number of pages, not the number of
records, no ?  I see explain and autovacuum say what I think is wanted, but
these say the wrong thing?  Find attached slightly larger patch.

$ git grep 'image record'
contrib/pg_stat_statements/pg_stat_statements.c:        int64           wal_num_fpw;    /* # of WAL full page image
recordsgenerated */
 
doc/src/sgml/ref/explain.sgml:      number of records, number of full page image records and amount of WAL

-- 
Justin

Вложения

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: WAL usage calculation patch
Следующее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Index Skip Scan