From: Masahiro Ikeda <ikedamsh@oss.nttdata.com>
To: lchch1990@sina.cn
Cc: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Add statistics to pg_stat_wal view for wal related parameter tuning
Date: Thu, 19 Nov 2020 17:03:20 +0900
Message-ID: <8cce3af13eae4116a98fd29eaa2d9e54@oss.nttdata.com> (raw)
In-Reply-To: <2020111711533714942211@sina.cn>
References: <35ef960128b90bfae3b3fdf60a3a860f@oss.nttdata.com>
<CAA4eK1JbbP-QmZWiXwK+H-ZauJCGR6vbAVoGdyx_TTxRPuXzhQ@mail.gmail.com>
<06bc2d405b086a72fb14657de9befae8@oss.nttdata.com>
<2020102114544806663477@sina.cn>
<ac8b1f5e589932254efe373e252e5dcb@oss.nttdata.com>
<2020111311322320943423@sina.cn>
<3599412d5f3eee44e3658e81d3790f6a@oss.nttdata.com>
<cca12983-1254-1c4d-316c-48d3d4508d4c@oss.nttdata.com>
<2020111711533714942211@sina.cn>
On 2020-11-17 12:53, lchch1990@sina.cn wrote:
>>> Thanks for your comments.
>>>
>>> You're understanding is almost the same as mine.
>>> It describes when not only backends but also other backgrounds
> initialize a new wal page,
>>> wal buffer's space is already used and there is no space.
>>>
>>>> 'Total number of times WAL data written to the disk because a
> backend
>>>> yelled a wal buffer for an advanced wal page'
>>>
>>> Thanks for your suggestion.
>>> I wondered that users may confuse about how to use
> "wal_buffers_full" and how to tune parameters.
>>>
>>> I thought the reason which wal buffer has no space is
>>> important for users to tune the wal_buffers parameter.
>>>
>>> How about the following comments?
>>>
>>> 'Total number of times WAL data was written to the disk because WAL
> buffers got full
>>> when to initialize a new WAL page'
>> Or what about the following?
>> Total number of times WAL data was written to the disk, to claim the
> buffer page to insert new
>> WAL data when the WAL buffers got filled up with unwritten WAL data.
> As my understand we can not say 'full' because every wal page mapped a
> special wal buffer slot.
> When a wal page need to be write, but the buffer slot was occupied by
> other wal page. It need to
> wait the wal buffer slot released. So i think we should say it
> 'occupied' not 'full'.
>
> Maybe:
> Total number of times WAL data was written to the disk, to claim the
> buffer page to insert new
> WAL data when the special WAL buffer occupied by other page.
OK, I will change the above sentence since there are some sentences
like "space occupied by", "disk blocks occupied", and so on in the
documents.
Do we need to change the column name from "wal_buffers_full"
to another name like "wal_buffers_all_occupied"?
Regards
--
Masahiro Ikeda
NTT DATA CORPORATION
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: ikedamsh@oss.nttdata.com, lchch1990@sina.cn, masao.fujii@oss.nttdata.com, amit.kapila16@gmail.com
Subject: Re: Add statistics to pg_stat_wal view for wal related parameter tuning
In-Reply-To: <8cce3af13eae4116a98fd29eaa2d9e54@oss.nttdata.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox