Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKLRf-0005Rz-V3 for pgsql-docs@arkaria.postgresql.org; Mon, 21 Sep 2020 13:01:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kKLRe-0005ra-6Q for pgsql-docs@arkaria.postgresql.org; Mon, 21 Sep 2020 13:01:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKLJc-00081O-WE for pgsql-docs@lists.postgresql.org; Mon, 21 Sep 2020 12:53:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKLJY-0004kN-Ro for pgsql-docs@lists.postgresql.org; Mon, 21 Sep 2020 12:53:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=mk+lPaRY1YXa7LsaiG5gFg50Iqx3jQgE9nKu7shiUWU=; b=GL1wWQeiO41hO0N+EAevkOPGG7 CLSr3uN+kL2fJcM7/3aRRtwKbPYiWeeHgj8yuSbXdJJINvQr3ku46Mx2QgauIIuNDnqV+vOWSbOCo 9rSsYtHh7yegkvlvo1/99jsi5KG6tc/frAVLXf7G6vw6s3IzGS9hTj8Ij0FiTeWnF7mROyG+htKad Eo8f09vHvYDCAFEXvCLMDaCHNjy1mrYH84FI+13mN7+0j4x4rgmLENKRELPIn+jrHy1WANlNsZoiR n/fmqDephbQX3d/3YDS/E7JAlwEGUrfy4kXHwFggUihNIouGDzZ40+BHHkE3UnJwL+UQIvLk8uJb5 HvMQ6nkQ==; Received: from wrigleys.postgresql.org ([87.238.57.234]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKLJX-0007iH-EH for pgsql-docs@lists.postgresql.org; Mon, 21 Sep 2020 12:53:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kKLJW-000789-5O for pgsql-docs@lists.postgresql.org; Mon, 21 Sep 2020 12:53:02 +0000 Content-Type: multipart/mixed; boundary="===============5259004615196931315==" MIME-Version: 1.0 Subject: Index Locking Order is important To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: rbiro@interfacefinancial.com Reply-To: rbiro@interfacefinancial.com, pgsql-docs@lists.postgresql.org Date: Mon, 21 Sep 2020 12:52:21 +0000 Message-ID: <160069274124.14061.4149200726948746846@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5259004615196931315== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMC9pbmRl eC11bmlxdWUtY2hlY2tzLmh0bWwKRGVzY3JpcHRpb246CgpXaGVuIHRoZXJlIGFyZSBtdWx0aXBs ZSB1bmlxdWUgaW5kZXhlcyBvbiBhIHRhYmxlLCBhdCBsZWFzdCBvbmUgdGhhdCBhbGxvd3MKTlVM TCwgdGhlIG9yZGVyIG9mIHRoZSBsb2NrcyBhcmUgaW1wb3J0YW50LiAgVGhpcyBzaG91bGQgYmUg ZXhwbGFpbmVkIGluIHRoZQpkb2N1bWVudGF0aW9uLg0KDQpDb25zaWRlciB0d28gdGFibGVzOg0K DQpjcmVhdGUgdGFibGUgZm9vKGlkMSBiaWdpbnQgcHJpbWFyeSBrZXksIGlkMiBiaWdpbnQgdW5p cXVlKTsNCmFuZA0KY3JlYXRlIHRhYmxlIGJhciAoaWQxIGJpZ2ludCBub3QgbnVsbCwgaWQyIGJp Z2ludCB1bmlxdWUpOw0KDQpXaXRoIGluZGV4ZXMgY3JlYXRlIGluIHRoaXMgb3JkZXI6DQpjcmVh dGUgdW5pcXVlIGluZGV4IGJhcl9pZDIgb24gYmFyKGlkMik7DQpjcmVhdGUgdW5pcXVlIGluZGV4 IHpiYXJfaWQxIG9uIGJhcihpZDEpOw0KYWx0ZXIgdGFibGUgYmFyIGFkZCBwcmltYXJ5IGtleSB1 c2luZyBpbmRleCB6YmFyX2lkMTsNCg0KT25lIG1pZ2h0IGV4cGVjdCBmb28gYW5kIGJhciB0byBi ZWhhdmUgaW4gaWRlbnRpY2FsIHdheXMuDQpIb3dldmVyLCBpZiBvbmUgb3BlbnMgdHdvIGNvbm5l Y3Rpb24gYW5kIGRvZXMNCkJFR0lOOw0KaW5zZXJ0IGludG8gYmFyKGlkMSkgdmFsdWVzICgxKTsN Ci0tIERvIG5vdCBjb21taXQsIHN3aXRjaCB0byBzZWNvbmQgY29ubmVjdGlvbg0KQkVHSU47DQpp bnNlcnQgaW50byBiYXIoaWQxLCBpZDIpIHZhbHVlcyAoMSwgMik7IC0tIFRoaXMgYmxvY2tzIGFz IGl0IHNob3VsZA0KLS0gc3dpdGNoIGJhY2sgdG8gdGhlIGZpcnN0IGNvbm5lY3Rpb24NCnVwZGF0 ZSBiYXIgc2V0IGlkMj0yIHdoZXJlIGlkMT0xOw0KY29tbWl0Ow0KDQpPbmUgb2YgdGhlIHByb2Nl c3NlcyBzaG91bGQgZ2V0IHNvbWV0aGluZyBsaWtlDQoNCkVSUk9SOiAgZGVhZGxvY2sgZGV0ZWN0 ZWQNCkRFVEFJTDogIFByb2Nlc3MgNjg4OCB3YWl0cyBmb3IgU2hhcmVMb2NrIG9uIHRyYW5zYWN0 aW9uIDE0Mjg3NTk2NTsgYmxvY2tlZApieSBwcm9jZXNzIDY4OTcuDQpQcm9jZXNzIDY4OTcgd2Fp dHMgZm9yIFNoYXJlTG9jayBvbiB0cmFuc2FjdGlvbiAxNDI4NzU3MzY7IGJsb2NrZWQgYnkKcHJv Y2VzcyA2ODg4Lg0KSElOVDogIFNlZSBzZXJ2ZXIgbG9nIGZvciBxdWVyeSBkZXRhaWxzLg0KQ09O VEVYVDogIHdoaWxlIGluc2VydGluZyBpbmRleCB0dXBsZSAoMCwzKSBpbiByZWxhdGlvbiAiYmFy X2lkMl9rZXkiDQoNCklmIG9uZSBkb2VzIHRoZSBzYW1lIHRoaW5nIG9uIGZvbywgcHJvY2VzcyAy IHdpbGwgZ2V0DQpFUlJPUjogIGR1cGxpY2F0ZSBrZXkgdmFsdWUgdmlvbGF0ZXMgdW5pcXVlIGNv bnN0cmFpbnQgImZvb19wa2V5Ig0KREVUQUlMOiAgS2V5IChpZDEpPSgxKSBhbHJlYWR5IGV4aXN0 cy4NCg0KV2hpY2ggaXMgd2hhdCBJIHdvdWxkIGV4cGVjdCBmcm9tIGJvdGggdGFibGVzLg0KDQpB dCBhIG1pbmltdW0sIGluZGV4IGxvY2tpbmcgb3JkZXIgc2hvdWxkIGJlIGRvY3VtZW50ZWQgYW5k IGV4cGxhaW5lZC4gDQoNCkl0IG1heSBhbHNvIGJlIGRlc2lyYWJsZSB0byBoYXZlIGEgY29uZmln dXJhdGlvbiBvcHRpb24gdG8gc3dpdGNoIHRoZSBpbmRleApsb2NraW5nIG9yZGVyIHRvIGFscGhh YmV0aWNhbCBieSBuYW1lIHRvIG1ha2UgaXQgZWFzeSB0byBjb250cm9sIGxpa2UKdHJpZ2dlcnMu Cg== --===============5259004615196931315==--