Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YXtE9-0000jt-7B for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 15:16:17 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YXtE8-0002vp-AK for pgsql-performance@arkaria.postgresql.org; Tue, 17 Mar 2015 15:16:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YXtE4-0002pl-Ep for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 15:16:12 +0000 Received: from mail-oi0-x229.google.com ([2607:f8b0:4003:c06::229]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YXtDz-0001gB-1w for pgsql-performance@postgresql.org; Tue, 17 Mar 2015 15:16:11 +0000 Received: by oigv203 with SMTP id v203so10888058oig.3 for ; Tue, 17 Mar 2015 08:16:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zetainteractive.com; s=google; h=reply-to:from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to:content-type; bh=41P8ImaxbGUgaoEcNTY36jyg6Fo4WUTNY1Su3Xdqdko=; b=iIQ4/q7Hr/oknbSDFA7vmlUxiK7ldssfoRhaaASpO1F+msK33ZMV1AxefIfcEk0pwX vDjRDZqO0eJpdqPGtXzkPWeqpIbP11+u0o3SYDXUDgg8Wu3erX+zPsSWmS8w0cQdKlGJ ikz20XBOQsqWpVU9zZYgkvubH/vprkwynUzfQ= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:reply-to:from:references:in-reply-to :mime-version:thread-index:date:message-id:subject:to:content-type; bh=41P8ImaxbGUgaoEcNTY36jyg6Fo4WUTNY1Su3Xdqdko=; b=EN3g/qY279cW+uWDVFV5ZpTEaywKGbZMNlEQ+0MTqUAEWuQEITMfvJkPKjWYMHe5QW UHCczgbF+bLiiZOztyrFPgpyuKMJA9M99zWIxDHt1GsACqQx1FpcISZlNuWjKi11dNR+ sBYt+jJBU5beShqXc4QGPO48kkryN3LOH1+eOtiw+eL/3bqgGpVhvv2CMR+5DBYFarhO hmk1dSN90Dq+eEbGo1svoE4tdbDryYrUFOO2Id74HWkECMedr0k6LNdRA1+gR2R9FtFl kaFF6m0iAtrvk6AqrzZYcTDLr8MEL8tKAl3yKGr+k/kQk1IgzOsW2+jpoEXmlFo9mMyE ElGg== X-Gm-Message-State: ALoCoQnQUM+TsTxyi7p64aRtbpbYOA0h9AW6JxSPZLrj6zjQR9IcK99VA9sZW4pg4V+1bywT8Gcj X-Received: by 10.202.53.84 with SMTP id c81mr49943814oia.120.1426605364464; Tue, 17 Mar 2015 08:16:04 -0700 (PDT) Reply-To: From: Vivekanand Joshi References: <84a6fe4be04c3ef0a714851977860ac8@mail.gmail.com> <160b8780d89add7f23c4eb9c3debb99d@mail.gmail.com> <55034A48.4040409@2ndquadrant.com> <849e75d9463938372dd4c516f5c5d89c@mail.gmail.com> <55037CEA.5050906@2ndquadrant.com> <55073272.20209@BlueTreble.com> <55074424.9050506@2ndquadrant.com> <55076FFB.9090105@BlueTreble.com> c5231342781287ff8cbc9ac1f20ff036@mail.gmail.com <61a7 a27428e588411e8ac1817043205c@mail.gmail.com> <550813CD.7040605@2ndquadrant.com> d6a86358c5e8d7ffe923ff307c3e8c7e@mail.gmail.com <55083236.8070900@2ndquadrant.com> <55083D74.4000601@2ndquadrant.com> 087 a57caebe1d71091670f3435d2c1e5@mail.gmail.com In-Reply-To: 087a57caebe1d71091670f3435d2c1e5@mail.gmail.com MIME-Version: 1.0 X-Mailer: Microsoft Outlook 15.0 thread-index: AQGXPdRf3VxuG24kJ8WwflsQcHnAgQHe3/kwAd/iPC4B8TjEOAGXREBQAmaveCgBKBdq4wLp8+fFAS4QZ0UCGdxJjQGaNexKAaH083YA3iIpcwDm/uDBAe8eXBAB/icNowHAYvOEAZPQW7EB4mXi4JyZo7wwgAAB9IA= Date: Tue, 17 Mar 2015 20:46:03 +0530 Message-ID: <6810c9497eee766e15ed238a3bb93203@mail.gmail.com> Subject: Re: Performance issues To: vjoshi@zetainteractive.com, Tomas Vondra , pgsql-performance@postgresql.org Content-Type: multipart/mixed; boundary=001a113d6084fbf8da05117d713f X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a113d6084fbf8da05117d713f Content-Type: text/plain; charset=UTF-8 This is the explain for a simple query: explain Select * from S_V_F_PROMOTION_HISTORY_EMAIL a inner join S_V_D_CAMPAIGN_HIERARCHY b on a.touchpoint_execution_id = b.touchpoint_execution_id; http://explain.depesz.com/s/gse I am wondering the total cost here is less even then the result is not coming out. Regards, Vivek -----Original Message----- From: Vivekanand Joshi [mailto:vjoshi@zetainteractive.com] Sent: Tuesday, March 17, 2015 8:40 PM To: 'Tomas Vondra'; 'pgsql-performance@postgresql.org' Subject: RE: [PERFORM] Performance issues The confusion for me here is that : I am getting results from the view in around 3 seconds (S_V_D_CAMPAIGN_HIERARCHY) and 25 seconds (S_V_F_PROMOTION_HISTORY_EMAIL) But when I am using these two views in the query as the joining tables, it doesn't give any result. As per my understanding, the planner is making new plan and that is costly instead of using output from the view, which is actually understandable. Is there a way, we can do anything about it? I hope I am making some sense here. Regards, Vivek -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Tomas Vondra Sent: Tuesday, March 17, 2015 8:13 PM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Performance issues On 17.3.2015 15:19, Thomas Kellerer wrote: > Tomas Vondra schrieb am 17.03.2015 um 14:55: >> (2) using window functions, e.g. like this: >> >> SELECT * FROM ( >> SELECT *, >> ROW_NUMBER() OVER (PARTITION BY touchpoint_execution_id >> ORDER BY FROM max_creation_dt) AS rn >> FROM s_f_touchpoint_execution_status_history >> ) foo WHERE rn = 1 >> >> But estimating this is also rather difficult ... > > > From my experience rewriting something like the above using DISTINCT > ON is usually faster. How do you get the last record (with respect to a timestamp column) using a DISTINCT ON? -- Tomas Vondra http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --001a113d6084fbf8da05117d713f Content-Type: text/plain; charset=US-ASCII; name="Explain.sql" Content-Disposition: attachment; filename="Explain.sql" Content-Transfer-Encoding: base64 X-Attachment-Id: 5d14e908238d468c_0.1 IE5lc3RlZCBMb29wICAoY29zdD00MTE4Ny4yMS4uNDUwNTMuNTQgcm93cz0x IHdpZHRoPTQwMykNCiAgIEpvaW4gRmlsdGVyOiAoc19mX3RvdWNocG9pbnRf ZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5XzIudG91Y2hwb2ludF9leGVjdXRp b25faWQgPSBzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3Rv cnkudG91Y2hwb2ludF9leGVjdXRpb25faWQpDQogICAtPiAgTmVzdGVkIExv b3AgTGVmdCBKb2luICAoY29zdD0xODQ4OC43NC4uMjA1OTEuMzIgcm93cz0x IHdpZHRoPTI3MSkNCiAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9 MTg0ODguNjEuLjIwNTkxLjE3IHJvd3M9MSB3aWR0aD0yNjMpDQogICAgICAg ICAgICAgICAtPiAgTmVzdGVkIExvb3AgTGVmdCBKb2luICAoY29zdD0xODQ4 OC40OC4uMjA1OTEuMDAgcm93cz0xIHdpZHRoPTI1NSkNCiAgICAgICAgICAg ICAgICAgICAgIC0+ICBIYXNoIEpvaW4gIChjb3N0PTE4NDg4LjM1Li4yMDU5 MC44NCByb3dzPTEgd2lkdGg9MjQ3KQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgSGFzaCBDb25kOiAoKHNfZl90b3VjaHBvaW50X2V4ZWN1dGlvbl9z dGF0dXNfaGlzdG9yeV8xLnRvdWNocG9pbnRfZXhlY3V0aW9uX2lkID0gc19m X3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5LnRvdWNocG9p bnRfZXhlY3V0aW9uDQpfaWQpIEFORCAoKG1heChzX2ZfdG91Y2hwb2ludF9l eGVjdXRpb25fc3RhdHVzX2hpc3RvcnlfMS5jcmVhdGlvbl9kdCkpID0gc19m X3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5LmNyZWF0aW9u X2R0KSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoQWdn cmVnYXRlICAoY29zdD02MjIxLjU2Li42OTg2LjEwIHJvd3M9NzY0NTQgd2lk dGg9MTYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAg U2VxIFNjYW4gb24gc19mX3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19o aXN0b3J5IHNfZl90b3VjaHBvaW50X2V4ZWN1dGlvbl9zdGF0dXNfaGlzdG9y eV8xICAoY29zdD0wLjAwLi40NzY2LjA0IHJvd3M9MjkxMTA0IHdpZHQNCmg9 MTYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCAgKGNv c3Q9MTIyNjYuNzYuLjEyMjY2Ljc2IHJvd3M9MiB3aWR0aD0yNDcpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSGFzaCBKb2luICAo Y29zdD02MjYxLjg5Li4xMjI2Ni43NiByb3dzPTIgd2lkdGg9MjQ3KQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgSGFzaCBDb25k OiAoc19mX3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5LnRv dWNocG9pbnRfZXhlY3V0aW9uX2lkID0gdHBfZXhlYy50b3VjaHBvaW50X2V4 ZWN1dGlvbl9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIC0+ICBTZXEgU2NhbiBvbiBzX2ZfdG91Y2hwb2ludF9leGVjdXRp b25fc3RhdHVzX2hpc3RvcnkgIChjb3N0PTAuMDAuLjU0OTMuODAgcm93cz0x MzYyODAgd2lkdGg9MTYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBGaWx0ZXI6ICh0b3VjaHBvaW50X2V4ZWN1dGlv bl9zdGF0dXNfdHlwZV9pZCA9IEFOWSAoJ3szLDR9Jzo6aW50ZWdlcltdKSkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBI YXNoICAoY29zdD02MjYxLjg4Li42MjYxLjg4IHJvd3M9MSB3aWR0aD0yMzEp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAtPiAgTmVzdGVkIExvb3AgTGVmdCBKb2luICAoY29zdD0xOTU1LjQwLi42 MjYxLjg4IHJvd3M9MSB3aWR0aD0yMzEpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExv b3AgTGVmdCBKb2luICAoY29zdD0xOTU1LjI3Li42MjYxLjcyIHJvd3M9MSB3 aWR0aD0yMjIpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0 PTE5NTQuOTkuLjYyNjEuNDEgcm93cz0xIHdpZHRoPTE5NykNCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MTk1NC43MS4uNjI2 MS4wOCByb3dzPTEgd2lkdGg9MTczKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgSm9pbiBGaWx0ZXI6IChjYW1wX2V4ZWMuY2FtcGFpZ25faWQgPSB3YXZl LmNhbXBhaWduX2lkKQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIE5l c3RlZCBMb29wICAoY29zdD0xOTU0LjQyLi42MjU1Ljg1IHJvd3M9MTYgd2lk dGg9MTY3KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhh c2ggSm9pbiAgKGNvc3Q9MTk1NC4xMy4uNjI0OS43MCByb3dzPTE2IHdpZHRo PTEwOCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEhh c2ggQ29uZDogKCh0cF9leGVjLnRvdWNocG9pbnRfaWQgPSB0cF8xLnRvdWNo cG9pbnRfaWQpIEFORCAod2F2ZV9leGVjLndhdmVfaWQgPSB0cF8xLg0Kd2F2 ZV9pZCkpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgSGFzaCBKb2luICAoY29zdD0xNTc2LjgzLi40NTk1LjUxIHJvd3M9NzI5 NTYgd2lkdGg9OTApDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBIYXNoIENvbmQ6ICh0cF9leGVjLndhdmVfZXhlY3V0aW9u X2lkID0gd2F2ZV9leGVjLndhdmVfZXhlY3V0aW9uX2lkKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2Fu IG9uIHNfZF90b3VjaHBvaW50X2V4ZWN1dGlvbiB0cF9leGVjICAoY29zdD0w LjAwLi4xNTU5LjU2IHJvd3M9NzI5NTYNCndpZHRoPTQyKQ0KICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2ggIChj b3N0PTEwMDEuMzcuLjEwMDEuMzcgcm93cz00NjAzNyB3aWR0aD01NikNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IC0+ICBTZXEgU2NhbiBvbiBzX2Rfd2F2ZV9leGVjdXRpb24gd2F2ZV9leGVj ICAoY29zdD0wLjAwLi4xMDAxLjM3IHJvd3M9NDYwMw0KNyB3aWR0aD01NikN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNo ICAoY29zdD0yMTIuNzIuLjIxMi43MiByb3dzPTEwOTcyIHdpZHRoPTI2KQ0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IFNlcSBTY2FuIG9uIHNfZF90b3VjaHBvaW50IHRwXzEgIChjb3N0PTAuMDAu LjIxMi43MiByb3dzPTEwOTcyIHdpZHRoPTI2KQ0KICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgc19kX2NhbXBh aWduX2V4ZWN1dGlvbl9pZHggb24gc19kX2NhbXBhaWduX2V4ZWN1dGlvbiBj YW1wX2V4ZWMgIChjb3N0PTAuDQoyOS4uMC4zNyByb3dzPTEgd2lkdGg9Njcp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBD b25kOiAoY2FtcGFpZ25fZXhlY3V0aW9uX2lkID0gd2F2ZV9leGVjLmNhbXBh aWduX2V4ZWN1dGlvbl9pZCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBJbmRleCBTY2FuIHVzaW5nIHNfZF93YXZlX3BrZXkgb24gc19kX3dhdmUg d2F2ZSAgKGNvc3Q9MC4yOS4uMC4zMSByb3dzPTEgd2lkdGg9MjIpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAod2F2ZV9p ZCA9IHdhdmVfZXhlYy53YXZlX2lkKQ0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4g IEluZGV4IFNjYW4gdXNpbmcgc19kX2NhbXBhaWduX3BrZXkgb24gc19kX2Nh bXBhaWduIGNhbXAgIChjb3N0PTAuMjkuLjAuMzIgcm93cz0xIHdpZHRoPTQw KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGNhbXBh aWduX2lkID0gY2FtcF9leGVjLmNhbXBhaWduX2lkKQ0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg LT4gIEluZGV4IFNjYW4gdXNpbmcgc19kX2NvbnRlbnRfcGtleSBvbiBzX2Rf Y29udGVudCBjb250ZW50ICAoY29zdD0wLjI4Li4wLjMwIHJvd3M9MSB3aWR0 aD0zMykNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0cF9leGVj LmNvbnRlbnRfaWQgPSBjb250ZW50X2lkKQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEluZGV4IFNj YW4gdXNpbmcgc19kX21lc3NhZ2VfdHlwZV9wa2V5IG9uIHNfZF9tZXNzYWdl X3R5cGUgbWVzc2FnZV90eXBlICAoY29zdD0wLjEzLi4wLjE1IHJvd3M9MSB3 aWR0aD0xMSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICh0cF9leGVjLm1l c3NhZ2VfdHlwZV9pZCA9IG1lc3NhZ2VfdHlwZV9pZCkNCiAgICAgICAgICAg ICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIHNfZF9ncm91cF9wa2V5 IG9uIHNfZF9ncm91cCBncnVwICAoY29zdD0wLjEzLi4wLjE1IHJvd3M9MSB3 aWR0aD0xMCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENv bmQ6IChjYW1wX2V4ZWMuZ3JvdXBfaWQgPSBncm91cF9pZCkNCiAgICAgICAg ICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGRfY2hhbm5lbF9wayBvbiBz X2RfY2hhbm5lbF90eXBlIGNoYW5uZWwgIChjb3N0PTAuMTMuLjAuMTUgcm93 cz0xIHdpZHRoPTEwKQ0KICAgICAgICAgICAgICAgICAgICAgSW5kZXggQ29u ZDogKGNoYW5uZWxfdHlwZV9pZCA9IHRwXzEuY2hhbm5lbF90eXBlX2lkKQ0K ICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgc19kX2NhdGVnb3J5X3Br ZXkgb24gc19kX2NhdGVnb3J5ICJDQVRFR09SWSIgIChjb3N0PTAuMTMuLjAu MTUgcm93cz0xIHdpZHRoPTEwKQ0KICAgICAgICAgICAgICAgSW5kZXggQ29u ZDogKGNhbXAuY2F0ZWdvcnlfaWQgPSBjYXRlZ29yeV9pZCkNCiAgIC0+ICBI YXNoIExlZnQgSm9pbiAgKGNvc3Q9MjI2OTguNDcuLjIzOTc5LjU2IHJvd3M9 Mzg2MTEgd2lkdGg9MTY0KQ0KICAgICAgICAgSGFzaCBDb25kOiAoKGJhc2Uu cHJvbW9faGlzdF9pZCA9IGVtYWlsLnByb21vX2hpc3RfaWQpIEFORCAoYmFz ZS5hdWRpZW5jZV9tZW1iZXJfaWQgPSBlbWFpbC5hdWRpZW5jZV9tZW1iZXJf aWQpKQ0KICAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0yMDgwMS4x OS4uMjEzMTAuMDIgcm93cz0zODYxMSB3aWR0aD05MCkNCiAgICAgICAgICAg ICAgIEpvaW4gRmlsdGVyOiAoc19mX3RvdWNocG9pbnRfZXhlY3V0aW9uX3N0 YXR1c19oaXN0b3J5XzIudG91Y2hwb2ludF9leGVjdXRpb25faWQgPSBiYXNl LnRvdWNocG9pbnRfZXhlY3V0aW9uX2lkKQ0KICAgICAgICAgICAgICAgLT4g IE5lc3RlZCBMb29wICAoY29zdD0yMDgwMC43Ni4uMjA4MDguODUgcm93cz0x IHdpZHRoPTE2KQ0KICAgICAgICAgICAgICAgICAgICAgLT4gIE5lc3RlZCBM b29wICAoY29zdD0yMDgwMC40Ny4uMjA4MDguNTIgcm93cz0xIHdpZHRoPTI0 KQ0KICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIEhhc2hBZ2dyZWdh dGUgIChjb3N0PTIwODAwLjE4Li4yMDgwMC4xOSByb3dzPTEgd2lkdGg9OCkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoIEpv aW4gIChjb3N0PTE0NDkyLjcxLi4yMDgwMC4xOCByb3dzPTEgd2lkdGg9OCkN CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEhhc2gg Q29uZDogKChzX2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3Rv cnlfMV8xLnRvdWNocG9pbnRfZXhlY3V0aW9uX2lkID0gc19mX3RvdWNocG9p bnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5XzIudG91Yw0KaHBvaW50X2V4 ZWN1dGlvbl9pZCkgQU5EICgobWF4KHNfZl90b3VjaHBvaW50X2V4ZWN1dGlv bl9zdGF0dXNfaGlzdG9yeV8xXzEuY3JlYXRpb25fZHQpKSA9IHNfZl90b3Vj aHBvaW50X2V4ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeV8yLmNyZWF0aW9uX2R0 KSkNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ ICBIYXNoQWdncmVnYXRlICAoY29zdD02MjIxLjU2Li42OTg2LjEwIHJvd3M9 NzY0NTQgd2lkdGg9MTYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gc19mX3RvdWNocG9p bnRfZXhlY3V0aW9uX3N0YXR1c19oaXN0b3J5IHNfZl90b3VjaHBvaW50X2V4 ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeV8xXzEgIChjb3N0PTAuMDAuLjQ3NjYu MDQgcm8NCndzPTI5MTEwNCB3aWR0aD0xNikNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIC0+ICBIYXNoICAoY29zdD01ODU3LjY4 Li41ODU3LjY4IHJvd3M9MTYwODk4IHdpZHRoPTE2KQ0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2Fu IG9uIHNfZl90b3VjaHBvaW50X2V4ZWN1dGlvbl9zdGF0dXNfaGlzdG9yeSBz X2ZfdG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX2hpc3RvcnlfMiAgKGNv c3Q9MC4wMC4uNTg1Ny42OCByb3dzDQo9MTYwODk4IHdpZHRoPTE2KQ0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgRmlsdGVyOiAodG91Y2hwb2ludF9leGVjdXRpb25fc3RhdHVzX3R5cGVf aWQgPSBBTlkgKCd7Myw0LDZ9Jzo6aW50ZWdlcltdKSkNCiAgICAgICAgICAg ICAgICAgICAgICAgICAgIC0+ICBJbmRleCBTY2FuIHVzaW5nIGlkeF9zX2Rf dG91Y2hwb2ludF9leGVjdXRpb25faWQgb24gc19kX3RvdWNocG9pbnRfZXhl Y3V0aW9uIHRwZSAgKGNvc3Q9MC4yOS4uOC4zMSByb3dzPTEgd2lkdGg9MTYp DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAodG91Y2hwb2ludF9leGVjdXRpb25faWQgPSBzX2ZfdG91Y2hwb2ludF9l eGVjdXRpb25fc3RhdHVzX2hpc3RvcnlfMi50b3VjaHBvaW50X2V4ZWN1dGlv bl9pZCkNCiAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNj YW4gdXNpbmcgc19kX3RvdWNocG9pbnRfcGtleSBvbiBzX2RfdG91Y2hwb2lu dCB0cCAgKGNvc3Q9MC4yOS4uMC4zMiByb3dzPTEgd2lkdGg9OCkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgIEluZGV4IENvbmQ6ICgodG91Y2hwb2lu dF9pZCA9IHRwZS50b3VjaHBvaW50X2lkKSBBTkQgKGNoYW5uZWxfdHlwZV9p ZCA9IDEpKQ0KICAgICAgICAgICAgICAgLT4gIEFwcGVuZCAgKGNvc3Q9MC40 My4uMzEyLjQ0IHJvd3M9MTUwOTkgd2lkdGg9NzQpDQogICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBpZHhfcHJfaGlzdG9yeSBv biBzX2ZfcHJvbW90aW9uX2hpc3RvcnkgYmFzZSAgKGNvc3Q9MC40My4uMzEx LjUyIHJvd3M9MTUwODMgd2lkdGg9NzQpDQogICAgICAgICAgICAgICAgICAg ICAgICAgICBJbmRleCBDb25kOiAodG91Y2hwb2ludF9leGVjdXRpb25faWQg PSB0cGUudG91Y2hwb2ludF9leGVjdXRpb25faWQpDQogICAgICAgICAgICAg ICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBzX2ZfcHJvbW90aW9uX2hp c3RvcnlfdGFibGUxX3RlaWlkeCBvbiBzX2ZfcHJvbW90aW9uX2hpc3Rvcnlf dGFibGUxIGJhc2VfMSAgKGNvc3Q9MC4xNS4uMC4yMyByb3dzPTQgd2lkdGg9 NzQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAo dG91Y2hwb2ludF9leGVjdXRpb25faWQgPSB0cGUudG91Y2hwb2ludF9leGVj dXRpb25faWQpDQogICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2Nh biB1c2luZyBzX2ZfcHJvbW90aW9uX2hpc3RvcnlfdGFibGUyX3RlaWlkeCBv biBzX2ZfcHJvbW90aW9uX2hpc3RvcnlfdGFibGUyIGJhc2VfMiAgKGNvc3Q9 MC4xNS4uMC4yMyByb3dzPTQgd2lkdGg9NzQpDQogICAgICAgICAgICAgICAg ICAgICAgICAgICBJbmRleCBDb25kOiAodG91Y2hwb2ludF9leGVjdXRpb25f aWQgPSB0cGUudG91Y2hwb2ludF9leGVjdXRpb25faWQpDQogICAgICAgICAg ICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyBzX2ZfcHJvbW90aW9u X2hpc3RvcnlfdGFibGUzX3RlaWlkeCBvbiBzX2ZfcHJvbW90aW9uX2hpc3Rv cnlfdGFibGUzIGJhc2VfMyAgKGNvc3Q9MC4xNS4uMC4yMyByb3dzPTQgd2lk dGg9NzQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25k OiAodG91Y2hwb2ludF9leGVjdXRpb25faWQgPSB0cGUudG91Y2hwb2ludF9l eGVjdXRpb25faWQpDQogICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXgg U2NhbiB1c2luZyBzX2ZfcHJvbW90aW9uX2hpc3RvcnlfdGFibGU0X3RlaWlk eCBvbiBzX2ZfcHJvbW90aW9uX2hpc3RvcnlfdGFibGU0IGJhc2VfNCAgKGNv c3Q9MC4xNS4uMC4yMyByb3dzPTQgd2lkdGg9NzQpDQogICAgICAgICAgICAg ICAgICAgICAgICAgICBJbmRleCBDb25kOiAodG91Y2hwb2ludF9leGVjdXRp b25faWQgPSB0cGUudG91Y2hwb2ludF9leGVjdXRpb25faWQpDQogICAgICAg ICAtPiAgSGFzaCAgKGNvc3Q9MTE5Mi43MS4uMTE5Mi43MSByb3dzPTQ2OTcx IHdpZHRoPTkwKQ0KICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHNf Zl9wcm9tb3Rpb25faGlzdG9yeV9lbWFpbCBlbWFpbCAgKGNvc3Q9MC4wMC4u MTE5Mi43MSByb3dzPTQ2OTcxIHdpZHRoPTkwKQ== --001a113d6084fbf8da05117d713f Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --001a113d6084fbf8da05117d713f--