Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZnZAe-0003mV-G3 for pgsql-docs@arkaria.postgresql.org; Sat, 17 Oct 2015 21:37:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZnZAd-0002l4-Sw for pgsql-docs@arkaria.postgresql.org; Sat, 17 Oct 2015 21:37:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZnZAc-0002jY-Ix for pgsql-docs@postgresql.org; Sat, 17 Oct 2015 21:37:42 +0000 Received: from mail-wi0-f169.google.com ([209.85.212.169]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZnZAY-0007wG-Id for pgsql-docs@postgresql.org; Sat, 17 Oct 2015 21:37:42 +0000 Received: by wicll6 with SMTP id ll6so53016374wic.1 for ; Sat, 17 Oct 2015 14:37:35 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-type; bh=5G5n4MZAJhJuTu4BLJpbQlAEjv3WSlmicvVkQfjZRTM=; b=XtLhAXxQ9Krbx2ZFmvkvJC+OOjnxTEihPE7/JmdX5Vk+N9q3gt+ob6AT9TGvaLe4WL RkSu6ODgqRd847wdyCeWbvVFl2T4fAoxSOwYxVl4+Qd6AYsrmwU8XJWZKI93Xvv9HauV 9G7Koob0EGg7Nv3pjCn25OkRQ+Cmvus0D3n9We54Cpy5tzEivzj9z8ZznmXzq8YGVFFN EqxW3wMSor0OZ3Mb05A7U/bMzXdp6iknFbEqcEdOUmemRJDtNigbsmHKBeQbjgi8aIJ7 VhOe++OyU6p3qh6yrfYor5jBlm84+EiljvyJXMj7GN88ZuKrdmkxVPzLtr2tvbhBEs+y TgHw== X-Gm-Message-State: ALoCoQkPWR/RjAA9JbjwHEfEh5LojU0zoFBXkdEXKs7D7Uo6BaBiMJYiuHSkfP95KjraPOxghSNV X-Received: by 10.194.52.6 with SMTP id p6mr27380975wjo.119.1445117855699; Sat, 17 Oct 2015 14:37:35 -0700 (PDT) Received: from ?IPv6:2a00:1028:96c9:ee5a:9894:221a:16da:587b? (dynamic-2a00-1028-96c9-ee5a-9894-221a-16da-587b.ipv6.broadband.iol.cz. [2a00:1028:96c9:ee5a:9894:221a:16da:587b]) by smtp.gmail.com with ESMTPSA id bk4sm30441024wjc.1.2015.10.17.14.37.34 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 17 Oct 2015 14:37:34 -0700 (PDT) Subject: Re: [HACKERS] max_worker_processes on the standby To: Robert Haas , Alvaro Herrera References: <20150930224806.GR2573@alvherre.pgsql> <20151001181240.GT2573@alvherre.pgsql> <20151002145839.GZ2573@alvherre.pgsql> <20151002185941.GE2573@alvherre.pgsql> Cc: Fujii Masao , oonishitk@nttdata.co.jp, pgsql-docs , PostgreSQL-development From: Petr Jelinek Message-ID: <5622BF9D.2010409@2ndquadrant.com> Date: Sat, 17 Oct 2015 23:37:33 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/mixed; boundary="------------000702050102000808010609" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. --------------000702050102000808010609 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 2015-10-02 22:02, Robert Haas wrote: > On Fri, Oct 2, 2015 at 2:59 PM, Alvaro Herrera wrote: >> Robert Haas wrote: >>> The standby can have the feature enabled even though the master has it >>> disabled? That seems like it can only lead to heartache. >> >> Can you elaborate? > > Sort of. Our rule up until now has always been that the standby is an > exact copy of the master. I suspect deviating from that behavior will > introduce bugs. I suspect having the standby make data changes that > aren't WAL-logged will introduce bugs; not to be unkind, but that > certainly seems like a lesson to take from what happened with > multixacts. > I agree with that sentiment. Attached patch adds variable to the shmem which is used for module activation tracking - set to true in ActiveCommitTs() and false in DeactivateCommitTs(). All the checks inside the commit_ts code were changed to use this new variable. I also removed the static variable Alvaro added in previous commit because it's not needed anymore. The patch also does full cleanup of the shmem state in DeactivateCommitTs() so that standby does not have stale last committed transaction info after enable/disable/enable cycle on primary I also removed no longer used do_wal parameters in couple of functions. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --------------000702050102000808010609 Content-Type: application/x-patch; name="committs-activation-fixes.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="committs-activation-fixes.patch" ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL2NvbW1p dF90cy5jIGIvc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0vY29tbWl0X3Rz LmMKaW5kZXggMjRiODI5MS4uOGFmOGRiZSAxMDA2NDQKLS0tIGEvc3JjL2Jh Y2tlbmQvYWNjZXNzL3RyYW5zYW0vY29tbWl0X3RzLmMKKysrIGIvc3JjL2Jh Y2tlbmQvYWNjZXNzL3RyYW5zYW0vY29tbWl0X3RzLmMKQEAgLTgwLDExICs4 MCwxNyBAQCBzdGF0aWMgU2xydUN0bERhdGEgQ29tbWl0VHNDdGxEYXRhOwog LyoKICAqIFdlIGtlZXAgYSBjYWNoZSBvZiB0aGUgbGFzdCB2YWx1ZSBzZXQg aW4gc2hhcmVkIG1lbW9yeS4gIFRoaXMgaXMgcHJvdGVjdGVkCiAgKiBieSBD b21taXRUc0xvY2suCisgKgorICogVGhpcyBpcyBhbHNvIGdvb2QgcGxhY2Ug dG8ga2VlcCB0aGUgYWN0aXZhdGlvbiBzdGF0dXMuICBXZSBuZWVkIHRvIGtl ZXAKKyAqIHRoZSBhY3RpdmF0aW9uIHN0YXR1cyBzZXBhcmF0ZSBmcm9tIHRo ZSBHVUMgYmVsbG93IGJlY2F1c2UgdGhlIHN0YW5kYnkgbmVlZHMKKyAqIHRv IGFjdGl2YXRlIHRoZSBtb2R1bGUgaWYgdGhlIHByaW1hcnkgaGFzIGl0IGFj dGl2ZSBpbmRlcGVuZGVudGx5IG9mIHdoYXQKKyAqIHRyYWNrX2NvbW1pdF90 aW1lc3RhbXAgc2V0dGluZyBpcyBvbiBzdGFuZGJ5LgogICovCiB0eXBlZGVm IHN0cnVjdCBDb21taXRUaW1lc3RhbXBTaGFyZWQKIHsKIAlUcmFuc2FjdGlv bklkIHhpZExhc3RDb21taXQ7CiAJQ29tbWl0VGltZXN0YW1wRW50cnkgZGF0 YUxhc3RDb21taXQ7CisJYm9vbAljb21taXRUc0FjdGl2ZTsKIH0gQ29tbWl0 VGltZXN0YW1wU2hhcmVkOwogCiBDb21taXRUaW1lc3RhbXBTaGFyZWQgKmNv bW1pdFRzU2hhcmVkOwpAQCAtOTMsMTQgKzk5LDYgQEAgQ29tbWl0VGltZXN0 YW1wU2hhcmVkICpjb21taXRUc1NoYXJlZDsKIC8qIEdVQyB2YXJpYWJsZSAq LwogYm9vbAkJdHJhY2tfY29tbWl0X3RpbWVzdGFtcDsKIAotLyoKLSAqIFdo ZW4gdGhpcyBpcyBzZXQsIGNvbW1pdF90cyBpcyBmb3JjZS1lbmFibGVkIGR1 cmluZyByZWNvdmVyeS4gIFRoaXMgaXMgc28KLSAqIHRoYXQgYSBzdGFuZGJ5 IGNhbiByZXBsYXkgV0FMIHJlY29yZHMgY29taW5nIGZyb20gYSBtYXN0ZXIg d2l0aCB0aGUgc2V0dGluZwotICogZW5hYmxlZC4gIChOb3RlIHRoYXQgdGhp cyBkb2Vzbid0IGVuYWJsZSBTUUwgYWNjZXNzIHRvIHRoZSBkYXRhOyBpdCdz Ci0gKiBlZmZlY3RpdmVseSB3cml0ZS1vbmx5IHVudGlsIHRoZSBHVUMgaXRz ZWxmIGlzIGVuYWJsZWQuKQotICovCi1zdGF0aWMgYm9vbAkJZW5hYmxlX2R1 cmluZ19yZWNvdmVyeTsKLQogc3RhdGljIHZvaWQgU2V0WGlkQ29tbWl0VHNJ blBhZ2UoVHJhbnNhY3Rpb25JZCB4aWQsIGludCBuc3VieGlkcywKIAkJCQkJ IFRyYW5zYWN0aW9uSWQgKnN1YnhpZHMsIFRpbWVzdGFtcFR6IHRzLAogCQkJ CQkgUmVwT3JpZ2luSWQgbm9kZWlkLCBpbnQgcGFnZW5vKTsKQEAgLTEwOSw3 ICsxMDcsNyBAQCBzdGF0aWMgdm9pZCBUcmFuc2FjdGlvbklkU2V0Q29tbWl0 VHMoVHJhbnNhY3Rpb25JZCB4aWQsIFRpbWVzdGFtcFR6IHRzLAogc3RhdGlj IGludAlaZXJvQ29tbWl0VHNQYWdlKGludCBwYWdlbm8sIGJvb2wgd3JpdGVY bG9nKTsKIHN0YXRpYyBib29sIENvbW1pdFRzUGFnZVByZWNlZGVzKGludCBw YWdlMSwgaW50IHBhZ2UyKTsKIHN0YXRpYyB2b2lkIEFjdGl2YXRlQ29tbWl0 VHModm9pZCk7Ci1zdGF0aWMgdm9pZCBEZWFjdGl2YXRlQ29tbWl0VHMoYm9v bCBkb193YWwpOworc3RhdGljIHZvaWQgRGVhY3RpdmF0ZUNvbW1pdFRzKHZv aWQpOwogc3RhdGljIHZvaWQgV3JpdGVaZXJvUGFnZVhsb2dSZWMoaW50IHBh Z2Vubyk7CiBzdGF0aWMgdm9pZCBXcml0ZVRydW5jYXRlWGxvZ1JlYyhpbnQg cGFnZW5vKTsKIHN0YXRpYyB2b2lkIFdyaXRlU2V0VGltZXN0YW1wWGxvZ1Jl YyhUcmFuc2FjdGlvbklkIG1haW54aWQsIGludCBuc3VieGlkcywKQEAgLTE0 OCwxMSArMTQ2LDggQEAgVHJhbnNhY3Rpb25UcmVlU2V0Q29tbWl0VHNEYXRh KFRyYW5zYWN0aW9uSWQgeGlkLCBpbnQgbnN1YnhpZHMsCiAJVHJhbnNhY3Rp b25JZCBoZWFkeGlkOwogCVRyYW5zYWN0aW9uSWQgbmV3ZXN0WGFjdDsKIAot CS8qCi0JICogTm8tb3AgaWYgdGhlIG1vZHVsZSBpcyBub3QgZW5hYmxlZCwg YnV0IGFsbG93IHdyaXRlcyBpbiBhIHN0YW5kYnkKLQkgKiBkdXJpbmcgcmVj b3ZlcnkuCi0JICovCi0JaWYgKCF0cmFja19jb21taXRfdGltZXN0YW1wICYm ICFlbmFibGVfZHVyaW5nX3JlY292ZXJ5KQorCS8qIE5vLW9wIGlmIHRoZSBt b2R1bGUgaXMgbm90IGFjdGl2ZS4gKi8KKwlpZiAoIWNvbW1pdFRzU2hhcmVk LT5jb21taXRUc0FjdGl2ZSkKIAkJcmV0dXJuOwogCiAJLyoKQEAgLTI4NCw3 ICsyNzksNyBAQCBUcmFuc2FjdGlvbklkR2V0Q29tbWl0VHNEYXRhKFRyYW5z YWN0aW9uSWQgeGlkLCBUaW1lc3RhbXBUeiAqdHMsCiAJVHJhbnNhY3Rpb25J ZCBuZXdlc3RDb21taXRUczsKIAogCS8qIEVycm9yIGlmIG1vZHVsZSBub3Qg ZW5hYmxlZCAqLwotCWlmICghdHJhY2tfY29tbWl0X3RpbWVzdGFtcCkKKwlp ZiAoIWNvbW1pdFRzU2hhcmVkLT5jb21taXRUc0FjdGl2ZSkKIAkJZXJlcG9y dChFUlJPUiwKIAkJCQkoZXJyY29kZShFUlJDT0RFX09CSkVDVF9OT1RfSU5f UFJFUkVRVUlTSVRFX1NUQVRFKSwKIAkJCQkgZXJybXNnKCJjb3VsZCBub3Qg Z2V0IGNvbW1pdCB0aW1lc3RhbXAgZGF0YSIpLApAQCAtMzY3LDcgKzM2Miw3 IEBAIEdldExhdGVzdENvbW1pdFRzRGF0YShUaW1lc3RhbXBUeiAqdHMsIFJl cE9yaWdpbklkICpub2RlaWQpCiAJVHJhbnNhY3Rpb25JZCB4aWQ7CiAKIAkv KiBFcnJvciBpZiBtb2R1bGUgbm90IGVuYWJsZWQgKi8KLQlpZiAoIXRyYWNr X2NvbW1pdF90aW1lc3RhbXApCisJaWYgKCFjb21taXRUc1NoYXJlZC0+Y29t bWl0VHNBY3RpdmUpCiAJCWVyZXBvcnQoRVJST1IsCiAJCQkJKGVycmNvZGUo RVJSQ09ERV9PQkpFQ1RfTk9UX0lOX1BSRVJFUVVJU0lURV9TVEFURSksCiAJ CQkJIGVycm1zZygiY291bGQgbm90IGdldCBjb21taXQgdGltZXN0YW1wIGRh dGEiKSwKQEAgLTQ5Myw2ICs0ODgsNyBAQCBDb21taXRUc1NobWVtSW5pdCh2 b2lkKQogCQljb21taXRUc1NoYXJlZC0+eGlkTGFzdENvbW1pdCA9IEludmFs aWRUcmFuc2FjdGlvbklkOwogCQlUSU1FU1RBTVBfTk9CRUdJTihjb21taXRU c1NoYXJlZC0+ZGF0YUxhc3RDb21taXQudGltZSk7CiAJCWNvbW1pdFRzU2hh cmVkLT5kYXRhTGFzdENvbW1pdC5ub2RlaWQgPSBJbnZhbGlkUmVwT3JpZ2lu SWQ7CisJCWNvbW1pdFRzU2hhcmVkLT5jb21taXRUc0FjdGl2ZSA9IGZhbHNl OwogCX0KIAllbHNlCiAJCUFzc2VydChmb3VuZCk7CkBAIC01NjYsNyArNTYy LDcgQEAgQ29tcGxldGVDb21taXRUc0luaXRpYWxpemF0aW9uKHZvaWQpCiAJ ICogYW55IGxlZnRvdmVyIGRhdGEuCiAJICovCiAJaWYgKCF0cmFja19jb21t aXRfdGltZXN0YW1wKQotCQlEZWFjdGl2YXRlQ29tbWl0VHModHJ1ZSk7CisJ CURlYWN0aXZhdGVDb21taXRUcygpOwogfQogCiAvKgpAQCAtNTg4LDExICs1 ODQsMTEgQEAgQ29tbWl0VHNQYXJhbWV0ZXJDaGFuZ2UoYm9vbCBuZXd2YWx1 ZSwgYm9vbCBvbGR2YWx1ZSkKIAkgKi8KIAlpZiAobmV3dmFsdWUpCiAJewot CQlpZiAoIXRyYWNrX2NvbW1pdF90aW1lc3RhbXAgJiYgIW9sZHZhbHVlKQor CQlpZiAoIWNvbW1pdFRzU2hhcmVkLT5jb21taXRUc0FjdGl2ZSkKIAkJCUFj dGl2YXRlQ29tbWl0VHMoKTsKIAl9Ci0JZWxzZSBpZiAoIXRyYWNrX2NvbW1p dF90aW1lc3RhbXAgJiYgb2xkdmFsdWUpCi0JCURlYWN0aXZhdGVDb21taXRU cyhmYWxzZSk7CisJZWxzZSBpZiAoY29tbWl0VHNTaGFyZWQtPmNvbW1pdFRz QWN0aXZlKQorCQlEZWFjdGl2YXRlQ29tbWl0VHMoKTsKIH0KIAogLyoKQEAg LTY0NSw3ICs2NDEsNyBAQCBBY3RpdmF0ZUNvbW1pdFRzKHZvaWQpCiAJfQog CUxXTG9ja1JlbGVhc2UoQ29tbWl0VHNMb2NrKTsKIAotCS8qIEZpbmFsbHks IGNyZWF0ZSB0aGUgY3VycmVudCBzZWdtZW50IGZpbGUsIGlmIG5lY2Vzc2Fy eSAqLworCS8qIENyZWF0ZSB0aGUgY3VycmVudCBzZWdtZW50IGZpbGUsIGlm IG5lY2Vzc2FyeSAqLwogCWlmICghU2ltcGxlTHJ1RG9lc1BoeXNpY2FsUGFn ZUV4aXN0KENvbW1pdFRzQ3RsLCBwYWdlbm8pKQogCXsKIAkJaW50CQkJc2xv dG5vOwpAQCAtNjU3LDggKzY1MywxMCBAQCBBY3RpdmF0ZUNvbW1pdFRzKHZv aWQpCiAJCUxXTG9ja1JlbGVhc2UoQ29tbWl0VHNDb250cm9sTG9jayk7CiAJ fQogCi0JLyogV2UgY2FuIG5vdyByZXBsYXkgeGxvZyByZWNvcmRzIGZyb20g dGhpcyBtb2R1bGUgKi8KLQllbmFibGVfZHVyaW5nX3JlY292ZXJ5ID0gdHJ1 ZTsKKwkvKiBDaGFuZ2UgdGhlIGFjdGl2YXRpb24gc3RhdHVzIGluIHNoYXJl ZCBtZW1vcnkuICovCisJTFdMb2NrQWNxdWlyZShDb21taXRUc0xvY2ssIExX X0VYQ0xVU0lWRSk7CisJY29tbWl0VHNTaGFyZWQtPmNvbW1pdFRzQWN0aXZl ID0gdHJ1ZTsKKwlMV0xvY2tSZWxlYXNlKENvbW1pdFRzTG9jayk7CiB9CiAK IC8qCkBAIC02NzIsNyArNjcwLDcgQEAgQWN0aXZhdGVDb21taXRUcyh2b2lk KQogICogcG9zc2libHktaW52YWxpZCBkYXRhOyBhbHNvIHJlbW92ZXMgc2Vn bWVudHMgb2Ygb2xkIGRhdGEuCiAgKi8KIHN0YXRpYyB2b2lkCi1EZWFjdGl2 YXRlQ29tbWl0VHMoYm9vbCBkb193YWwpCitEZWFjdGl2YXRlQ29tbWl0VHMo dm9pZCkKIHsKIAlUcmFuc2FjdGlvbklkIHhpZCA9IFNobWVtVmFyaWFibGVD YWNoZS0+bmV4dFhpZDsKIAlpbnQJCQlwYWdlbm8gPSBUcmFuc2FjdGlvbklk VG9DVHNQYWdlKHhpZCk7CkBAIC02ODQsMTEgKzY4MiwyNiBAQCBEZWFjdGl2 YXRlQ29tbWl0VHMoYm9vbCBkb193YWwpCiAJQ29tbWl0VHNDdGwtPnNoYXJl ZC0+bGF0ZXN0X3BhZ2VfbnVtYmVyID0gcGFnZW5vOwogCUxXTG9ja1JlbGVh c2UoQ29tbWl0VHNDb250cm9sTG9jayk7CiAKKwkvKgorCSAqIENsZWFudXAg dGhlIHN0YXR1cyBpbiB0aGUgc2hhcmVkIG1lbW9yeS4KKwkgKgorCSAqIFdl IHJlc2V0IGV2ZXJ5dGhpbmcgaW4gdGhlIGNvbW1pdFRzU2hhcmVkIHJlY29y ZCB0byBwcmV2ZW50IHVzZXIgZnJvbQorCSAqIGdldHRpbmcgY29uZnVzaW5n IGRhdGEgYWJvdXQgbGFzdCBjb21taXR0ZWQgdHJhbnNhY3Rpb24gb24gdGhl IHN0YW5kYnkKKwkgKiB3aGVuIHRoZSBtb2R1bGUgd2FzIGFjdGl2YXRlZCBy ZXBlYXRlZGx5IG9uIHRoZSBwcmltYXJ5LgorCSAqLwogCUxXTG9ja0FjcXVp cmUoQ29tbWl0VHNMb2NrLCBMV19FWENMVVNJVkUpOworCisJY29tbWl0VHNT aGFyZWQtPmNvbW1pdFRzQWN0aXZlID0gZmFsc2U7CisJY29tbWl0VHNTaGFy ZWQtPnhpZExhc3RDb21taXQgPSBJbnZhbGlkVHJhbnNhY3Rpb25JZDsKKwlU SU1FU1RBTVBfTk9CRUdJTihjb21taXRUc1NoYXJlZC0+ZGF0YUxhc3RDb21t aXQudGltZSk7CisJY29tbWl0VHNTaGFyZWQtPmRhdGFMYXN0Q29tbWl0Lm5v ZGVpZCA9IEludmFsaWRSZXBPcmlnaW5JZDsKKwogCVNobWVtVmFyaWFibGVD YWNoZS0+b2xkZXN0Q29tbWl0VHMgPSBJbnZhbGlkVHJhbnNhY3Rpb25JZDsK IAlTaG1lbVZhcmlhYmxlQ2FjaGUtPm5ld2VzdENvbW1pdFRzID0gSW52YWxp ZFRyYW5zYWN0aW9uSWQ7CisKIAlMV0xvY2tSZWxlYXNlKENvbW1pdFRzTG9j ayk7CiAKKwogCS8qCiAJICogUmVtb3ZlICphbGwqIGZpbGVzLiAgVGhpcyBp cyBuZWNlc3Nhcnkgc28gdGhhdCB0aGVyZSBhcmUgbm8gbGVmdG92ZXIKIAkg KiBmaWxlczsgaW4gdGhlIGNhc2Ugd2hlcmUgdGhpcyBmZWF0dXJlIGlzIGxh dGVyIGVuYWJsZWQgYWZ0ZXIgcnVubmluZwpAQCAtNjk4LDkgKzcxMSw2IEBA IERlYWN0aXZhdGVDb21taXRUcyhib29sIGRvX3dhbCkKIAkgKiB0aWR5LikK IAkgKi8KIAkodm9pZCkgU2xydVNjYW5EaXJlY3RvcnkoQ29tbWl0VHNDdGws IFNscnVTY2FuRGlyQ2JEZWxldGVBbGwsIE5VTEwpOwotCi0JLyogTm8gbG9u Z2VyIGVuYWJsZWQgb24gcmVjb3ZlcnkgKi8KLQllbmFibGVfZHVyaW5nX3Jl Y292ZXJ5ID0gZmFsc2U7CiB9CiAKIC8qCkBAIC03NDAsNyArNzUwLDcgQEAg RXh0ZW5kQ29tbWl0VHMoVHJhbnNhY3Rpb25JZCBuZXdlc3RYYWN0KQogCWlu dAkJCXBhZ2VubzsKIAogCS8qIG5vdGhpbmcgdG8gZG8gaWYgbW9kdWxlIG5v dCBlbmFibGVkICovCi0JaWYgKCF0cmFja19jb21taXRfdGltZXN0YW1wICYm ICFlbmFibGVfZHVyaW5nX3JlY292ZXJ5KQorCWlmICghY29tbWl0VHNTaGFy ZWQtPmNvbW1pdFRzQWN0aXZlKQogCQlyZXR1cm47CiAKIAkvKgpAQCAtNzY4 LDcgKzc3OCw3IEBAIEV4dGVuZENvbW1pdFRzKFRyYW5zYWN0aW9uSWQgbmV3 ZXN0WGFjdCkKICAqIE5vdGUgdGhhdCB3ZSBkb24ndCBuZWVkIHRvIGZsdXNo IFhMT0cgaGVyZS4KICAqLwogdm9pZAotVHJ1bmNhdGVDb21taXRUcyhUcmFu c2FjdGlvbklkIG9sZGVzdFhhY3QsIGJvb2wgZG9fd2FsKQorVHJ1bmNhdGVD b21taXRUcyhUcmFuc2FjdGlvbklkIG9sZGVzdFhhY3QpCiB7CiAJaW50CQkJ Y3V0b2ZmUGFnZTsKIApAQCAtNzg0LDggKzc5NCw3IEBAIFRydW5jYXRlQ29t bWl0VHMoVHJhbnNhY3Rpb25JZCBvbGRlc3RYYWN0LCBib29sIGRvX3dhbCkK IAkJcmV0dXJuOwkJCQkJLyogbm90aGluZyB0byByZW1vdmUgKi8KIAogCS8q IFdyaXRlIFhMT0cgcmVjb3JkICovCi0JaWYgKGRvX3dhbCkKLQkJV3JpdGVU cnVuY2F0ZVhsb2dSZWMoY3V0b2ZmUGFnZSk7CisJV3JpdGVUcnVuY2F0ZVhs b2dSZWMoY3V0b2ZmUGFnZSk7CiAKIAkvKiBOb3cgd2UgY2FuIHJlbW92ZSB0 aGUgb2xkIENvbW1pdFRzIHNlZ21lbnQocykgKi8KIAlTaW1wbGVMcnVUcnVu Y2F0ZShDb21taXRUc0N0bCwgY3V0b2ZmUGFnZSk7CmRpZmYgLS1naXQgYS9z cmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW0uYyBiL3NyYy9iYWNrZW5kL2Nv bW1hbmRzL3ZhY3V1bS5jCmluZGV4IDZkNTUxNDguLjdjNGVmNTggMTAwNjQ0 Ci0tLSBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3ZhY3V1bS5jCisrKyBiL3Ny Yy9iYWNrZW5kL2NvbW1hbmRzL3ZhY3V1bS5jCkBAIC0xMTQwLDcgKzExNDAs NyBAQCB2YWNfdHJ1bmNhdGVfY2xvZyhUcmFuc2FjdGlvbklkIGZyb3plblhJ RCwKIAkgKiBUcnVuY2F0ZSBDTE9HLCBtdWx0aXhhY3QgYW5kIENvbW1pdFRz IHRvIHRoZSBvbGRlc3QgY29tcHV0ZWQgdmFsdWUuCiAJICovCiAJVHJ1bmNh dGVDTE9HKGZyb3plblhJRCk7Ci0JVHJ1bmNhdGVDb21taXRUcyhmcm96ZW5Y SUQsIHRydWUpOworCVRydW5jYXRlQ29tbWl0VHMoZnJvemVuWElEKTsKIAlU cnVuY2F0ZU11bHRpWGFjdChtaW5NdWx0aSwgbWlubXVsdGlfZGF0b2lkKTsK IAogCS8qCmRpZmYgLS1naXQgYS9zcmMvaW5jbHVkZS9hY2Nlc3MvY29tbWl0 X3RzLmggYi9zcmMvaW5jbHVkZS9hY2Nlc3MvY29tbWl0X3RzLmgKaW5kZXgg MWI5NWI1OC4uMzg0NGJiMyAxMDA2NDQKLS0tIGEvc3JjL2luY2x1ZGUvYWNj ZXNzL2NvbW1pdF90cy5oCisrKyBiL3NyYy9pbmNsdWRlL2FjY2Vzcy9jb21t aXRfdHMuaApAQCAtNDAsNyArNDAsNyBAQCBleHRlcm4gdm9pZCBDb21wbGV0 ZUNvbW1pdFRzSW5pdGlhbGl6YXRpb24odm9pZCk7CiBleHRlcm4gdm9pZCBT aHV0ZG93bkNvbW1pdFRzKHZvaWQpOwogZXh0ZXJuIHZvaWQgQ2hlY2tQb2lu dENvbW1pdFRzKHZvaWQpOwogZXh0ZXJuIHZvaWQgRXh0ZW5kQ29tbWl0VHMo VHJhbnNhY3Rpb25JZCBuZXdlc3RYYWN0KTsKLWV4dGVybiB2b2lkIFRydW5j YXRlQ29tbWl0VHMoVHJhbnNhY3Rpb25JZCBvbGRlc3RYYWN0LCBib29sIGRv X3dhbCk7CitleHRlcm4gdm9pZCBUcnVuY2F0ZUNvbW1pdFRzKFRyYW5zYWN0 aW9uSWQgb2xkZXN0WGFjdCk7CiBleHRlcm4gdm9pZCBTZXRDb21taXRUc0xp bWl0KFRyYW5zYWN0aW9uSWQgb2xkZXN0WGFjdCwKIAkJCQkgVHJhbnNhY3Rp b25JZCBuZXdlc3RYYWN0KTsKIGV4dGVybiB2b2lkIEFkdmFuY2VPbGRlc3RD b21taXRUcyhUcmFuc2FjdGlvbklkIG9sZGVzdFhhY3QpOwo= --------------000702050102000808010609 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --------------000702050102000808010609--