Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srgMA-003lUC-MZ for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 16:19:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1srgM8-009K6i-Mz for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 16:19:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srgM8-009K6N-4x for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 16:19:41 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srgM5-000CRe-H4 for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 16:19:40 +0000 Received: from [192.168.11.4] (p3534201-ipxg13101funabasi.chiba.ocn.ne.jp [60.37.171.201]) by oss.nttdata.com (Postfix) with ESMTPSA id B0E7960605; Sat, 21 Sep 2024 01:19:32 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.103.11 at oss.nttdata.com Content-Type: multipart/mixed; boundary="------------JE2WaQ3lsMLhwf3gczswfhgc" Message-ID: <4640258e-d959-4cf0-903c-cd02389c3e05@oss.nttdata.com> Date: Sat, 21 Sep 2024 01:19:32 +0900 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: May be BUG. Periodic burst growth of the checkpoint_req counter on replica. Content-Language: en-US To: "Anton A. Melnikov" , Alexander Korotkov Cc: Magnus Hagander , "Anton A. Melnikov" , Andres Freund , Kyotaro Horiguchi , pgsql-hackers@lists.postgresql.org References: <99b2ccd1-a77a-962a-0837-191cdf56c2b9@inbox.ru> <7bd1c12b-4219-45bf-88a6-8cacd008dfdc@postgrespro.ru> <3ed0590b-8132-482e-a9e6-bd694e4a48d7@postgrespro.ru> <9ea77f40-818d-4841-9dee-158ac8f6e690@oss.nttdata.com> <77032579-4dc3-4552-9a09-30aaa114c144@postgrespro.ru> <206e58c1-d8f6-4ac3-8f40-7e4c17459473@oss.nttdata.com> <82f03b0b-00c6-42b4-95c7-f2eca7fed1ea@oss.nttdata.com> From: Fujii Masao In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------JE2WaQ3lsMLhwf3gczswfhgc Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 2024/09/19 19:16, Anton A. Melnikov wrote: > > On 18.09.2024 21:04, Fujii Masao wrote: >> >> -                CreateCheckPoint(flags); >> -                ckpt_performed = true; >> +                ckpt_performed = CreateCheckPoint(flags); >> >> This change could result in the next scheduled checkpoint being >> triggered in 15 seconds if a checkpoint is skipped, which isn’t >> the intended behavior. > > Thanks for pointing this out! This is really bug. > Rearranged the logic a bit to save the previous behavior > in the v3 attached. Thanks for updating the patch! I've attached the updated version (0001.patch). I made some cosmetic changes, including reverting the switch in the entries for pg_stat_get_checkpointer_write_time and pg_stat_get_checkpointer_sync_time in pg_proc.dat, as I didn’t think that change was necessary. Could you please review the latest version? After we commit 0001.patch, how about applying 0002.patch, which updates the documentation for the pg_stat_checkpointer view to clarify what types of checkpoints and restartpoints each counter tracks? In 0002.patch, I also modified the description of num_requested from "Number of backend requested checkpoints" to remove "backend," as it can be confusing since num_requested includes requests from sources other than the backend. Thought? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION --------------JE2WaQ3lsMLhwf3gczswfhgc Content-Type: text/plain; charset=UTF-8; name="v4-0001-Add-num_done-counter-to-the-pg_stat_checkpointer-.patch" Content-Disposition: attachment; filename*0="v4-0001-Add-num_done-counter-to-the-pg_stat_checkpointer-.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSA4NTlmM2ZlY2I0ZmI0OTAwYjZjZTEyZjYzNDZjNWQ5NTY1ZmJjMDcyIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IEZyaSwgMjAgU2VwIDIwMjQgMTE6MzM6MDcgKzA5MDAKU3ViamVjdDogW1BB VENIIHY0IDEvMl0gQWRkIG51bV9kb25lIGNvdW50ZXIgdG8gdGhlIHBnX3N0YXRfY2hlY2tw b2ludGVyIHZpZXcuCgpDaGVja3BvaW50cyBjYW4gYmUgc2tpcHBlZCB3aGVuIHRoZSBzZXJ2 ZXIgaXMgaWRsZS4gVGhlIGV4aXN0aW5nIG51bV90aW1lZCBhbmQKbnVtX3JlcXVlc3RlZCBj b3VudGVycyBpbiBwZ19zdGF0X2NoZWNrcG9pbnRlciB0cmFjayBib3RoIGNvbXBsZXRlZCBh bmQKc2tpcHBlZCBjaGVja3BvaW50cywgYnV0IHRoZXJlIHdhcyBubyB3YXkgdG8gY291bnQg b25seSB0aGUgY29tcGxldGVkIG9uZXMuCgpUaGlzIGNvbW1pdCBpbnRyb2R1Y2VzIHRoZSBu dW1fZG9uZSBjb3VudGVyLCB3aGljaCB0cmFja3Mgb25seSBjb21wbGV0ZWQKY2hlY2twb2lu dHMsIG1ha2luZyBpdCBlYXNpZXIgdG8gc2VlIGhvdyBtYW55IHdlcmUgYWN0dWFsbHkgcGVy Zm9ybWVkLgoKQnVtcCBjYXRhbG9nIHZlcnNpb24uCgpBdXRob3I6IEFudG9uIEEuIE1lbG5p a292ClJldmlld2VkLWJ5OiBGdWppaSBNYXNhbwpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tLzllYTc3ZjQwLTgxOGQtNDg0MS05ZGVlLTE1OGFjOGY2ZTY5MEBvc3MubnR0ZGF0 YS5jb20KLS0tCiBkb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21sICAgICAgICAgICAgICAg ICAgfCAxMSArKysrKy0KIHNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyAgICAg ICAgICAgICB8ICA5ICsrKystCiBzcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV92aWV3cy5z cWwgICAgICAgICAgfCAgMSArCiBzcmMvYmFja2VuZC9wb3N0bWFzdGVyL2NoZWNrcG9pbnRl ci5jICAgICAgICAgfCAzOSArKysrKysrKysrKystLS0tLS0tCiAuLi4vdXRpbHMvYWN0aXZp dHkvcGdzdGF0X2NoZWNrcG9pbnRlci5jICAgICAgfCAgMiArCiBzcmMvYmFja2VuZC91dGls cy9hZHQvcGdzdGF0ZnVuY3MuYyAgICAgICAgICAgfCAgNiArKysKIHNyYy9pbmNsdWRlL2Fj Y2Vzcy94bG9nLmggICAgICAgICAgICAgICAgICAgICB8ICAyICstCiBzcmMvaW5jbHVkZS9j YXRhbG9nL3BnX3Byb2MuZGF0ICAgICAgICAgICAgICAgfCAgNiArKysKIHNyYy9pbmNsdWRl L3Bnc3RhdC5oICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAxICsKIHNyYy90ZXN0L3Jl Z3Jlc3MvZXhwZWN0ZWQvcnVsZXMub3V0ICAgICAgICAgICB8ICAxICsKIDEwIGZpbGVzIGNo YW5nZWQsIDYwIGluc2VydGlvbnMoKyksIDE4IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBh L2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmlu Zy5zZ21sCmluZGV4IGEyZmRhNDY3N2QuLjE5YmYwMTY0ZjEgMTAwNjQ0Ci0tLSBhL2RvYy9z cmMvc2dtbC9tb25pdG9yaW5nLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcu c2dtbApAQCAtMzA2Myw3ICszMDYzLDE2IEBAIGRlc2NyaXB0aW9uIHwgV2FpdGluZyBmb3Ig YSBuZXdseSBpbml0aWFsaXplZCBXQUwgZmlsZSB0byByZWFjaCBkdXJhYmxlIHN0b3JhZ2UK ICAgICAgICA8c3RydWN0ZmllbGQ+bnVtX3JlcXVlc3RlZDwvc3RydWN0ZmllbGQ+IDx0eXBl PmJpZ2ludDwvdHlwZT4KICAgICAgIDwvcGFyYT4KICAgICAgIDxwYXJhPgotICAgICAgIE51 bWJlciBvZiByZXF1ZXN0ZWQgY2hlY2twb2ludHMgdGhhdCBoYXZlIGJlZW4gcGVyZm9ybWVk CisgICAgICAgTnVtYmVyIG9mIGJhY2tlbmQgcmVxdWVzdGVkIGNoZWNrcG9pbnRzCisgICAg ICA8L3BhcmE+PC9lbnRyeT4KKyAgICAgPC9yb3c+CisKKyAgICAgIDxyb3c+CisgICAgICA8 ZW50cnkgcm9sZT0iY2F0YWxvZ190YWJsZV9lbnRyeSI+PHBhcmEgcm9sZT0iY29sdW1uX2Rl ZmluaXRpb24iPgorICAgICAgIDxzdHJ1Y3RmaWVsZD5udW1fZG9uZTwvc3RydWN0ZmllbGQ+ IDx0eXBlPmJpZ2ludDwvdHlwZT4KKyAgICAgIDwvcGFyYT4KKyAgICAgIDxwYXJhPgorICAg ICAgIE51bWJlciBvZiBjaGVja3BvaW50cyB0aGF0IGhhdmUgYmVlbiBwZXJmb3JtZWQKICAg ICAgIDwvcGFyYT48L2VudHJ5PgogICAgICA8L3Jvdz4KIApkaWZmIC0tZ2l0IGEvc3JjL2Jh Y2tlbmQvYWNjZXNzL3RyYW5zYW0veGxvZy5jIGIvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5z YW0veGxvZy5jCmluZGV4IDg1M2FiMDY4MTIuLjY0MzA0ZDc3ZDMgMTAwNjQ0Ci0tLSBhL3Ny Yy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYworKysgYi9zcmMvYmFja2VuZC9hY2Nl c3MvdHJhbnNhbS94bG9nLmMKQEAgLTY4NzgsOCArNjg3OCwxMSBAQCB1cGRhdGVfY2hlY2tw b2ludF9kaXNwbGF5KGludCBmbGFncywgYm9vbCByZXN0YXJ0cG9pbnQsIGJvb2wgcmVzZXQp CiAgKiBJbiB0aGlzIGNhc2UsIHdlIG9ubHkgaW5zZXJ0IGFuIFhMT0dfQ0hFQ0tQT0lOVF9T SFVURE9XTiByZWNvcmQsIGFuZCBpdCdzCiAgKiBib3RoIHRoZSByZWNvcmQgbWFya2luZyB0 aGUgY29tcGxldGlvbiBvZiB0aGUgY2hlY2twb2ludCBhbmQgdGhlIGxvY2F0aW9uCiAgKiBm cm9tIHdoaWNoIFdBTCByZXBsYXkgd291bGQgYmVnaW4gaWYgbmVlZGVkLgorICoKKyAqIFJl dHVybnMgdHJ1ZSBpZiBhIG5ldyBjaGVja3BvaW50IHdhcyBwZXJmb3JtZWQsIG9yIGZhbHNl IGlmIGl0IHdhcyBza2lwcGVkCisgKiBiZWNhdXNlIHRoZSBzeXN0ZW0gd2FzIGlkbGUuCiAg Ki8KLXZvaWQKK2Jvb2wKIENyZWF0ZUNoZWNrUG9pbnQoaW50IGZsYWdzKQogewogCWJvb2wJ CXNodXRkb3duOwpAQCAtNjk3MSw3ICs2OTc0LDcgQEAgQ3JlYXRlQ2hlY2tQb2ludChpbnQg ZmxhZ3MpCiAJCQlFTkRfQ1JJVF9TRUNUSU9OKCk7CiAJCQllcmVwb3J0KERFQlVHMSwKIAkJ CQkJKGVycm1zZ19pbnRlcm5hbCgiY2hlY2twb2ludCBza2lwcGVkIGJlY2F1c2Ugc3lzdGVt IGlzIGlkbGUiKSkpOwotCQkJcmV0dXJuOworCQkJcmV0dXJuIGZhbHNlOwogCQl9CiAJfQog CkBAIC03MzUzLDYgKzczNTYsOCBAQCBDcmVhdGVDaGVja1BvaW50KGludCBmbGFncykKIAkJ CQkJCQkJCSBDaGVja3BvaW50U3RhdHMuY2twdF9zZWdzX2FkZGVkLAogCQkJCQkJCQkJIENo ZWNrcG9pbnRTdGF0cy5ja3B0X3NlZ3NfcmVtb3ZlZCwKIAkJCQkJCQkJCSBDaGVja3BvaW50 U3RhdHMuY2twdF9zZWdzX3JlY3ljbGVkKTsKKworCXJldHVybiB0cnVlOwogfQogCiAvKgpk aWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsIGIvc3Jj L2JhY2tlbmQvY2F0YWxvZy9zeXN0ZW1fdmlld3Muc3FsCmluZGV4IDdmZDVkMjU2YTEuLjQ5 MTA5ZGJkYzggMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL2NhdGFsb2cvc3lzdGVtX3ZpZXdz LnNxbAorKysgYi9zcmMvYmFja2VuZC9jYXRhbG9nL3N5c3RlbV92aWV3cy5zcWwKQEAgLTEx MzgsNiArMTEzOCw3IEBAIENSRUFURSBWSUVXIHBnX3N0YXRfY2hlY2twb2ludGVyIEFTCiAg ICAgU0VMRUNUCiAgICAgICAgIHBnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9udW1fdGltZWQo KSBBUyBudW1fdGltZWQsCiAgICAgICAgIHBnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9udW1f cmVxdWVzdGVkKCkgQVMgbnVtX3JlcXVlc3RlZCwKKyAgICAgICAgcGdfc3RhdF9nZXRfY2hl Y2twb2ludGVyX251bV9wZXJmb3JtZWQoKSBBUyBudW1fZG9uZSwKICAgICAgICAgcGdfc3Rh dF9nZXRfY2hlY2twb2ludGVyX3Jlc3RhcnRwb2ludHNfdGltZWQoKSBBUyByZXN0YXJ0cG9p bnRzX3RpbWVkLAogICAgICAgICBwZ19zdGF0X2dldF9jaGVja3BvaW50ZXJfcmVzdGFydHBv aW50c19yZXF1ZXN0ZWQoKSBBUyByZXN0YXJ0cG9pbnRzX3JlcSwKICAgICAgICAgcGdfc3Rh dF9nZXRfY2hlY2twb2ludGVyX3Jlc3RhcnRwb2ludHNfcGVyZm9ybWVkKCkgQVMgcmVzdGFy dHBvaW50c19kb25lLApkaWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9jaGVj a3BvaW50ZXIuYyBiL3NyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvY2hlY2twb2ludGVyLmMKaW5k ZXggZWViNzNjODU3Mi4uOTA4N2UzZjhkYiAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvcG9z dG1hc3Rlci9jaGVja3BvaW50ZXIuYworKysgYi9zcmMvYmFja2VuZC9wb3N0bWFzdGVyL2No ZWNrcG9pbnRlci5jCkBAIC00NjAsMTAgKzQ2MCw3IEBAIENoZWNrcG9pbnRlck1haW4oY2hh ciAqc3RhcnR1cF9kYXRhLCBzaXplX3Qgc3RhcnR1cF9kYXRhX2xlbikKIAkJCSAqIERvIHRo ZSBjaGVja3BvaW50LgogCQkJICovCiAJCQlpZiAoIWRvX3Jlc3RhcnRwb2ludCkKLQkJCXsK LQkJCQlDcmVhdGVDaGVja1BvaW50KGZsYWdzKTsKLQkJCQlja3B0X3BlcmZvcm1lZCA9IHRy dWU7Ci0JCQl9CisJCQkJY2twdF9wZXJmb3JtZWQgPSBDcmVhdGVDaGVja1BvaW50KGZsYWdz KTsKIAkJCWVsc2UKIAkJCQlja3B0X3BlcmZvcm1lZCA9IENyZWF0ZVJlc3RhcnRQb2ludChm bGFncyk7CiAKQEAgLTQ4NCw3ICs0ODEsNyBAQCBDaGVja3BvaW50ZXJNYWluKGNoYXIgKnN0 YXJ0dXBfZGF0YSwgc2l6ZV90IHN0YXJ0dXBfZGF0YV9sZW4pCiAKIAkJCUNvbmRpdGlvblZh cmlhYmxlQnJvYWRjYXN0KCZDaGVja3BvaW50ZXJTaG1lbS0+ZG9uZV9jdik7CiAKLQkJCWlm IChja3B0X3BlcmZvcm1lZCkKKwkJCWlmICghZG9fcmVzdGFydHBvaW50KQogCQkJewogCQkJ CS8qCiAJCQkJICogTm90ZSB3ZSByZWNvcmQgdGhlIGNoZWNrcG9pbnQgc3RhcnQgdGltZSBu b3QgZW5kIHRpbWUgYXMKQEAgLTQ5MywxOCArNDkwLDMyIEBAIENoZWNrcG9pbnRlck1haW4o Y2hhciAqc3RhcnR1cF9kYXRhLCBzaXplX3Qgc3RhcnR1cF9kYXRhX2xlbikKIAkJCQkgKi8K IAkJCQlsYXN0X2NoZWNrcG9pbnRfdGltZSA9IG5vdzsKIAotCQkJCWlmIChkb19yZXN0YXJ0 cG9pbnQpCi0JCQkJCVBlbmRpbmdDaGVja3BvaW50ZXJTdGF0cy5yZXN0YXJ0cG9pbnRzX3Bl cmZvcm1lZCsrOworCQkJCWlmIChja3B0X3BlcmZvcm1lZCkKKwkJCQkJUGVuZGluZ0NoZWNr cG9pbnRlclN0YXRzLm51bV9wZXJmb3JtZWQrKzsKIAkJCX0KIAkJCWVsc2UKIAkJCXsKLQkJ CQkvKgotCQkJCSAqIFdlIHdlcmUgbm90IGFibGUgdG8gcGVyZm9ybSB0aGUgcmVzdGFydHBv aW50IChjaGVja3BvaW50cwotCQkJCSAqIHRocm93IGFuIEVSUk9SIGluIGNhc2Ugb2YgZXJy b3IpLiAgTW9zdCBsaWtlbHkgYmVjYXVzZSB3ZQotCQkJCSAqIGhhdmUgbm90IHJlY2VpdmVk IGFueSBuZXcgY2hlY2twb2ludCBXQUwgcmVjb3JkcyBzaW5jZSB0aGUKLQkJCQkgKiBsYXN0 IHJlc3RhcnRwb2ludC4gVHJ5IGFnYWluIGluIDE1IHMuCi0JCQkJICovCi0JCQkJbGFzdF9j aGVja3BvaW50X3RpbWUgPSBub3cgLSBDaGVja1BvaW50VGltZW91dCArIDE1OworCQkJCWlm IChja3B0X3BlcmZvcm1lZCkKKwkJCQl7CisJCQkJCS8qCisJCQkJCSAqIFRoZSBzYW1lIGFz IGZvciBjaGVja3BvaW50LiBQbGVhc2Ugc2VlIHRoZQorCQkJCQkgKiBjb3JyZXNwb25kaW5n IGNvbW1lbnQuCisJCQkJCSAqLworCQkJCQlsYXN0X2NoZWNrcG9pbnRfdGltZSA9IG5vdzsK KworCQkJCQlQZW5kaW5nQ2hlY2twb2ludGVyU3RhdHMucmVzdGFydHBvaW50c19wZXJmb3Jt ZWQrKzsKKwkJCQl9CisJCQkJZWxzZQorCQkJCXsKKwkJCQkJLyoKKwkJCQkJICogV2Ugd2Vy ZSBub3QgYWJsZSB0byBwZXJmb3JtIHRoZSByZXN0YXJ0cG9pbnQKKwkJCQkJICogKGNoZWNr cG9pbnRzIHRocm93IGFuIEVSUk9SIGluIGNhc2Ugb2YgZXJyb3IpLiAgTW9zdAorCQkJCQkg KiBsaWtlbHkgYmVjYXVzZSB3ZSBoYXZlIG5vdCByZWNlaXZlZCBhbnkgbmV3IGNoZWNrcG9p bnQKKwkJCQkJICogV0FMIHJlY29yZHMgc2luY2UgdGhlIGxhc3QgcmVzdGFydHBvaW50LiBU cnkgYWdhaW4gaW4KKwkJCQkJICogMTUgcy4KKwkJCQkJICovCisJCQkJCWxhc3RfY2hlY2tw b2ludF90aW1lID0gbm93IC0gQ2hlY2tQb2ludFRpbWVvdXQgKyAxNTsKKwkJCQl9CiAJCQl9 CiAKIAkJCWNrcHRfYWN0aXZlID0gZmFsc2U7CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91 dGlscy9hY3Rpdml0eS9wZ3N0YXRfY2hlY2twb2ludGVyLmMgYi9zcmMvYmFja2VuZC91dGls cy9hY3Rpdml0eS9wZ3N0YXRfY2hlY2twb2ludGVyLmMKaW5kZXggYmJmYzljN2UxOC4uNGEw YTJkMTQ5MyAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvdXRpbHMvYWN0aXZpdHkvcGdzdGF0 X2NoZWNrcG9pbnRlci5jCisrKyBiL3NyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3Bnc3Rh dF9jaGVja3BvaW50ZXIuYwpAQCAtNDksNiArNDksNyBAQCBwZ3N0YXRfcmVwb3J0X2NoZWNr cG9pbnRlcih2b2lkKQogI2RlZmluZSBDSEVDS1BPSU5URVJfQUNDKGZsZCkgc3RhdHNfc2ht ZW0tPnN0YXRzLmZsZCArPSBQZW5kaW5nQ2hlY2twb2ludGVyU3RhdHMuZmxkCiAJQ0hFQ0tQ T0lOVEVSX0FDQyhudW1fdGltZWQpOwogCUNIRUNLUE9JTlRFUl9BQ0MobnVtX3JlcXVlc3Rl ZCk7CisJQ0hFQ0tQT0lOVEVSX0FDQyhudW1fcGVyZm9ybWVkKTsKIAlDSEVDS1BPSU5URVJf QUNDKHJlc3RhcnRwb2ludHNfdGltZWQpOwogCUNIRUNLUE9JTlRFUl9BQ0MocmVzdGFydHBv aW50c19yZXF1ZXN0ZWQpOwogCUNIRUNLUE9JTlRFUl9BQ0MocmVzdGFydHBvaW50c19wZXJm b3JtZWQpOwpAQCAtMTI3LDYgKzEyOCw3IEBAIHBnc3RhdF9jaGVja3BvaW50ZXJfc25hcHNo b3RfY2Iodm9pZCkKICNkZWZpbmUgQ0hFQ0tQT0lOVEVSX0NPTVAoZmxkKSBwZ1N0YXRMb2Nh bC5zbmFwc2hvdC5jaGVja3BvaW50ZXIuZmxkIC09IHJlc2V0LmZsZDsKIAlDSEVDS1BPSU5U RVJfQ09NUChudW1fdGltZWQpOwogCUNIRUNLUE9JTlRFUl9DT01QKG51bV9yZXF1ZXN0ZWQp OworCUNIRUNLUE9JTlRFUl9DT01QKG51bV9wZXJmb3JtZWQpOwogCUNIRUNLUE9JTlRFUl9D T01QKHJlc3RhcnRwb2ludHNfdGltZWQpOwogCUNIRUNLUE9JTlRFUl9DT01QKHJlc3RhcnRw b2ludHNfcmVxdWVzdGVkKTsKIAlDSEVDS1BPSU5URVJfQ09NUChyZXN0YXJ0cG9pbnRzX3Bl cmZvcm1lZCk7CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9hZHQvcGdzdGF0ZnVu Y3MuYyBiL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9wZ3N0YXRmdW5jcy5jCmluZGV4IDljMjNh YzdjOGMuLjE3YjBmYzAyZWYgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9w Z3N0YXRmdW5jcy5jCisrKyBiL3NyYy9iYWNrZW5kL3V0aWxzL2FkdC9wZ3N0YXRmdW5jcy5j CkBAIC0xMTkxLDYgKzExOTEsMTIgQEAgcGdfc3RhdF9nZXRfY2hlY2twb2ludGVyX251bV9y ZXF1ZXN0ZWQoUEdfRlVOQ1RJT05fQVJHUykKIAlQR19SRVRVUk5fSU5UNjQocGdzdGF0X2Zl dGNoX3N0YXRfY2hlY2twb2ludGVyKCktPm51bV9yZXF1ZXN0ZWQpOwogfQogCitEYXR1bQor cGdfc3RhdF9nZXRfY2hlY2twb2ludGVyX251bV9wZXJmb3JtZWQoUEdfRlVOQ1RJT05fQVJH UykKK3sKKwlQR19SRVRVUk5fSU5UNjQocGdzdGF0X2ZldGNoX3N0YXRfY2hlY2twb2ludGVy KCktPm51bV9wZXJmb3JtZWQpOworfQorCiBEYXR1bQogcGdfc3RhdF9nZXRfY2hlY2twb2lu dGVyX3Jlc3RhcnRwb2ludHNfdGltZWQoUEdfRlVOQ1RJT05fQVJHUykKIHsKZGlmZiAtLWdp dCBhL3NyYy9pbmNsdWRlL2FjY2Vzcy94bG9nLmggYi9zcmMvaW5jbHVkZS9hY2Nlc3MveGxv Zy5oCmluZGV4IDA4MzgxMGY1YjQuLjM2ZjZlNGU0YjQgMTAwNjQ0Ci0tLSBhL3NyYy9pbmNs dWRlL2FjY2Vzcy94bG9nLmgKKysrIGIvc3JjL2luY2x1ZGUvYWNjZXNzL3hsb2cuaApAQCAt MjM5LDcgKzIzOSw3IEBAIGV4dGVybiB2b2lkIExvY2FsUHJvY2Vzc0NvbnRyb2xGaWxlKGJv b2wgcmVzZXQpOwogZXh0ZXJuIFdhbExldmVsIEdldEFjdGl2ZVdhbExldmVsT25TdGFuZGJ5 KHZvaWQpOwogZXh0ZXJuIHZvaWQgU3RhcnR1cFhMT0codm9pZCk7CiBleHRlcm4gdm9pZCBT aHV0ZG93blhMT0coaW50IGNvZGUsIERhdHVtIGFyZyk7Ci1leHRlcm4gdm9pZCBDcmVhdGVD aGVja1BvaW50KGludCBmbGFncyk7CitleHRlcm4gYm9vbCBDcmVhdGVDaGVja1BvaW50KGlu dCBmbGFncyk7CiBleHRlcm4gYm9vbCBDcmVhdGVSZXN0YXJ0UG9pbnQoaW50IGZsYWdzKTsK IGV4dGVybiBXQUxBdmFpbGFiaWxpdHkgR2V0V0FMQXZhaWxhYmlsaXR5KFhMb2dSZWNQdHIg dGFyZ2V0TFNOKTsKIGV4dGVybiB2b2lkIFhMb2dQdXROZXh0T2lkKE9pZCBuZXh0T2lkKTsK ZGlmZiAtLWdpdCBhL3NyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQgYi9zcmMvaW5j bHVkZS9jYXRhbG9nL3BnX3Byb2MuZGF0CmluZGV4IDQzZjYwOGQ3YTAuLjUyZmNhNTRmM2Eg MTAwNjQ0Ci0tLSBhL3NyYy9pbmNsdWRlL2NhdGFsb2cvcGdfcHJvYy5kYXQKKysrIGIvc3Jj L2luY2x1ZGUvY2F0YWxvZy9wZ19wcm9jLmRhdApAQCAtNTgxNyw2ICs1ODE3LDEyIEBACiAg IHByb25hbWUgPT4gJ3BnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9udW1fcmVxdWVzdGVkJywg cHJvdm9sYXRpbGUgPT4gJ3MnLAogICBwcm9wYXJhbGxlbCA9PiAncicsIHByb3JldHR5cGUg PT4gJ2ludDgnLCBwcm9hcmd0eXBlcyA9PiAnJywKICAgcHJvc3JjID0+ICdwZ19zdGF0X2dl dF9jaGVja3BvaW50ZXJfbnVtX3JlcXVlc3RlZCcgfSwKK3sgb2lkID0+ICcyNzc1JywKKyAg ZGVzY3IgPT4gJ3N0YXRpc3RpY3M6IG51bWJlciBvZiBjaGVja3BvaW50cyBwZXJmb3JtZWQg YnkgdGhlIGNoZWNrcG9pbnRlcicsCisgIHByb25hbWUgPT4gJ3BnX3N0YXRfZ2V0X2NoZWNr cG9pbnRlcl9udW1fcGVyZm9ybWVkJywKKyAgcHJvdm9sYXRpbGUgPT4gJ3MnLCBwcm9wYXJh bGxlbCA9PiAncicsIHByb3JldHR5cGUgPT4gJ2ludDgnLAorICBwcm9hcmd0eXBlcyA9PiAn JywKKyAgcHJvc3JjID0+ICdwZ19zdGF0X2dldF9jaGVja3BvaW50ZXJfbnVtX3BlcmZvcm1l ZCcgfSwKIHsgb2lkID0+ICc2MzI3JywKICAgZGVzY3IgPT4gJ3N0YXRpc3RpY3M6IG51bWJl ciBvZiB0aW1lZCByZXN0YXJ0cG9pbnRzIHN0YXJ0ZWQgYnkgdGhlIGNoZWNrcG9pbnRlcics CiAgIHByb25hbWUgPT4gJ3BnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9yZXN0YXJ0cG9pbnRz X3RpbWVkJywgcHJvdm9sYXRpbGUgPT4gJ3MnLApkaWZmIC0tZ2l0IGEvc3JjL2luY2x1ZGUv cGdzdGF0LmggYi9zcmMvaW5jbHVkZS9wZ3N0YXQuaAppbmRleCA0NzUyZGZlNzE5Li40NzZh Y2Q2ODBjIDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS9wZ3N0YXQuaAorKysgYi9zcmMvaW5j bHVkZS9wZ3N0YXQuaApAQCAtMjk0LDYgKzI5NCw3IEBAIHR5cGVkZWYgc3RydWN0IFBnU3Rh dF9DaGVja3BvaW50ZXJTdGF0cwogewogCVBnU3RhdF9Db3VudGVyIG51bV90aW1lZDsKIAlQ Z1N0YXRfQ291bnRlciBudW1fcmVxdWVzdGVkOworCVBnU3RhdF9Db3VudGVyIG51bV9wZXJm b3JtZWQ7CiAJUGdTdGF0X0NvdW50ZXIgcmVzdGFydHBvaW50c190aW1lZDsKIAlQZ1N0YXRf Q291bnRlciByZXN0YXJ0cG9pbnRzX3JlcXVlc3RlZDsKIAlQZ1N0YXRfQ291bnRlciByZXN0 YXJ0cG9pbnRzX3BlcmZvcm1lZDsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvcnVsZXMub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ydWxlcy5vdXQK aW5kZXggYTE2MjZmM2ZhZS4uZjU0MzRkODM2NSAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVn cmVzcy9leHBlY3RlZC9ydWxlcy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9ydWxlcy5vdXQKQEAgLTE4MjQsNiArMTgyNCw3IEBAIHBnX3N0YXRfYmd3cml0ZXJ8IFNF TEVDVCBwZ19zdGF0X2dldF9iZ3dyaXRlcl9idWZfd3JpdHRlbl9jbGVhbigpIEFTIGJ1ZmZl cnNfY2xlCiAgICAgcGdfc3RhdF9nZXRfYmd3cml0ZXJfc3RhdF9yZXNldF90aW1lKCkgQVMg c3RhdHNfcmVzZXQ7CiBwZ19zdGF0X2NoZWNrcG9pbnRlcnwgU0VMRUNUIHBnX3N0YXRfZ2V0 X2NoZWNrcG9pbnRlcl9udW1fdGltZWQoKSBBUyBudW1fdGltZWQsCiAgICAgcGdfc3RhdF9n ZXRfY2hlY2twb2ludGVyX251bV9yZXF1ZXN0ZWQoKSBBUyBudW1fcmVxdWVzdGVkLAorICAg IHBnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9udW1fcGVyZm9ybWVkKCkgQVMgbnVtX2RvbmUs CiAgICAgcGdfc3RhdF9nZXRfY2hlY2twb2ludGVyX3Jlc3RhcnRwb2ludHNfdGltZWQoKSBB UyByZXN0YXJ0cG9pbnRzX3RpbWVkLAogICAgIHBnX3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9y ZXN0YXJ0cG9pbnRzX3JlcXVlc3RlZCgpIEFTIHJlc3RhcnRwb2ludHNfcmVxLAogICAgIHBn X3N0YXRfZ2V0X2NoZWNrcG9pbnRlcl9yZXN0YXJ0cG9pbnRzX3BlcmZvcm1lZCgpIEFTIHJl c3RhcnRwb2ludHNfZG9uZSwKLS0gCjIuNDUuMgoK --------------JE2WaQ3lsMLhwf3gczswfhgc Content-Type: text/plain; charset=UTF-8; name="v4-0002-docs-Enhance-the-pg_stat_checkpointer-view-docume.patch" Content-Disposition: attachment; filename*0="v4-0002-docs-Enhance-the-pg_stat_checkpointer-view-docume.pa"; filename*1="tch" Content-Transfer-Encoding: base64 RnJvbSBkOTMxMWFlZTVhMGU3NjY1ZWIwZWEzMjkyOGY3MjhhOGNkMDFmYWI1IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGdWppaSBNYXNhbyA8ZnVqaWlAcG9zdGdyZXNxbC5v cmc+CkRhdGU6IFNhdCwgMjEgU2VwIDIwMjQgMDA6NDc6MTIgKzA5MDAKU3ViamVjdDogW1BB VENIIHY0IDIvMl0gZG9jczogRW5oYW5jZSB0aGUgcGdfc3RhdF9jaGVja3BvaW50ZXIgdmll dwogZG9jdW1lbnRhdGlvbi4KClRoaXMgY29tbWl0IHVwZGF0ZXMgdGhlIGRvY3VtZW50YXRp b24gZm9yIHRoZSBwZ19zdGF0X2NoZWNrcG9pbnRlciB2aWV3CnRvIGNsYXJpZnkgd2hhdCBr aW5kIG9mIGNoZWNrcG9pbnRzIG9yIHJlc3RhcnRwb2ludHMgZWFjaCBjb3VudGVyIHRyYWNr cy4KVGhpcyBtYWtlcyBpdCBlYXNpZXIgdG8gdW5kZXJzdGFuZCB0aGUgbWVhbmluZyBvZiBl YWNoIGNvdW50ZXIuCi0tLQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCB8IDE5ICsr KysrKysrKysrKysrLS0tLS0KIDEgZmlsZSBjaGFuZ2VkLCAxNCBpbnNlcnRpb25zKCspLCA1 IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNn bWwgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmluZy5zZ21sCmluZGV4IDE5YmYwMTY0ZjEuLjM0 ODRhMDQ5MGEgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwKKysr IGIvZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbApAQCAtMzA1MSwxMCArMzA1MSw3IEBA IGRlc2NyaXB0aW9uIHwgV2FpdGluZyBmb3IgYSBuZXdseSBpbml0aWFsaXplZCBXQUwgZmls ZSB0byByZWFjaCBkdXJhYmxlIHN0b3JhZ2UKICAgICAgICA8c3RydWN0ZmllbGQ+bnVtX3Rp bWVkPC9zdHJ1Y3RmaWVsZD4gPHR5cGU+YmlnaW50PC90eXBlPgogICAgICAgPC9wYXJhPgog ICAgICAgPHBhcmE+Ci0gICAgICAgTnVtYmVyIG9mIHNjaGVkdWxlZCBjaGVja3BvaW50cyBk dWUgdG8gdGltZW91dC4KLSAgICAgICBOb3RlIHRoYXQgY2hlY2twb2ludHMgbWF5IGJlIHNr aXBwZWQgaWYgdGhlIHNlcnZlciBoYXMgYmVlbiBpZGxlCi0gICAgICAgc2luY2UgdGhlIGxh c3Qgb25lLCBhbmQgdGhpcyB2YWx1ZSBjb3VudHMgYm90aCBjb21wbGV0ZWQgYW5kCi0gICAg ICAgc2tpcHBlZCBjaGVja3BvaW50cworICAgICAgIE51bWJlciBvZiBzY2hlZHVsZWQgY2hl Y2twb2ludHMgZHVlIHRvIHRpbWVvdXQKICAgICAgIDwvcGFyYT48L2VudHJ5PgogICAgICA8 L3Jvdz4KIApAQCAtMzA2Myw3ICszMDYwLDcgQEAgZGVzY3JpcHRpb24gfCBXYWl0aW5nIGZv ciBhIG5ld2x5IGluaXRpYWxpemVkIFdBTCBmaWxlIHRvIHJlYWNoIGR1cmFibGUgc3RvcmFn ZQogICAgICAgIDxzdHJ1Y3RmaWVsZD5udW1fcmVxdWVzdGVkPC9zdHJ1Y3RmaWVsZD4gPHR5 cGU+YmlnaW50PC90eXBlPgogICAgICAgPC9wYXJhPgogICAgICAgPHBhcmE+Ci0gICAgICAg TnVtYmVyIG9mIGJhY2tlbmQgcmVxdWVzdGVkIGNoZWNrcG9pbnRzCisgICAgICAgTnVtYmVy IG9mIHJlcXVlc3RlZCBjaGVja3BvaW50cwogICAgICAgPC9wYXJhPjwvZW50cnk+CiAgICAg IDwvcm93PgogCkBAIC0zMTQ2LDYgKzMxNDMsMTggQEAgZGVzY3JpcHRpb24gfCBXYWl0aW5n IGZvciBhIG5ld2x5IGluaXRpYWxpemVkIFdBTCBmaWxlIHRvIHJlYWNoIGR1cmFibGUgc3Rv cmFnZQogICAgPC90Z3JvdXA+CiAgIDwvdGFibGU+CiAKKyAgPHBhcmE+CisgICBDaGVja3Bv aW50cyBtYXkgYmUgc2tpcHBlZCBpZiB0aGUgc2VydmVyIGhhcyBiZWVuIGlkbGUgc2luY2Ug dGhlIGxhc3Qgb25lLgorICAgPHN0cnVjdGZpZWxkPm51bV90aW1lZDwvc3RydWN0ZmllbGQ+ IGFuZAorICAgPHN0cnVjdGZpZWxkPm51bV9yZXF1ZXN0ZWQ8L3N0cnVjdGZpZWxkPiBjb3Vu dCBib3RoIGNvbXBsZXRlZCBhbmQgc2tpcHBlZAorICAgY2hlY2twb2ludHMsIHdoaWxlIDxz dHJ1Y3RmaWVsZD5udW1fZG9uZTwvc3RydWN0ZmllbGQ+IHRyYWNrcyBvbmx5CisgICB0aGUg Y29tcGxldGVkIG9uZXMuICBTaW1pbGFybHksIHJlc3RhcnRwb2ludHMgbWF5IGJlIHNraXBw ZWQKKyAgIGlmIHRoZSBsYXN0IHJlcGxheWVkIGNoZWNrcG9pbnQgcmVjb3JkIGlzIGFscmVh ZHkgdGhlIGxhc3QgcmVzdGFydHBvaW50LgorICAgPHN0cnVjdGZpZWxkPnJlc3RhcnRwb2lu dHNfdGltZWQ8L3N0cnVjdGZpZWxkPiBhbmQKKyAgIDxzdHJ1Y3RmaWVsZD5yZXN0YXJ0cG9p bnRzX3JlcTwvc3RydWN0ZmllbGQ+IGNvdW50IGJvdGggY29tcGxldGVkIGFuZAorICAgc2tp cHBlZCByZXN0YXJ0cG9pbnRzLCB3aGlsZSA8c3RydWN0ZmllbGQ+cmVzdGFydHBvaW50c19k b25lPC9zdHJ1Y3RmaWVsZD4KKyAgIHRyYWNrcyBvbmx5IHRoZSBjb21wbGV0ZWQgb25lcy4K KyAgPC9wYXJhPgogIDwvc2VjdDI+CiAKICA8c2VjdDIgaWQ9Im1vbml0b3JpbmctcGctc3Rh dC13YWwtdmlldyI+Ci0tIAoyLjQ1LjIKCg== --------------JE2WaQ3lsMLhwf3gczswfhgc--