Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BC17863523A for ; Wed, 4 Mar 2009 19:21:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21376-06-3 for ; Wed, 4 Mar 2009 19:20:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.30]) by mail.postgresql.org (Postfix) with ESMTP id 08FEA634A64 for ; Wed, 4 Mar 2009 19:20:50 -0400 (AST) Received: by yw-out-2324.google.com with SMTP id 5so2023339ywh.73 for ; Wed, 04 Mar 2009 15:20:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=soxCPh/+xEmDDYoqVKEiAay5je7IqN6o6NYcK8tJRmM=; b=aAkTeVaa7jkWEbQyHnZsghBhYHdYZ4Yb3Qjtd5wI+FtAjwib+GhwKCjM50IA7zJnO4 VMmEI6lndsq5lphu/6M6JZEsT74rcBpZUJGWrQx5OUfDs5C2fpFzEUP15RWDSv5CnDxc SfX8Ju2/4YHk4gpAkA+lkOt9ce6uu1VKeLlmI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=iOerDS5Ybw575yJ6fTTmIbrs4JtzhARG9t3NUmZqPLrCY5zzJolJZOpN4UJXxo+jof CVmWDI/4MJYuLT9ymtwD3jcRU8oQpJVCBAUj9tN6U1vzb/nrQasOANesfc70Rk6HjVIS U+FVT6dN3vP15Tl4R88L5SaXSdjEPHkJ8bYUU= MIME-Version: 1.0 Received: by 10.100.239.11 with SMTP id m11mr395152anh.103.1236208849621; Wed, 04 Mar 2009 15:20:49 -0800 (PST) In-Reply-To: <17797.1236119652@sss.pgh.pa.us> References: <2870.1236050632@sss.pgh.pa.us> <17797.1236119652@sss.pgh.pa.us> Date: Wed, 4 Mar 2009 18:20:49 -0500 Message-ID: Subject: Re: Postgres 8.3, four times slower queries? From: Aaron Guyon To: pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary=0016368e24fc5999da0464534d3b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/46 X-Sequence-Number: 32968 --0016368e24fc5999da0464534d3b Content-Type: multipart/alternative; boundary=0016368e24fc5999c70464534d39 --0016368e24fc5999c70464534d39 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Tue, Mar 3, 2009 at 5:34 PM, Tom Lane wrote: > Comparisons on > numerics aren't terribly fast though (in either release). I wonder > whether you could change the key columns to int or bigint. I changed the affected columns from numeric to integers and I was unable to get any performance gain: 8.3.3: 1195 ms 8.2.12: 611 ms I've attached the new query plans. Are you doing > something to force the join order, like running with a small > join_collapse_limit setting? If so maybe you shouldn't. > No, we left the join_collapse_limit to the default 8. We tried a higher value, but there was no difference in performance. I'll post the query and the table descriptions in separate messages to the list to avoid my mail from being rejected for exceeding the size limit :) --0016368e24fc5999c70464534d39 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On Tue, Mar 3, 2009 at 5:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Comparisons on
numerics aren't terribly fast though (in either release). =A0I wonder whether you could change the key columns to int or bigint.

I changed the affected columns from numeric to integers and I was unab= le to get any performance gain:
8.3.3: 1195 ms
8.2.12: 611 ms

I've attached the new query plans.

Are you doing
something to force the join order, like running with a small
join_collapse_limit setting? =A0If so maybe you shouldn't.

No, we left the join_collapse_limit to the default 8= .=A0 We tried a higher value, but there was no difference in performance.
I'll post the query and the table descriptions in separate messag= es to the list to avoid my mail from being rejected for exceeding the size = limit :)
--0016368e24fc5999c70464534d39-- --0016368e24fc5999da0464534d3b Content-Type: text/plain; charset=US-ASCII; name="analyze_8_2_12_ints.txt" Content-Disposition: attachment; filename="analyze_8_2_12_ints.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_frwmgqro0 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD02OTg2LjAxLi42OTg2LjAyIHJv d3M9MSB3aWR0aD0yMCkgKGFjdHVhbCB0aW1lPTYxMS4wNjEuLjYxMS4wNjEgcm93cz0wIGxvb3Bz PTEpCiAgIC0+ICBTb3J0ICAoY29zdD02OTg2LjAxLi42OTg2LjAyIHJvd3M9MSB3aWR0aD0yMCkg KGFjdHVhbCB0aW1lPTYxMS4wNTMuLjYxMS4wNTMgcm93cz0wIGxvb3BzPTEpCiAgICAgICAgIFNv cnQgS2V5OiB0OC5pZAogICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTk1NS45MC4uNjk4 Ni4wMCByb3dzPTEgd2lkdGg9MjApIChhY3R1YWwgdGltZT02MTAuOTQyLi42MTAuOTQyIHJvd3M9 MCBsb29wcz0xKQogICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9kaWZpZWRf c2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkv TU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190 aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpT Uyc6OnRleHQpKSBPUiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAw OS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9S ICh0Ny5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5 OjU3Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5vdF9tb2Rp ZmllZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAn WVlZWS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3NpbmNlID49 IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhI Ok1JOlNTJzo6dGV4dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFt cCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4 dCkpIE9SICh0MTEubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0y NFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQogICAgICAg ICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTk1NS45MC4uNDk4OS4yNyByb3dzPTUyMyB3 aWR0aD03NikgKGFjdHVhbCB0aW1lPTI4LjI3NC4uNTQ4LjY2NCByb3dzPTExMDQgbG9vcHM9MSkK ICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggSm9pbiAgKGNvc3Q9OTU1LjkwLi4zMTk1LjU2 IHJvd3M9NTI2IHdpZHRoPTUyKSAoYWN0dWFsIHRpbWU9MjguMTIzLi41MjAuNjIwIHJvd3M9MTEw NCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICBIYXNoIENvbmQ6ICh0Ni5zY2hl ZHVsZV9pZCA9IHQ3LmlkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4g b24gYnVuZGxlIHQ2ICAoY29zdD0wLjAwLi4yMDAyLjY5IHJvd3M9NjE3ODkgd2lkdGg9MTYpIChh Y3R1YWwgdGltZT0wLjAyNi4uMjUzLjM2MCByb3dzPTYwOTIwIGxvb3BzPTEpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8PiAwKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNvc3Q9OTU0LjE1Li45NTQuMTUgcm93cz0xNDAgd2lk dGg9NDQpIChhY3R1YWwgdGltZT0yNS43OTUuLjI1Ljc5NSByb3dzPTMzMiBsb29wcz0xKQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAu Ljk1NC4xNSByb3dzPTE0MCB3aWR0aD00NCkgKGFjdHVhbCB0aW1lPTAuNTQ2Li4yNC4zNjQgcm93 cz0zMzIgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi41NjIuNjIgcm93cz0xMDAgd2lkdGg9NDApIChhY3R1 YWwgdGltZT0wLjQ3MS4uMTUuNzU5IHJvd3M9MzM2IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4wMC4u NzQuNDAgcm93cz0xNTYgd2lkdGg9MjgpIChhY3R1YWwgdGltZT0wLjIzMy4uNi40MDQgcm93cz0z NzYgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjAwLi40NS4wNCByb3dzPTQgd2lkdGg9MjAp IChhY3R1YWwgdGltZT0wLjE1Ny4uMC4zMjQgcm93cz00IGxvb3BzPTEpCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIGlkeF9kYXlfcGFydF9kdSBvbiBkYXlfcGFydCB0MTAgIChjb3N0PTAuMDAuLjcuMzAg cm93cz02IHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wNzYuLjAuMTA4IHJvd3M9NyBsb29wcz0x KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICBJbmRleCBDb25kOiAoZGlzcGxheV91bml0X2lkID0gMjUwODkzKQogICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0 ZXI6IChhY3RpdmUgPD4gMCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3NraW5fZGF5X3BhcnRf aWQgb24gc2tpbiB0MiAgKGNvc3Q9MC4wMC4uNi4yOCByb3dzPTEgd2lkdGg9MTYpIChhY3R1YWwg dGltZT0wLjAxNi4uMC4wMTggcm93cz0xIGxvb3BzPTcpCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0Mi5k YXlfcGFydF9pZCA9IHQxMC5pZCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDApCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2Fu IHVzaW5nIGlkeF9za2luX3Nsb3Rfc2tpbl9pZCBvbiBza2luX3Nsb3QgdDExICAoY29zdD0wLjAw Li42LjA5IHJvd3M9MTAwIHdpZHRoPTE2KSAoYWN0dWFsIHRpbWU9MC4wMzAuLjAuODE3IHJvd3M9 OTQgbG9vcHM9NCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKHQyLmlkID0gdDExLnNraW5faWQpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFj dGl2ZSA8PiAwKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgSW5kZXggU2NhbiB1c2luZyBsb29wX3Nsb3RfcGtleSBvbiBsb29wX3Nsb3QgdDMgIChjb3N0 PTAuMDAuLjMuMTIgcm93cz0xIHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMDcuLjAuMDExIHJv d3M9MSBsb29wcz0zNzYpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEluZGV4IENvbmQ6ICh0MTEuc2xvdF9pZCA9IHQzLmlkKQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6IChhY3RpdmUgPD4g MCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4g dXNpbmcgaWR4X3NjaGVkdWxlX293bmVyX3Jlc291cmNlX2lkIG9uIHNjaGVkdWxlIHQ3ICAoY29z dD0wLjAwLi4zLjkwIHJvd3M9MSB3aWR0aD0xNikgKGFjdHVhbCB0aW1lPTAuMDA3Li4wLjAxMSBy b3dzPTEgbG9vcHM9MzM2KQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAodDMuaWQgPSB0Ny5vd25lcl9yZXNvdXJjZV9pZCkKICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDAp CiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9idW5kbGVfY29u dGVudF9idW5kbGVfaWQgb24gYnVuZGxlX2NvbnRlbnQgdDggIChjb3N0PTAuMDAuLjMuNDAgcm93 cz0xIHdpZHRoPTI4KSAoYWN0dWFsIHRpbWU9MC4wMDcuLjAuMDExIHJvd3M9MSBsb29wcz0xMTA0 KQogICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDYuaWQgPSB0OC5idW5k bGVfaWQpCiAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGNvbnRlbnRfcGtleSBv biBjb250ZW50IHQ5ICAoY29zdD0wLjAwLi4zLjc3IHJvd3M9MSB3aWR0aD0xMikgKGFjdHVhbCB0 aW1lPTAuMDA3Li4wLjAxMSByb3dzPTEgbG9vcHM9MTEwNCkKICAgICAgICAgICAgICAgICAgICAg SW5kZXggQ29uZDogKHQ4LmNvbnRlbnRfaWQgPSB0OS5pZCkKIFRvdGFsIHJ1bnRpbWU6IDYxMS42 ODAgbXMKKDM1IHJvd3MpCgo= --0016368e24fc5999da0464534d3b Content-Type: text/plain; charset=US-ASCII; name="analyze_8_3_3_ints.txt" Content-Disposition: attachment; filename="analyze_8_3_3_ints.txt" Content-Transfer-Encoding: base64 X-Attachment-Id: f_frwmguu51 ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogVW5pcXVlICAoY29zdD02ODkxLjg5Li42ODkxLjkwIHJv d3M9MSB3aWR0aD0yMCkgKGFjdHVhbCB0aW1lPTExOTQuODExLi4xMTk0LjgxMSByb3dzPTAgbG9v cHM9MSkKICAgLT4gIFNvcnQgIChjb3N0PTY4OTEuODkuLjY4OTEuODkgcm93cz0xIHdpZHRoPTIw KSAoYWN0dWFsIHRpbWU9MTE5NC44MDMuLjExOTQuODAzIHJvd3M9MCBsb29wcz0xKQogICAgICAg ICBTb3J0IEtleTogdDguaWQKICAgICAgICAgU29ydCBNZXRob2Q6ICBxdWlja3NvcnQgIE1lbW9y eTogMTdrQgogICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTMxMDguNjMuLjY4OTEuODgg cm93cz0xIHdpZHRoPTIwKSAoYWN0dWFsIHRpbWU9MTE5NC43MzMuLjExOTQuNzMzIHJvd3M9MCBs b29wcz0xKQogICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCh0Mi5ub3RfbW9kaWZpZWRfc2lu Y2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3Jzo6dGV4dCwgJ1lZWVkvTU0v REQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQzLm5vdF9tb2RpZmllZF9zaW5jZSA+PSB0b190aW1l c3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZWS9NTS9ERCBISDpNSTpTUyc6 OnRleHQpKSBPUiAodDYubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0w Mi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpIE9SICh0 Ny5ub3RfbW9kaWZpZWRfc2luY2UgPj0gdG9fdGltZXN0YW1wKCcyMDA5LTAyLTI0VDExOjE5OjU3 Jzo6dGV4dCwgJ1lZWVkvTU0vREQgSEg6TUk6U1MnOjp0ZXh0KSkgT1IgKHQ4Lm5vdF9tb2RpZmll ZF9zaW5jZSA+PSB0b190aW1lc3RhbXAoJzIwMDktMDItMjRUMTE6MTk6NTcnOjp0ZXh0LCAnWVlZ WS9NTS9ERCBISDpNSTpTUyc6OnRleHQpKSBPUiAodDkubm90X21vZGlmaWVkX3NpbmNlID49IHRv X3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1J OlNTJzo6dGV4dCkpIE9SICh0MTAubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgn MjAwOS0wMi0yNFQxMToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkp IE9SICh0MTEubm90X21vZGlmaWVkX3NpbmNlID49IHRvX3RpbWVzdGFtcCgnMjAwOS0wMi0yNFQx MToxOTo1Nyc6OnRleHQsICdZWVlZL01NL0REIEhIOk1JOlNTJzo6dGV4dCkpKQogICAgICAgICAg ICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0zMTA4LjYzLi40ODE2LjU3IHJvd3M9NTcxIHdpZHRo PTc2KSAoYWN0dWFsIHRpbWU9Nzk5LjExNC4uMTEzNS41MjQgcm93cz0xMTA0IGxvb3BzPTEpCiAg ICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKHQ4LmJ1bmRsZV9pZCA9IHQ2LmlkKQogICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gYnVuZGxlX2NvbnRlbnQgdDggIChjb3N0 PTAuMDAuLjE0NDEuMTcgcm93cz02OTYxNyB3aWR0aD0yOCkgKGFjdHVhbCB0aW1lPTAuMDQyLi4y NjMuODE1IHJvd3M9Njk2MTcgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2gg IChjb3N0PTMxMDEuNDQuLjMxMDEuNDQgcm93cz01NzUgd2lkdGg9NTIpIChhY3R1YWwgdGltZT01 OTMuMjI3Li41OTMuMjI3IHJvd3M9MTEwNCBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAg ICAgICAtPiAgSGFzaCBKb2luICAoY29zdD05NzUuNjIuLjMxMDEuNDQgcm93cz01NzUgd2lkdGg9 NTIpIChhY3R1YWwgdGltZT05OC43MzkuLjU4OC4zODkgcm93cz0xMTA0IGxvb3BzPTEpCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKHQ2LnNjaGVkdWxlX2lkID0g dDcuaWQpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBi dW5kbGUgdDYgIChjb3N0PTAuMDAuLjE4OTEuNjkgcm93cz02MDkwMSB3aWR0aD0xNikgKGFjdHVh bCB0aW1lPTAuMDM1Li4yNDkuOTkzIHJvd3M9NjA5MjAgbG9vcHM9MSkKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDApCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD05NzMuNjYuLjk3My42NiByb3dz PTE1NyB3aWR0aD00NCkgKGFjdHVhbCB0aW1lPTk2LjQwNC4uOTYuNDA0IHJvd3M9MzMyIGxvb3Bz PTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9v cCAgKGNvc3Q9ODQuMjcuLjk3My42NiByb3dzPTE1NyB3aWR0aD00NCkgKGFjdHVhbCB0aW1lPTIz LjAyMC4uOTQuOTI0IHJvd3M9MzMyIGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTg0LjI3Li41MzkuMzIgcm93 cz0xMjAgd2lkdGg9NDApIChhY3R1YWwgdGltZT0yMi44ODEuLjg2LjIyNSByb3dzPTMzNiBsb29w cz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBI YXNoIENvbmQ6ICh0My5pZCA9IHQxMS5zbG90X2lkKQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gbG9vcF9zbG90IHQzICAo Y29zdD0wLjAwLi4zNjIuNTYgcm93cz05MTI5IHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wNTIu LjM4LjUwMSByb3dzPTg5NTEgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVyOiAoYWN0aXZlIDw+IDApCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29z dD04MS45Ny4uODEuOTcgcm93cz0xODQgd2lkdGg9MjgpIChhY3R1YWwgdGltZT0xMy4zNzkuLjEz LjM3OSByb3dzPTM3NiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjgxLjk3 IHJvd3M9MTg0IHdpZHRoPTI4KSAoYWN0dWFsIHRpbWU9My4xODguLjExLjcxNiByb3dzPTM3NiBs b29wcz0xKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMDAuLjUxLjk4IHJvd3M9NCB3 aWR0aD0yMCkgKGFjdHVhbCB0aW1lPTAuMzA5Li4wLjQ5OSByb3dzPTQgbG9vcHM9MSkKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X2RheV9wYXJ0X2R1IG9uIGRheV9wYXJ0IHQx MCAgKGNvc3Q9MC4wMC4uNy45NiByb3dzPTcgd2lkdGg9MTIpIChhY3R1YWwgdGltZT0wLjE4MS4u MC4yMTUgcm93cz03IGxvb3BzPTEpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6IChkaXNw bGF5X3VuaXRfaWQgPSAyNTA4OTMpCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKGFjdGl2ZSA8 PiAwKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2tpbl9kYXlfcGFydF9p ZCBvbiBza2luIHQyICAoY29zdD0wLjAwLi42LjI4IHJvd3M9MSB3aWR0aD0xNikgKGFjdHVhbCB0 aW1lPTAuMDI0Li4wLjAyNyByb3dzPTEgbG9vcHM9NykKICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXgg Q29uZDogKHQyLmRheV9wYXJ0X2lkID0gdDEwLmlkKQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6 ICh0Mi5hY3RpdmUgPD4gMCkKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgaWR4X3NraW5fc2xv dF9za2luX2lkIG9uIHNraW5fc2xvdCB0MTEgIChjb3N0PTAuMDAuLjYuMTYgcm93cz0xMDcgd2lk dGg9MTYpIChhY3R1YWwgdGltZT0wLjcyOS4uMi4xMDAgcm93cz05NCBsb29wcz00KQogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBJbmRleCBDb25kOiAodDExLnNraW5faWQgPSB0Mi5pZCkKICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgRmlsdGVy OiAodDExLmFjdGl2ZSA8PiAwKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfc2NoZWR1bGVfb3duZXJfcmVzb3VyY2Vf aWQgb24gc2NoZWR1bGUgdDcgIChjb3N0PTAuMDAuLjMuNjEgcm93cz0xIHdpZHRoPTE2KSAoYWN0 dWFsIHRpbWU9MC4wMDcuLjAuMDExIHJvd3M9MSBsb29wcz0zMzYpCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0Ny5vd25lcl9y ZXNvdXJjZV9pZCA9IHQzLmlkKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICBGaWx0ZXI6ICh0Ny5hY3RpdmUgPD4gMCkKICAgICAgICAgICAgICAgLT4g IEluZGV4IFNjYW4gdXNpbmcgY29udGVudF9wa2V5IG9uIGNvbnRlbnQgdDkgIChjb3N0PTAuMDAu LjMuNTggcm93cz0xIHdpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMDcuLjAuMDExIHJvd3M9MSBs b29wcz0xMTA0KQogICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAodDkuaWQgPSB0OC5j b250ZW50X2lkKQogVG90YWwgcnVudGltZTogMTE5NS42MTUgbXMKKDM4IHJvd3MpCgo= --0016368e24fc5999da0464534d3b--