From: <Shinya11.Kato@nttdata.com>
To: <pgsql-docs@lists.postgresql.org>
Subject: change float4 to floating point about type of
 autovacuum_vacuum_insert_scale_factor
Thread-Topic: change float4 to floating point about type of
 autovacuum_vacuum_insert_scale_factor
Thread-Index: AddiYrm8zLygvZu2QZyi4sV0Rn+P7g==
Date: Wed, 16 Jun 2021 05:22:41 +0000
Deferred-Delivery: Wed, 16 Jun 2021 05:22:02 +0000
Message-ID: 
 <TYAPR01MB28965989AF84B57FC351B97BC40F9@TYAPR01MB2896.jpnprd01.prod.outlook.com>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?WXpFTGRGQ3RQQUpZRTl1V1lBS2tlbGFVY2Voa3IwcjRHVDNlMEFFMkdp?=
 =?iso-2022-jp?B?SjFhNDRoSC9sSHFNaElzOW5wcys1RStiWGx0VTZONlNkUXVPTzNvV3VP?=
 =?iso-2022-jp?B?VG0rdFpwOVFnWi8xcktVQW1aVFZLMjNCWDdXZlY4QmkyNktPamduakd4?=
 =?iso-2022-jp?B?MnM4UkoyNmJtU3V4ZDdQMEdSdGp5NHgvVjNkYkxna1JzTkJ0dEdYaU1x?=
 =?iso-2022-jp?B?OVRHcWoxNkFxdkdweTdyaXB1ZjlGb3ZadnlGVmdoUm0zMFU3STdQeWN4?=
 =?iso-2022-jp?B?V0tMdDdnbTA5QTg5OTZnWmcrenphWll3QWRtbWxBTENuTkFKVFN3ejZh?=
 =?iso-2022-jp?B?NkZNUmNvMkhHMW01K0ozWG1nVExtdEVIR3NYQ0c2U0Y1WVNITnJnZWpZ?=
 =?iso-2022-jp?B?K25YbzQyck5LMzdhQXJ5cmJGZVdmb2ptQlJ4NVRiUDBPQlJxR2F6RDcz?=
 =?iso-2022-jp?B?VURkZVM3a2RpdkpuTXRzTmd1Q0s1dml5M0k1YnBVVUpHMzdxU0UvUXRn?=
 =?iso-2022-jp?B?RThhMnBOSi9wcGEzd1RVSmI4LzQ2YUxGeWE1aU53dXllSGZSRmlTMm1r?=
 =?iso-2022-jp?B?bnZvS1d0aHdZaDBydzBNL2JFTFdPWnYvZGlpRm0vSnFFbEs1TWNVMkJ4?=
 =?iso-2022-jp?B?NTErNkw3TElPUzMyUVVsMk01cFl4M0VSSXJzc1RRVC9FQzJGYUpMTjVQ?=
 =?iso-2022-jp?B?Uk51YitXSVdlOGhqeXowYVBFdHkzSnI0czN5S3F2aVpBeUF3RFI2YitU?=
 =?iso-2022-jp?B?MlZWcEJMdzN5TjNod1VUdEl2ajI0d2MrdTRuK2tJdlZPbWlHWjhnWEww?=
 =?iso-2022-jp?B?b3pQdk83UGN4a3VRT2tyaU9tVU5DVEFLQzdCUE43NlYyTGJSeXhvQ2RU?=
 =?iso-2022-jp?B?QjdZbEQzbUJHTUpTV0hLbFZibTNLa1Ixeldpd0NDTmJPdElXdnZpSitL?=
 =?iso-2022-jp?B?YndxQ01UaEQyOUYrbkJoTVRCQ3ZNRGt6SDY3Z3M0ZEtXVmNIdkNkaDE1?=
 =?iso-2022-jp?B?N21tNXZZTUxNZlFuaHY2clBTZzZ2RWd4SWpORVI0Tmt1NVpnQ0pnRTJk?=
 =?iso-2022-jp?B?bFZLb05aaTBnSjlCanhGY1p5OVFUQ0NpbjRBSjhDektNS1phYUtRbWQ0?=
 =?iso-2022-jp?B?QnplZmtudHVwc2swYUF2Sml1MWFXYzljK3FpNUV0VFREc3VIRFA0MklB?=
 =?iso-2022-jp?B?OWN0a2p0THhrd3RrMVpIMjhYeHRnNlVMODZUd3c2ZnVBUVZSeHRHSkVM?=
 =?iso-2022-jp?B?OEhqSENabnhJZlNWRGpkQlk4eU9xNzlxamVxcjIveXpuc3JTMlNXbUNz?=
 =?iso-2022-jp?B?WjhGMTZybXhyL3FsOG9VYzd0bWFGSUROVTcrS2ROdDlIYWNDTkNsMzNx?=
 =?iso-2022-jp?B?YVZYazN0WEk3TzRNQ3plTTVpZDJwT0Vmd2F0RzEzaVl5djNoMmhjUzQz?=
 =?iso-2022-jp?B?QnM2bmlSU0lZYS9ZYnhUcWJaSzgrYk5aVllOYXFPOXJvQmt5VEZhaFhJ?=
 =?iso-2022-jp?B?VHllenBhd3RMMzlqL0tndUQ4Ync0VE9tUTdaUVRnQ2IxQ1NBY3RFQ001?=
 =?iso-2022-jp?B?Z3ZoRFJyc2NJVkRjQVR1OWtJbThTOC9QeWs3dXhvU3RwU21UbXloRkpw?=
 =?iso-2022-jp?B?eHhsNFMvKzE4Qzl4MUtKaWEyZzF0dzhFT282YlpZd0ZXZnlUUGxYQ3Jr?=
 =?iso-2022-jp?B?OSt5ZzdWNDU4YjFlbUJZSDFmN1RKL3ZCVFZpSkN0UFFnRElCekxEYkx5?=
 =?iso-2022-jp?B?ZHRMaXprYWFBdFUyODluemVJME1YcTV5eFhZVHkwNGptaHd4UXMrSHJi?=
 =?iso-2022-jp?B?b3c5bDlkenVzYkovalVzM2JIT0xwdmk3MHZBbDNYTUluZHoyeUhEZ0VM?=
 =?iso-2022-jp?B?bVMvWDEwblZYcGlnejlpTlFta2htSy95VGJ4YUNjMSszSWtsNWNnbkxQ?=
x-ms-exchange-transport-forked: True
Content-Type: multipart/mixed;
	boundary="_002_TYAPR01MB28965989AF84B57FC351B97BC40F9TYAPR01MB2896jpnp_"
MIME-Version: 1.0
X-OriginatorOrg: jp.nttdata.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: TYAPR01MB2896.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 afdb8a9b-cad2-4c95-93e5-08d93086cce5
X-MS-Exchange-CrossTenant-originalarrivaltime: 16 Jun 2021 05:22:55.0286
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 1fcf450d-bb71-4efd-ae5d-90c7be757e12
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 J6mGgl4h/VbWSSUPJY+On+cF4qY9pXhfILjuadHwZG3XLSXQh2EJxss5iyuZBsE3vyuMY8+ucCt4tsEYQhyJXBtfHv756/LLirrAoDrkyxI=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYAPR01MB3550
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.136,Aquarius:18.0.761,Hydra:6.0.391,FMLib:17.0.607.475
 definitions=2021-06-15_09,2021-06-15_02,2020-04-07_01
X-Proofpoint-Spam-spam_all_notspam: 1
X-Proofpoint-GUID: pytjOu-VOWdv6GvZbzYNdcYEDqhyHHop
X-Proofpoint-ORIG-GUID: pytjOu-VOWdv6GvZbzYNdcYEDqhyHHop
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.391,18.0.761
 definitions=2021-06-15_09:2021-06-15,2021-06-15 signatures=0
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 adultscore=0
 priorityscore=1501
 clxscore=1015 suspectscore=0 phishscore=0 spamscore=0 lowpriorityscore=0
 bulkscore=0 mlxlogscore=999 impostorscore=0 malwarescore=0 mlxscore=0
 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2104190000
 definitions=main-2106160032
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/TYAPR01MB28965989AF84B57FC351B97BC40F9%40TYAPR01MB2896.jpnprd01.prod.outlook.com>
Precedence: bulk

--_002_TYAPR01MB28965989AF84B57FC351B97BC40F9TYAPR01MB2896jpnp_
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

Hi

As shown below, the argument types of autovacuum_vacuum_insert_scale_factor=
 and toast.autovacuum_vacuum_insert_scale_factor are different from the oth=
ers.
---
autovacuum_vacuum_scale_factor, toast.autovacuum_vacuum_scale_factor (float=
ing point)
autovacuum_vacuum_insert_scale_factor, toast.autovacuum_vacuum_insert_scale=
_factor (float4)
autovacuum_analyze_scale_factor (floating point)
autovacuum_vacuum_cost_delay, toast.autovacuum_vacuum_cost_delay (floating =
point)
https://www.postgresql.org/docs/devel/sql-createtable.html
---

In addition, there is this statement.
---
autovacuum_vacuum_insert_scale_factor (floating point)
https://www.postgresql.org/docs/devel/runtime-config-autovacuum.html#GUC-AU=
TOVACUUM-VACUUM-INSERT-SCALE-FACTOR
---

So, I thought it was better to be consistent with "floating point", and I c=
reated the patch.

A similar argument can be found here.=20
https://www.postgresql.org/message-id/CACZ0uYFf_p9BpbjLccx3CA=3DeM1Hk2Te=3D=
ULY4iptGLUhL-JxCPA@mail.gmail.com

Best Regards,
Shinya Kato

--_002_TYAPR01MB28965989AF84B57FC351B97BC40F9TYAPR01MB2896jpnp_
Content-Type: application/octet-stream;
	name="change_float4_to_floating_point.patch"
Content-Description: change_float4_to_floating_point.patch
Content-Disposition: attachment;
	filename="change_float4_to_floating_point.patch"; size=913;
	creation-date="Wed, 16 Jun 2021 03:50:00 GMT";
	modification-date="Wed, 16 Jun 2021 03:50:00 GMT"
Content-Transfer-Encoding: base64

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwgYi9kb2Mvc3Jj
L3NnbWwvcmVmL2NyZWF0ZV90YWJsZS5zZ21sCmluZGV4IGM2ZDBhMzVlNTAuLjY1ZDNhMzNhYzkg
MTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9yZWYvY3JlYXRlX3RhYmxlLnNnbWwKKysrIGIvZG9j
L3NyYy9zZ21sL3JlZi9jcmVhdGVfdGFibGUuc2dtbApAQCAtMTU1OCw3ICsxNTU4LDcgQEAgV0lU
SCAoIE1PRFVMVVMgPHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPm51bWVyaWNfbGl0ZXJh
bDwvcmVwbGFjZWFibGU+LCBSRU0KICAgIDwvdmFybGlzdGVudHJ5PgogCiAgICA8dmFybGlzdGVu
dHJ5IGlkPSJyZWxvcHRpb24tYXV0b3ZhY3V1bS12YWN1dW0taW5zZXJ0LXNjYWxlLWZhY3RvciIg
eHJlZmxhYmVsPSJhdXRvdmFjdXVtX3ZhY3V1bV9pbnNlcnRfc2NhbGVfZmFjdG9yIj4KLSAgICA8
dGVybT48bGl0ZXJhbD5hdXRvdmFjdXVtX3ZhY3V1bV9pbnNlcnRfc2NhbGVfZmFjdG9yPC9saXRl
cmFsPiwgPGxpdGVyYWw+dG9hc3QuYXV0b3ZhY3V1bV92YWN1dW1faW5zZXJ0X3NjYWxlX2ZhY3Rv
cjwvbGl0ZXJhbD4gKDx0eXBlPmZsb2F0NDwvdHlwZT4pCisgICAgPHRlcm0+PGxpdGVyYWw+YXV0
b3ZhY3V1bV92YWN1dW1faW5zZXJ0X3NjYWxlX2ZhY3RvcjwvbGl0ZXJhbD4sIDxsaXRlcmFsPnRv
YXN0LmF1dG92YWN1dW1fdmFjdXVtX2luc2VydF9zY2FsZV9mYWN0b3I8L2xpdGVyYWw+ICg8dHlw
ZT5mbG9hdGluZyBwb2ludDwvdHlwZT4pCiAgICAgPGluZGV4dGVybT4KICAgICAgPHByaW1hcnk+
PHZhcm5hbWU+YXV0b3ZhY3V1bV92YWN1dW1faW5zZXJ0X3NjYWxlX2ZhY3RvcjwvdmFybmFtZT4g
PC9wcmltYXJ5PgogICAgICA8c2Vjb25kYXJ5PnN0b3JhZ2UgcGFyYW1ldGVyPC9zZWNvbmRhcnk+
Cg==

--_002_TYAPR01MB28965989AF84B57FC351B97BC40F9TYAPR01MB2896jpnp_--