Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 375BB476128 for ; Thu, 16 Jan 2003 04:03:49 -0500 (EST) Received: from pos_pdc.posportal.com (unknown [12.158.169.100]) by postgresql.org (Postfix) with ESMTP id ABD77475D93 for ; Thu, 16 Jan 2003 04:03:47 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 Subject: Re: 7.3.1 New install, large queries are slow Date: Thu, 16 Jan 2003 01:03:43 -0800 Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C02@pos_pdc.posportal.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] 7.3.1 New install, large queries are slow Thread-Index: AcK9GX1//W2i8AeRQnaE5W1F2Gh0lAAGCuHA From: "Roman Fail" To: "Josh Berkus" , "Tom Lane" , Cc: X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/135 X-Sequence-Number: 782 KioqKioqKioqKioqKioqKioqKioqKioNCj4gSm9zaCBCZXJrdXMgd3JvdGU6 DQo+IEhleSwgUm9tYW4sIGhvdyBtYW55IHJlY29yZHMgaW4gQmF0Y2hEZXRh aWwsIGFueXdheT8NCg0KMjMgbWlsbGlvbi4NCiANCioqKioqKioqKioqKioq KioqKioqKioqDQo+IFN0ZXBoYW4gU3phYm8gd3JvdGU6DQo+IFdoYXQgZG9l cyB2YWN1dW0gdmVyYm9zZSBiYXRjaGRldGFpbCBnaXZlIHlvdSAoaXQnbGwg Z2l2ZSBhbiBpZGVhIG9mIHBhZ2VzIGFueXdheSkNCg0KdHJhbnM9IyBWQUNV VU0gVkVSQk9TRSBiYXRjaGRldGFpbDsNCklORk86ICAtLVJlbGF0aW9uIHB1 YmxpYy5iYXRjaGRldGFpbC0tDQpJTkZPOiAgUGFnZXMgMTY2OTA0NzogQ2hh bmdlZCAwLCBFbXB0eSAwOyBUdXAgMjMzMTY2NzQ6IFZhYyAwLCBLZWVwIDAs IFVuVXNlZCAwLg0KICAgICAgICBUb3RhbCBDUFUgODUuMzZzLzkuMzh1IHNl YyBlbGFwc2VkIDI1My4zOCBzZWMuDQpJTkZPOiAgLS1SZWxhdGlvbiBwZ190 b2FzdC5wZ190b2FzdF84NjA0MjQ3LS0NCklORk86ICBQYWdlcyAwOiBDaGFu Z2VkIDAsIEVtcHR5IDA7IFR1cCAwOiBWYWMgMCwgS2VlcCAwLCBVblVzZWQg MC4NCiAgICAgICAgVG90YWwgQ1BVIDAuMDBzLzAuMDB1IHNlYyBlbGFwc2Vk IDAuMDAgc2VjLg0KVkFDVVVNDQp0cmFucz0jDQoNCioqKioqKioqKioqKioq KioqKioqKioqDQpBdCBTdGVwaGFuIFN6YWJvIGFuZCBUb20gTGFuZSdzIHN1 Z2dlc3Rpb24sIEkgcmVvcmdhbml6ZWQgdGhlIHF1ZXJ5IHNvIHRoZSBKT0lO IHN5bnRheCB3YXMgb25seSB1c2VkIGluIHRoZSBvdXRlciBqb2lucy4gIFRo aXMgZGlkIG5vdCBzZWVtIHRvIGhlbHAgYXQgYWxsLiAgT2Ygbm90ZTogZHVy aW5nIHRoaXMgcXVlcnkgJ3NhciAtYicgc2hvd2VkIGEgY29uc2lzdGVudCA2 MDAwIGJsb2NrcyByZWFkL3NlYywgQ1BVIHdhcyBhYm91dCAyJS4NCiANCkVY UExBSU4gQU5BTFlaRQ0KU0VMRUNUIGIuYmF0Y2hkYXRlLCBkLmJhdGNoZGV0 YWlsaWQsIHQuYmFua25vLCBkLnRyYW5kYXRlLCBkLnRyYW5hbW91bnQsDQpk LnN1Ym1pdGludGVyY2hhbmdlLCBkLmF1dGhhbW91bnQsIGQuYXV0aG5vLCBk LmNhcmR0eXBlaWQsIGQubWNjY29kZSwNCm0ubmFtZSBBUyBtZXJjaGFudG5h bWUsIGMuY2FyZHR5cGUsIG0ubWVyY2hpZCwNCnAxLmxvY2FsdGF4YW1vdW50 LCBwMS5wcm9kdWN0aWRlbnRpZmllciwgZHIuYXZzcmVzcG9uc2UsDQpjci5j aGVja291dGRhdGUsIGNyLm5vc2hvd2luZGljYXRvciwgY2suY2hlY2tpbmdh Y2N0bm8sDQpjay5hYmFyb3V0aW5nbm8sIGNrLmNoZWNrbm8NCkZST00gdHJh bmhlYWRlciB0LCBiYXRjaGhlYWRlciBiLCBtZXJjaGFudHMgbSwgY2FyZHR5 cGUgYywgYmF0Y2hkZXRhaWwgZA0KTEVGVCBKT0lOIHB1cmMxIHAxIG9uIHAx LmJhdGNoZGV0YWlsaWQ9ZC5iYXRjaGRldGFpbGlkDQpMRUZUIEpPSU4gZGly ZWN0IGRyIE9OIGRyLmJhdGNoZGV0YWlsaWQgPSBkLmJhdGNoZGV0YWlsaWQN CkxFRlQgSk9JTiBjYXJyZW50YWwgY3IgT04gY3IuYmF0Y2hkZXRhaWxpZCA9 IGQuYmF0Y2hkZXRhaWxpZA0KTEVGVCBKT0lOIGNoZWNrcyBjayBPTiBjay5i YXRjaGRldGFpbGlkID0gZC5iYXRjaGRldGFpbGlkDQpXSEVSRSB0LnRyYW5o ZWFkZXJpZD1iLnRyYW5oZWFkZXJpZA0KQU5EIG0ubWVyY2hhbnRpZD1iLm1l cmNoYW50aWQNCkFORCBkLmJhdGNoaWQ9Yi5iYXRjaGlkDQpBTkQgYy5jYXJk dHlwZWlkPWQuY2FyZHR5cGVpZA0KQU5EIHQuY2xpZW50aWQgPSA2DQpBTkQg ZC50cmFuYW1vdW50IEJFVFdFRU4gNTAwLjAgQU5EIDcwMC4wDQpBTkQgYi5i YXRjaGRhdGUgPiAnMjAwMi0xMi0xNScNCkFORCBtLm1lcmNoaWQgPSAnNzAx MjUyMjY3Jw0KT1JERVIgQlkgYi5iYXRjaGRhdGUgREVTQw0KTElNSVQgNTAN CkxpbWl0ICAoY29zdD0xNzg5MTA1LjIxLi4xNzg5MTA1LjIyIHJvd3M9MSB3 aWR0aD0yODUpIChhY3R1YWwgdGltZT0xMjIyMDI5LjU5Li4xMjIyMDI5LjYx IHJvd3M9NSBsb29wcz0xKQ0KICAtPiAgU29ydCAgKGNvc3Q9MTc4OTEwNS4y MS4uMTc4OTEwNS4yMiByb3dzPTEgd2lkdGg9Mjg1KSAoYWN0dWFsIHRpbWU9 MTIyMjAyOS41OC4uMTIyMjAyOS41OSByb3dzPTUgbG9vcHM9MSkNCiAgICAg ICAgU29ydCBLZXk6IGIuYmF0Y2hkYXRlDQogICAgICAgIC0+ICBOZXN0ZWQg TG9vcCAgKGNvc3Q9MTc4NzE3MS4yMi4uMTc4OTEwNS4yMCByb3dzPTEgd2lk dGg9Mjg1KSAoYWN0dWFsIHRpbWU9MTIyMTgxNS4xNC4uMTIyMjAxOS40NiBy b3dzPTUgbG9vcHM9MSkNCiAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgi aW5uZXIiLnRyYW5oZWFkZXJpZCA9ICJvdXRlciIudHJhbmhlYWRlcmlkKQ0K ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTE3ODcxNzEu MjIuLjE3ODkwMjYuMDIgcm93cz0xIHdpZHRoPTI2OSkgKGFjdHVhbCB0aW1l PTEyMjE4MDkuMzMuLjEyMjE5NzguNjIgcm93cz01IGxvb3BzPTEpDQogICAg ICAgICAgICAgICAgICAgIEpvaW4gRmlsdGVyOiAoImlubmVyIi5jYXJkdHlw ZWlkID0gIm91dGVyIi5jYXJkdHlwZWlkKQ0KICAgICAgICAgICAgICAgICAg ICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MTc4NzE3MS4yMi4uMTc4OTAyNC43 OSByb3dzPTEgd2lkdGg9MjU1KSAoYWN0dWFsIHRpbWU9MTIyMTgwMi40Ny4u MTIyMTk3MS40OCByb3dzPTUgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgTWVyZ2UgQ29uZDogKCJvdXRlciIuYmF0Y2hpZCA9ICJpbm5l ciIuYmF0Y2hpZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNv cnQgIChjb3N0PTQ3Ni4xNy4uNDc2LjE4IHJvd3M9NCB3aWR0aD0xMDIpIChh Y3R1YWwgdGltZT02NzguMDUuLjY3OC4wNyByb3dzPTE3IGxvb3BzPTEpDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNvcnQgS2V5OiBiLmJh dGNoaWQNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0wLjAwLi40NzYuMTQgcm93cz00IHdpZHRoPTEw MikgKGFjdHVhbCB0aW1lPTE2MS42Mi4uNjc3Ljk1IHJvd3M9MTcgbG9vcHM9 MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IEluZGV4IFNjYW4gdXNpbmcgbWVyY2hhbnRzX2l4X21lcmNoaWRfaWR4IG9u IG1lcmNoYW50cyBtICAoY29zdD0wLjAwLi41LjY1IHJvd3M9MSB3aWR0aD03 OCkgKGFjdHVhbCB0aW1lPTEzLjg3Li4xMy44OCByb3dzPTEgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg SW5kZXggQ29uZDogKG1lcmNoaWQgPSAnNzAxMjUyMjY3Jzo6Y2hhcmFjdGVy IHZhcnlpbmcpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGJhdGNoaGVhZGVyX2l4X21lcmNo YW50aWRfaWR4IG9uIGJhdGNoaGVhZGVyIGIgIChjb3N0PTAuMDAuLjQ3MC4z MCByb3dzPTE1IHdpZHRoPTI0KSAoYWN0dWFsIHRpbWU9MTQ3LjcyLi42NjMu OTQgcm93cz0xNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoIm91dGVyIi5tZXJj aGFudGlkID0gYi5tZXJjaGFudGlkKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChiYXRjaGRhdGUgPiAn MjAwMi0xMi0xNSAwMDowMDowMCc6OnRpbWVzdGFtcCB3aXRob3V0IHRpbWUg em9uZSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNvcnQgIChj b3N0PTE3ODY2OTUuMDUuLjE3ODc2MjEuODIgcm93cz0zNzA3MTAgd2lkdGg9 MTUzKSAoYWN0dWFsIHRpbWU9MTIyMDA4MC4zNC4uMTIyMDcyMi4xOSByb3dz PTM2ODY4MSBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBTb3J0IEtleTogZC5iYXRjaGlkDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBNZXJnZSBKb2luICAoY29zdD0xNzA0MTkxLjI1 Li4xNzEzNjc0LjQ5IHJvd3M9MzcwNzEwIHdpZHRoPTE1MykgKGFjdHVhbCB0 aW1lPTEyMDAxODQuOTEuLjEyMTMzNTIuNzcgcm93cz0zNzAzMDcgbG9vcHM9 MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgTWVy Z2UgQ29uZDogKCJvdXRlciIuYmF0Y2hkZXRhaWxpZCA9ICJpbm5lciIuYmF0 Y2hkZXRhaWxpZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgLT4gIE1lcmdlIEpvaW4gIChjb3N0PTE3MDQwODUuMjguLjE3MTI2 NzguMzMgcm93cz0zNzA3MTAgd2lkdGg9MTE1KSAoYWN0dWFsIHRpbWU9MTE5 OTcwNS43MS4uMTIxMDMzNi4zNyByb3dzPTM3MDMwNyBsb29wcz0xKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBNZXJn ZSBDb25kOiAoIm91dGVyIi5iYXRjaGRldGFpbGlkID0gImlubmVyIi5iYXRj aGRldGFpbGlkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MTcwNDA4NS4yNy4u MTcxMTc1MS41NCByb3dzPTM3MDcxMCB3aWR0aD05OCkgKGFjdHVhbCB0aW1l PTExOTk3MDUuNjUuLjEyMDgxMjIuNzMgcm93cz0zNzAzMDcgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgTWVyZ2UgQ29uZDogKCJvdXRlciIuYmF0Y2hkZXRhaWxpZCA9ICJp bm5lciIuYmF0Y2hkZXRhaWxpZCkNCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE1lcmdlIEpvaW4gIChj b3N0PTE3MDQwODUuMjYuLjE3MTA4MjQuNzUgcm93cz0zNzA3MTAgd2lkdGg9 ODkpIChhY3R1YWwgdGltZT0xMTk5NzA1LjU1Li4xMjA1OTc3Ljc2IHJvd3M9 MzcwMzA3IGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIE1lcmdlIENvbmQ6ICgib3V0 ZXIiLmJhdGNoZGV0YWlsaWQgPSAiaW5uZXIiLmJhdGNoZGV0YWlsaWQpDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0xNTQzMTE5LjAxLi4xNTQ0MDQ1 Ljc5IHJvd3M9MzcwNzEwIHdpZHRoPTcwKSAoYWN0dWFsIHRpbWU9MTE4MTE3 Mi43OS4uMTE4MTkwMi43NyByb3dzPTM3MDMwNyBsb29wcz0xKQ0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBTb3J0IEtleTogZC5iYXRjaGRldGFpbGlkDQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGJhdGNoZGV0YWlsX2l4 X3RyYW5hbW91bnRfaWR4IG9uIGJhdGNoZGV0YWlsIGQgIChjb3N0PTAuMDAu LjE0ODkxMDMuNDYgcm93cz0zNzA3MTAgd2lkdGg9NzApIChhY3R1YWwgdGlt ZT0xNC40NS4uMTE3NjA3NC45MCByb3dzPTM3MDMwNyBsb29wcz0xKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoKHRyYW5hbW91bnQg Pj0gNTAwLjApIEFORCAodHJhbmFtb3VudCA8PSA3MDAuMCkpDQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIC0+ICBTb3J0ICAoY29zdD0xNjA5NjYuMjUuLjE2MzMxOS41OSByb3dz PTk0MTMzNSB3aWR0aD0xOSkgKGFjdHVhbCB0aW1lPTE4NTMyLjcwLi4yMDA3 NC4wOSByb3dzPTkzODc3MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBT b3J0IEtleTogcDEuYmF0Y2hkZXRhaWxpZA0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgU2VxIFNjYW4gb24gcHVyYzEgcDEgIChjb3N0PTAuMDAuLjQ0Mjg1LjM1 IHJvd3M9OTQxMzM1IHdpZHRoPTE5KSAoYWN0dWFsIHRpbWU9OS40NC4uOTEx OS44MyByb3dzPTkzODc3MCBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU29ydCAgKGNv c3Q9MC4wMS4uMC4wMiByb3dzPTEgd2lkdGg9OSkgKGFjdHVhbCB0aW1lPTAu MDguLjAuMDggcm93cz0wIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNvcnQgS2V5 OiBkci5iYXRjaGRldGFpbGlkDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBv biBkaXJlY3QgZHIgIChjb3N0PTAuMDAuLjAuMDAgcm93cz0xIHdpZHRoPTkp IChhY3R1YWwgdGltZT0wLjAxLi4wLjAxIHJvd3M9MCBsb29wcz0xKQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U29ydCAgKGNvc3Q9MC4wMS4uMC4wMiByb3dzPTEgd2lkdGg9MTcpIChhY3R1 YWwgdGltZT0wLjA0Li4wLjA0IHJvd3M9MCBsb29wcz0xKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTb3J0 IEtleTogY3IuYmF0Y2hkZXRhaWxpZA0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24g Y2FycmVudGFsIGNyICAoY29zdD0wLjAwLi4wLjAwIHJvd3M9MSB3aWR0aD0x NykgKGFjdHVhbCB0aW1lPTAuMDAuLjAuMDAgcm93cz0wIGxvb3BzPTEpDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTb3J0 ICAoY29zdD0xMDUuOTcuLjEwOS4xMyByb3dzPTEyNjcgd2lkdGg9MzgpIChh Y3R1YWwgdGltZT00NzkuMTcuLjQ4MC43NCByb3dzPTEyNjcgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg U29ydCBLZXk6IGNrLmJhdGNoZGV0YWlsaWQNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGNo ZWNrcyBjayAgKGNvc3Q9MC4wMC4uNDAuNjcgcm93cz0xMjY3IHdpZHRoPTM4 KSAoYWN0dWFsIHRpbWU9NDQ3Ljg4Li40NzUuNjAgcm93cz0xMjY3IGxvb3Bz PTEpDQogICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBjYXJk dHlwZSBjICAoY29zdD0wLjAwLi4xLjEwIHJvd3M9MTAgd2lkdGg9MTQpIChh Y3R1YWwgdGltZT0xLjM3Li4xLjM5IHJvd3M9MTAgbG9vcHM9NSkNCiAgICAg ICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHRyYW5oZWFkZXIgdCAgKGNvc3Q9 MC4wMC4uNTUuMTUgcm93cz0xOTIzIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9 MC4wMS4uNS4xNCByb3dzPTE5MjMgbG9vcHM9NSkNCiAgICAgICAgICAgICAg ICAgICAgRmlsdGVyOiAoY2xpZW50aWQgPSA2KQ0KVG90YWwgcnVudGltZTog MTIyMjE1Ny4yOCBtc2VjDQoNCioqKioqKioqKioqKioqKioqKioqKioqDQpK dXN0IHRvIHNlZSB3aGF0IHdvdWxkIGhhcHBlbiwgSSBleGVjdXRlZDoNCiAg ICAgQUxURVIgVEFCTEUgYmF0Y2hkZXRhaWwgQUxURVIgQ09MVU1OIHRyYW5h bW91bnQgU0VUIFNUQVRJU1RJQ1MgMTAwMDsNCiAgICAgQU5BTFlaRTsNCkl0 IHNlZW1lZCB0byBodXJ0IHBlcmZvcm1hbmNlIGlmIGFueXRoaW5nLiAgQnV0 IHRoZSBFWFBMQUlOIGVzdGltYXRlIGZvciByb3dzIHdhcyBtdWNoIGNsb3Nl ciB0byB0aGUgcmVhbCB2YWx1ZSB0aGFuIGl0IHdhcyBwcmV2aW91c2x5Lg0K IA0KKioqKioqKioqKioqKioqKioqKioqKioNCkl0IHNlZW1zIHRvIG1lIHRo YXQgdGhlIGJpZywgYmlnIGlzb2xhdGVkIHByb2JsZW0gaXMgdGhlIGluZGV4 IHNjYW4gb24gYmF0Y2hkZXRhaWwudHJhbmFtb3VudC4gIER1cmluZyB0aGlz IHNtYWxsIHF1ZXJ5LCAnc2FyIC1iJyBzaG93ZWQgY29uc2lzdGVudCA5MCww MDAgYmxvY2sgcmVhZHMvc2VjLiAoY29udHJhc3Qgd2l0aCBvbmx5IDYsMDAw IHdpdGggbGFyZ2VyIHF1ZXJ5IGluZGV4IHNjYW4pLiAgJ3RvcCcgc2hvd3Mg dGhlIENQVSBpcyBhdCAyMCUgdXNlciwgMzAlIHN5c3RlbSB0aGUgd2hvbGUg dGltZSAoY29udHJhc3Qgd2l0aCAyJSB0b3RhbCBpbiBsYXJnZXIgcXVlcnkg YWJvdmUpLiAgVGhpcyByZXN1bHRzIGhlcmUgc3RpbGwgc2VlbSBwcmV0dHkg YmFkIChhbHRob3VnaCBub3QgYXMgYmFkIGFzIGFib3ZlKSwgYnV0IEkgc3Rp bGwgZG9uJ3Qga25vdyB3aGF0IGlzIHRoZSBib3R0bGVuZWNrLiAgQW5kIHRo ZSBzdHJhbmdlIHNhciBzdGF0cyBhcmUgY29uZnVzaW5nIG1lLg0KIA0KRVhQ TEFJTiBBTkFMWVpFIFNFTEVDVCAqIEZST00gYmF0Y2hkZXRhaWwgV0hFUkUg dHJhbmFtb3VudCBCRVRXRUVOIDMwMCBBTkQgNDk5Ow0KU2VxIFNjYW4gb24g YmF0Y2hkZXRhaWwgIChjb3N0PTAuMDAuLjIwMTg3OTcuMTEgcm93cz03ODMy OTEgd2lkdGg9NDQwKSAoYWN0dWFsIHRpbWU9NDUuNjYuLjI4MzkyNi41OCBy b3dzPTc4MzY4NyBsb29wcz0xKQ0KICBGaWx0ZXI6ICgodHJhbmFtb3VudCA+ PSAzMDA6Om51bWVyaWMpIEFORCAodHJhbmFtb3VudCA8PSA0OTk6Om51bWVy aWMpKQ0KVG90YWwgcnVudGltZTogMjg1MDMyLjQ3IG1zZWMNCg0KIA0KKioq KioqKioqKioqKioqKioqKioqKioNCj4gU3RlcGhhbiBTemFibyB3cm90ZToN Cj4gQXMgYSBmb2xsb3d1cCwgaWYgeW91IGRvIHNldCBlbmFibGVfaW5kZXhz Y2FuPW9mZjsNCj4gYmVmb3JlIHJ1bm5pbmcgdGhlIGV4cGxhaW4gYW5hbHl6 ZSwgd2hhdCBkb2VzIHRoYXQgZ2l2ZSB5b3U/DQoNCk5vdyB0aGlzIGlzIHZl cnkgaW50ZXJlc3Rpbmc6ICdzYXIgLWInIHNob3dzIGFib3V0IDk1LDAwMCBi bG9jayByZWFkcy9zZWM7IENQVSBpcyBhdCAyMCUgdXNlciAzMCUgc3lzdGVt LCB2bXN0YXQgc2hvd3Mgbm8gc3dhcHBpbmcsIHF1ZXJ5IHRha2VzIG9ubHkg NSBtaW51dGVzIHRvIGV4ZWN1dGUgKHdoaWNoIGlzIG9uZS1xdWFydGVyIG9m IHRoZSB0aW1lIFdJVEggdGhlIGluZGV4IHNjYW4hISEhKS4gIE9idmlvdXNs eSB0aGUgZXhlY3V0aW9uIHBsYW4gaXMgcHJldHR5IGRpZmZlcmVudCBvbiB0 aGlzIG9uZSAocXVlcnkgaXMgaWRlbnRpY2FsIHRoZSBsYXJnZXIgb25lIGFi b3ZlKS4NCiANCkVYUExBSU4gQU5BTFlaRQ0KU0VMRUNUIGIuYmF0Y2hkYXRl LCBkLmJhdGNoZGV0YWlsaWQsIHQuYmFua25vLCBkLnRyYW5kYXRlLCBkLnRy YW5hbW91bnQsDQpkLnN1Ym1pdGludGVyY2hhbmdlLCBkLmF1dGhhbW91bnQs IGQuYXV0aG5vLCBkLmNhcmR0eXBlaWQsIGQubWNjY29kZSwNCm0ubmFtZSBB UyBtZXJjaGFudG5hbWUsIGMuY2FyZHR5cGUsIG0ubWVyY2hpZCwNCnAxLmxv Y2FsdGF4YW1vdW50LCBwMS5wcm9kdWN0aWRlbnRpZmllciwgZHIuYXZzcmVz cG9uc2UsDQpjci5jaGVja291dGRhdGUsIGNyLm5vc2hvd2luZGljYXRvciwg Y2suY2hlY2tpbmdhY2N0bm8sDQpjay5hYmFyb3V0aW5nbm8sIGNrLmNoZWNr bm8NCkZST00gdHJhbmhlYWRlciB0LCBiYXRjaGhlYWRlciBiLCBtZXJjaGFu dHMgbSwgY2FyZHR5cGUgYywNCmJhdGNoZGV0YWlsIGQNCkxFRlQgSk9JTiBw dXJjMSBwMSBvbiBwMS5iYXRjaGRldGFpbGlkPWQuYmF0Y2hkZXRhaWxpZA0K TEVGVCBKT0lOIGRpcmVjdCBkciBPTiBkci5iYXRjaGRldGFpbGlkID0gZC5i YXRjaGRldGFpbGlkDQpMRUZUIEpPSU4gY2FycmVudGFsIGNyIE9OIGNyLmJh dGNoZGV0YWlsaWQgPSBkLmJhdGNoZGV0YWlsaWQNCkxFRlQgSk9JTiBjaGVj a3MgY2sgT04gY2suYmF0Y2hkZXRhaWxpZCA9IGQuYmF0Y2hkZXRhaWxpZA0K V0hFUkUgdC50cmFuaGVhZGVyaWQ9Yi50cmFuaGVhZGVyaWQNCkFORCBtLm1l cmNoYW50aWQ9Yi5tZXJjaGFudGlkDQpBTkQgZC5iYXRjaGlkPWIuYmF0Y2hp ZA0KQU5EIGMuY2FyZHR5cGVpZD1kLmNhcmR0eXBlaWQNCkFORCB0LmNsaWVu dGlkID0gNg0KQU5EIGQudHJhbmFtb3VudCBCRVRXRUVOIDUwMC4wIEFORCA3 MDAuMA0KQU5EIGIuYmF0Y2hkYXRlID4gJzIwMDItMTItMTUnDQpBTkQgbS5t ZXJjaGlkID0gJzcwMTI1MjI2NycNCk9SREVSIEJZIGIuYmF0Y2hkYXRlIERF U0MNCkxJTUlUIDUwDQpMaW1pdCAgKGNvc3Q9MjMyMTQ2MC41Ni4uMjMyMTQ2 MC41NyByb3dzPTEgd2lkdGg9Mjg1KSAoYWN0dWFsIHRpbWU9MzA4MTk0LjU3 Li4zMDgxOTQuNTkgcm93cz01IGxvb3BzPTEpDQogIC0+ICBTb3J0ICAoY29z dD0yMzIxNDYwLjU2Li4yMzIxNDYwLjU3IHJvd3M9MSB3aWR0aD0yODUpIChh Y3R1YWwgdGltZT0zMDgxOTQuNTcuLjMwODE5NC41OCByb3dzPTUgbG9vcHM9 MSkNCiAgICAgICAgU29ydCBLZXk6IGIuYmF0Y2hkYXRlDQogICAgICAgIC0+ ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MjMxOTUyNi41Ny4uMjMyMTQ2MC41NSBy b3dzPTEgd2lkdGg9Mjg1KSAoYWN0dWFsIHRpbWU9MzA3OTg4LjU2Li4zMDgx OTQuNDYgcm93cz01IGxvb3BzPTEpDQogICAgICAgICAgICAgIEpvaW4gRmls dGVyOiAoImlubmVyIi50cmFuaGVhZGVyaWQgPSAib3V0ZXIiLnRyYW5oZWFk ZXJpZCkNCiAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0y MzE5NTI2LjU3Li4yMzIxMzgxLjM3IHJvd3M9MSB3aWR0aD0yNjkpIChhY3R1 YWwgdGltZT0zMDc5ODIuODAuLjMwODE1My4yMiByb3dzPTUgbG9vcHM9MSkN CiAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgiaW5uZXIiLmNh cmR0eXBlaWQgPSAib3V0ZXIiLmNhcmR0eXBlaWQpDQogICAgICAgICAgICAg ICAgICAgIC0+ICBNZXJnZSBKb2luICAoY29zdD0yMzE5NTI2LjU3Li4yMzIx MzgwLjE0IHJvd3M9MSB3aWR0aD0yNTUpIChhY3R1YWwgdGltZT0zMDc5ODIu NjkuLjMwODE1Mi44MiByb3dzPTUgbG9vcHM9MSkNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgTWVyZ2UgQ29uZDogKCJvdXRlciIuYmF0Y2hpZCA9ICJp bm5lciIuYmF0Y2hpZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IFNvcnQgIChjb3N0PTIzMTYzODguNzAuLjIzMTczMTUuNDcgcm93cz0zNzA3 MTAgd2lkdGg9MTUzKSAoYWN0dWFsIHRpbWU9MzA1OTc2Ljc0Li4zMDY2MjIu ODggcm93cz0zNjg2ODEgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgU29ydCBLZXk6IGQuYmF0Y2hpZA0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MjIz Mzg4NC45MC4uMjI0MzM2OC4xNSByb3dzPTM3MDcxMCB3aWR0aD0xNTMpIChh Y3R1YWwgdGltZT0yODY0NTIuMTIuLjI5OTQ4NS40MyByb3dzPTM3MDMwNyBs b29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBNZXJnZSBDb25kOiAoIm91dGVyIi5iYXRjaGRldGFpbGlkID0gImlubmVy Ii5iYXRjaGRldGFpbGlkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MjIzMzc3OC45My4u MjI0MjM3MS45OCByb3dzPTM3MDcxMCB3aWR0aD0xMTUpIChhY3R1YWwgdGlt ZT0yODY0MjguNzcuLjI5NjkzOS42NiByb3dzPTM3MDMwNyBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBN ZXJnZSBDb25kOiAoIm91dGVyIi5iYXRjaGRldGFpbGlkID0gImlubmVyIi5i YXRjaGRldGFpbGlkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgTWVyZ2UgSm9pbiAgKGNvc3Q9MjIzMzc3OC45 Mi4uMjI0MTQ0NS4xOSByb3dzPTM3MDcxMCB3aWR0aD05OCkgKGFjdHVhbCB0 aW1lPTI4NjQyOC43Mi4uMjk0NzUwLjAxIHJvd3M9MzcwMzA3IGxvb3BzPTEp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIE1lcmdlIENvbmQ6ICgib3V0ZXIiLmJhdGNoZGV0YWlsaWQgPSAi aW5uZXIiLmJhdGNoZGV0YWlsaWQpDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBNZXJnZSBKb2luICAo Y29zdD0yMjMzNzc4LjkxLi4yMjQwNTE4LjQwIHJvd3M9MzcwNzEwIHdpZHRo PTg5KSAoYWN0dWFsIHRpbWU9Mjg2NDI4LjYwLi4yOTI2MDYuNTYgcm93cz0z NzAzMDcgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgTWVyZ2UgQ29uZDogKCJvdXRl ciIuYmF0Y2hkZXRhaWxpZCA9ICJpbm5lciIuYmF0Y2hkZXRhaWxpZCkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgLT4gIFNvcnQgIChjb3N0PTIwNzI4MTIuNjYuLjIwNzM3Mzku NDQgcm93cz0zNzA3MTAgd2lkdGg9NzApIChhY3R1YWwgdGltZT0yNjk3Mzgu MzQuLjI3MDQ3MC44MyByb3dzPTM3MDMwNyBsb29wcz0xKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBTb3J0IEtleTogZC5iYXRjaGRldGFpbGlkDQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBTZXEgU2NhbiBvbiBiYXRjaGRldGFpbCBkICAoY29zdD0w LjAwLi4yMDE4Nzk3LjExIHJvd3M9MzcwNzEwIHdpZHRoPTcwKSAoYWN0dWFs IHRpbWU9NDEuNjYuLjI2NjU2OC44MyByb3dzPTM3MDMwNyBsb29wcz0xKQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgodHJhbmFtb3VudCA+ PSA1MDAuMCkgQU5EICh0cmFuYW1vdW50IDw9IDcwMC4wKSkNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgLT4gIFNvcnQgIChjb3N0PTE2MDk2Ni4yNS4uMTYzMzE5LjU5IHJvd3M9 OTQxMzM1IHdpZHRoPTE5KSAoYWN0dWFsIHRpbWU9MTY2OTAuMjAuLjE4MjAy LjY1IHJvd3M9OTM4NzcwIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNv cnQgS2V5OiBwMS5iYXRjaGRldGFpbGlkDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBTZXEgU2NhbiBvbiBwdXJjMSBwMSAgKGNvc3Q9MC4wMC4uNDQyODUuMzUg cm93cz05NDEzMzUgd2lkdGg9MTkpIChhY3R1YWwgdGltZT02Ljg4Li43Nzc5 LjMxIHJvd3M9OTM4NzcwIGxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTb3J0ICAoY29z dD0wLjAxLi4wLjAyIHJvd3M9MSB3aWR0aD05KSAoYWN0dWFsIHRpbWU9MC4x MC4uMC4xMCByb3dzPTAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgU29ydCBLZXk6 IGRyLmJhdGNoZGV0YWlsaWQNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9u IGRpcmVjdCBkciAgKGNvc3Q9MC4wMC4uMC4wMCByb3dzPTEgd2lkdGg9OSkg KGFjdHVhbCB0aW1lPTAuMDAuLjAuMDAgcm93cz0wIGxvb3BzPTEpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBT b3J0ICAoY29zdD0wLjAxLi4wLjAyIHJvd3M9MSB3aWR0aD0xNykgKGFjdHVh bCB0aW1lPTAuMDMuLjAuMDMgcm93cz0wIGxvb3BzPTEpDQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFNvcnQg S2V5OiBjci5iYXRjaGRldGFpbGlkDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBj YXJyZW50YWwgY3IgIChjb3N0PTAuMDAuLjAuMDAgcm93cz0xIHdpZHRoPTE3 KSAoYWN0dWFsIHRpbWU9MC4wMC4uMC4wMCByb3dzPTAgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNvcnQg IChjb3N0PTEwNS45Ny4uMTA5LjEzIHJvd3M9MTI2NyB3aWR0aD0zOCkgKGFj dHVhbCB0aW1lPTIzLjMyLi4yNC44OSByb3dzPTEyNjcgbG9vcHM9MSkNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgU29y dCBLZXk6IGNrLmJhdGNoZGV0YWlsaWQNCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGNoZWNr cyBjayAgKGNvc3Q9MC4wMC4uNDAuNjcgcm93cz0xMjY3IHdpZHRoPTM4KSAo YWN0dWFsIHRpbWU9Ni41MS4uMTkuNTkgcm93cz0xMjY3IGxvb3BzPTEpDQog ICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0zMTM3 Ljg3Li4zMTM3Ljg4IHJvd3M9NCB3aWR0aD0xMDIpIChhY3R1YWwgdGltZT05 NTQuMTguLjk1NC4yMCByb3dzPTE5IGxvb3BzPTEpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIFNvcnQgS2V5OiBiLmJhdGNoaWQNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAo Y29zdD0wLjAwLi4zMTM3Ljg0IHJvd3M9NCB3aWR0aD0xMDIpIChhY3R1YWwg dGltZT0yMzYuMjYuLjk1NC4wNCByb3dzPTE3IGxvb3BzPTEpDQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBv biBtZXJjaGFudHMgbSAgKGNvc3Q9MC4wMC4uMjY2Ny4zNSByb3dzPTEgd2lk dGg9NzgpIChhY3R1YWwgdGltZT0yLjQ4Li4yMjcuNzEgcm93cz0xIGxvb3Bz PTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIEZpbHRlcjogKG1lcmNoaWQgPSAnNzAxMjUyMjY3Jzo6Y2hhcmFjdGVy IHZhcnlpbmcpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGJhdGNoaGVhZGVyX2l4X21lcmNo YW50aWRfaWR4IG9uIGJhdGNoaGVhZGVyIGIgIChjb3N0PTAuMDAuLjQ3MC4z MCByb3dzPTE1IHdpZHRoPTI0KSAoYWN0dWFsIHRpbWU9MjMzLjc1Li43MjYu MjIgcm93cz0xNyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoIm91dGVyIi5tZXJj aGFudGlkID0gYi5tZXJjaGFudGlkKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChiYXRjaGRhdGUgPiAn MjAwMi0xMi0xNSAwMDowMDowMCc6OnRpbWVzdGFtcCB3aXRob3V0IHRpbWUg em9uZSkNCiAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIGNh cmR0eXBlIGMgIChjb3N0PTAuMDAuLjEuMTAgcm93cz0xMCB3aWR0aD0xNCkg KGFjdHVhbCB0aW1lPTAuMDIuLjAuMDQgcm93cz0xMCBsb29wcz01KQ0KICAg ICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gdHJhbmhlYWRlciB0ICAoY29z dD0wLjAwLi41NS4xNSByb3dzPTE5MjMgd2lkdGg9MTYpIChhY3R1YWwgdGlt ZT0wLjAxLi41LjIxIHJvd3M9MTkyMyBsb29wcz01KQ0KICAgICAgICAgICAg ICAgICAgICBGaWx0ZXI6IChjbGllbnRpZCA9IDYpDQpUb3RhbCBydW50aW1l OiAzMDgzMjMuNjAgbXNlYw0KDQoqKioqKioqKioqKioqKioqKioqKioqKg0K SSBob3BlIHdlIGNhbiBjb21lIHVwIHdpdGggc29tZXRoaW5nIHNvb24uLi4u Lml0IHNlZW1zIHRoaXMgaW5kZXggc2NhbiBpcyBhIGJpZyBwYXJ0IG9mIHRo ZSBwcm9ibGVtLiAgSSdtIHN0aWxsIHJlYWxseSBjdXJpb3VzIHdoeSB0aGUg ZGlzayByZWFkcyBhcmUgc28gZmV3IHdpdGggdGhlIGluZGV4IHNjYW4uICBM ZXQncyBob3BlIEkgY2FuIGdldCBpdCBuZWFyIHRoZSAzIHNlY29uZCB0aW1l IGZvciBNU1NRTCBieSBGcmlkYXkhDQogDQpSb21hbiBGYWlsDQogDQo=