Reply-To: <vjoshi@zetainteractive.com>
From: Vivekanand Joshi <vjoshi@zetainteractive.com>
References: <84a6fe4be04c3ef0a714851977860ac8@mail.gmail.com>
 <CACKkDGETLNUON-bLM0gCo_r-+ts3Q29aQwmargv1Usi=PgQvVg@mail.gmail.com>
 <CANwLwatODrcwDgO+JXG-L=jJJQTucvUrur01E-y_tE_PT8i7kQ@mail.gmail.com>
 <55034A48.4040409@2ndquadrant.com>
	<CANwLwavsL-+SDRB7VKxQ_OJq-T=MVQV6T6qH5Aug9PaSWt2C0w@mail.gmail.com>
 <CACKkDGHOnb2efYvLj557E5pSuzS+Wmu9dqG3Z=b_dbYhpi7muQ@mail.gmail.com>
 <CAOR=d=2L86fB+HWX8h078tYsd7LVKKFPQb=jfd8YNRU1Fc7mUA@mail.gmail.com>
 <849e75d9463938372dd4c516f5c5d89c@mail.gmail.com>
	<55037CEA.5050906@2ndquadrant.com>
 <55073272.20209@BlueTreble.com>	<55074424.9050506@2ndquadrant.com>
 <55076FFB.9090105@BlueTreble.com>
	<acf5780f0e3c7d42d5f6499830378008@mail.gmail.com>
 <55083236.8070900@2ndquadrant.com> <me9d4u$9b5$1@ger.gmane.org>
 <55083D74.4000601@2ndquadrant.com> <me9guu$cvp$1@ger.gmane.org>
 <9650933705b1a197888f77acbef26728@mail.gmail.com>
 <867fue2lwj.fsf@jerry.enova.com>
In-Reply-To: <867fue2lwj.fsf@jerry.enova.com>
MIME-Version: 1.0
thread-index: 
 AQGXPdRf3VxuG24kJ8WwflsQcHnAgQHf4jwuAfE4xDgBl0RAUAJmr3goASgXauMC6fPnxQEuEGdFAhncSY0BmjXsSgGh9PN2AN4iKXMB/icNowHAYvOEAZPQW7EB4mXi4AIxrzckAfRabwYBnL/FOpyTAz9A
Date: Thu, 19 Mar 2015 00:18:16 +0530
Message-ID: <2383017e796bea6aaf8abb5682ba5933@mail.gmail.com>
Subject: Re: Performance issues
To: Jerry Sievers <gsievers19@comcast.net>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>,
 pgsql-performance@postgresql.org
Content-Type: multipart/mixed; boundary=001a113cd16ec7531a051194861b
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a113cd16ec7531a051194861b
Content-Type: text/plain; charset=UTF-8

The issue here is that the queries are running inside a Jasper Reports. So
we cannot set this only for a one single query.

We are accessing our reports from a web-browser, which in turn runs the
report from Application Server (Jasper). This server connects to
PostgreSQL server.

Inside a JRXML(Jasper report file) file we cannot set this parameter.

I am attaching a JRXML file for a feel.  You can open this file in
notepad. I don't think we can set server level property in this file. So
how about a workaround?

Vivek


-----Original Message-----
From: Jerry Sievers [mailto:gsievers19@comcast.net]
Sent: Thursday, March 19, 2015 12:06 AM
To: vjoshi@zetainteractive.com
Cc: Tomas Vondra; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Performance issues

Vivekanand Joshi <vjoshi@zetainteractive.com> writes:

> So, here is the first taste of success and which gives me the
> confidence that if properly worked out with a good hardware and proper
> tuning, PostgreSQL could be a good replacement.
>
> Out of the 9 reports which needs to be migrated in PostgreSQL, 3 are
> now running.
>
> Report 4 was giving an issue and I will see it tomorrow.
>
> Just to inform you guys that, the thing that helped most is setting
> enable_nestloops to false worked. Plans are now not miscalculated.
>
> But this is not a production-suitable setting. So what do you think
> how to get a work around this?

Consider just disabling that setting for 1 or a few odd queries you have
for which they are known  to plan badly.

begin;
set local enable_nestloops to false;
select ...;
commit/abort;

I'd say never make that sort of setting DB or cluster-wide.


>
>
> 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 9:00 PM
> To: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Performance issues
>
> On 17.3.2015 16:24, Thomas Kellerer wrote:
>> Tomas Vondra schrieb am 17.03.2015 um 15:43:
>>> 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?
>>
>> You need to use "order by ... desc". See here:
>> http://sqlfiddle.com/#!15/d4846/2
>
> Nice, thanks!
>
>>
>> Btw: your row_number() usage wouldn't return the "latest" row either.
>> It would return the "oldest" row.
>
> Oh, right. I forgot the DESC in the window.
>
>
> --
> 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

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800

--001a113cd16ec7531a051194861b
Content-Type: application/octet-stream; name="AvgEmailsRecieved.jrxml"
Content-Disposition: attachment; filename="AvgEmailsRecieved.jrxml"
Content-Transfer-Encoding: base64
X-Attachment-Id: ca9208854d37c4b_0.1

PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPCEtLSBD
cmVhdGVkIHdpdGggSmFzcGVyc29mdCBTdHVkaW8gdmVyc2lvbiBsYXN0LS0+
CjxqYXNwZXJSZXBvcnQgeG1sbnM9Imh0dHA6Ly9qYXNwZXJyZXBvcnRzLnNv
dXJjZWZvcmdlLm5ldC9qYXNwZXJyZXBvcnRzIiB4bWxuczp4c2k9Imh0dHA6
Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIiB4c2k6c2No
ZW1hTG9jYXRpb249Imh0dHA6Ly9qYXNwZXJyZXBvcnRzLnNvdXJjZWZvcmdl
Lm5ldC9qYXNwZXJyZXBvcnRzIGh0dHA6Ly9qYXNwZXJyZXBvcnRzLnNvdXJj
ZWZvcmdlLm5ldC94c2QvamFzcGVycmVwb3J0LnhzZCIgbmFtZT0iT3BlbkFj
dGl2aXR5UGFzdFllYXIiIGxhbmd1YWdlPSJncm9vdnkiIHBhZ2VXaWR0aD0i
NzkyIiBwYWdlSGVpZ2h0PSI2MTIiIG9yaWVudGF0aW9uPSJMYW5kc2NhcGUi
IGNvbHVtbldpZHRoPSI3NTIiIGxlZnRNYXJnaW49IjIwIiByaWdodE1hcmdp
bj0iMjAiIHRvcE1hcmdpbj0iMjAiIGJvdHRvbU1hcmdpbj0iMjAiIHV1aWQ9
IjA3YzZkODZmLWYyNzItNDUxNC1iOTI2LWE2MTU2YjZjZWFjMSI+Cgk8cHJv
cGVydHkgbmFtZT0iaXJlcG9ydC56b29tIiB2YWx1ZT0iMS4wIi8+Cgk8cHJv
cGVydHkgbmFtZT0iaXJlcG9ydC54IiB2YWx1ZT0iMCIvPgoJPHByb3BlcnR5
IG5hbWU9ImlyZXBvcnQueSIgdmFsdWU9IjAiLz4KCTxwcm9wZXJ0eSBuYW1l
PSJpcmVwb3J0Lmphc3BlcnNlcnZlci5yZXBvcnRVbml0IiB2YWx1ZT0iL29y
Z2FuaXphdGlvbnMvQ0VTX0tCSC9IdWJfUmVwb3J0cy9TZWdtZW50X1JlcG9y
dHMvQXZnRW1haWxzUmVjaWV2ZWQiLz4KCTxwcm9wZXJ0eSBuYW1lPSJpcmVw
b3J0Lmphc3BlcnNlcnZlci51cmwiIHZhbHVlPSJodHRwczovL2NsaWNrY2kt
Y2VzLmh1YnRlc3QuY2xpY2tzcXVhcmVkLm5ldC9jaS9zZXJ2aWNlcy9yZXBv
c2l0b3J5Ii8+Cgk8cGFyYW1ldGVyIG5hbWU9ImRhdGVFbmQiIGNsYXNzPSJq
YXZhLnV0aWwuRGF0ZSI+CgkJPHBhcmFtZXRlckRlc2NyaXB0aW9uPjwhW0NE
QVRBW0VuZCBEYXRlXV0+PC9wYXJhbWV0ZXJEZXNjcmlwdGlvbj4KCQk8ZGVm
YXVsdFZhbHVlRXhwcmVzc2lvbj48IVtDREFUQVtuZXcgRGF0ZShuZXcgRGF0
ZSgpLmdldFllYXIoKSwgbmV3IERhdGUoKS5nZXRNb250aCgpICwgbmV3IERh
dGUoKS5nZXREYXRlKCkrMSldXT48L2RlZmF1bHRWYWx1ZUV4cHJlc3Npb24+
Cgk8L3BhcmFtZXRlcj4KCTxwYXJhbWV0ZXIgbmFtZT0iZGF0ZVN0YXJ0IiBj
bGFzcz0iamF2YS51dGlsLkRhdGUiPgoJCTxwYXJhbWV0ZXJEZXNjcmlwdGlv
bj48IVtDREFUQVtTdGFydCBEYXRlXV0+PC9wYXJhbWV0ZXJEZXNjcmlwdGlv
bj4KCQk8ZGVmYXVsdFZhbHVlRXhwcmVzc2lvbj48IVtDREFUQVtuZXcgRGF0
ZShuZXcgRGF0ZSgpLmdldFllYXIoKS0xLCBuZXcgRGF0ZSgpLmdldE1vbnRo
KCkgLCBuZXcgRGF0ZSgpLmdldERhdGUoKSldXT48L2RlZmF1bHRWYWx1ZUV4
cHJlc3Npb24+Cgk8L3BhcmFtZXRlcj4KCTxwYXJhbWV0ZXIgbmFtZT0icGFy
YW1fQ0FNUEFJR05fSU5JVElBVElWRV8yIiBjbGFzcz0iamF2YS51dGlsLkNv
bGxlY3Rpb24iPgoJCTxwYXJhbWV0ZXJEZXNjcmlwdGlvbj48IVtDREFUQVtD
YW1wYWlnbiBJbml0aWF0aXZlKHMpXV0+PC9wYXJhbWV0ZXJEZXNjcmlwdGlv
bj4KCQk8ZGVmYXVsdFZhbHVlRXhwcmVzc2lvbj48IVtDREFUQVtbJy0tQUxM
IElOSVRJQVRJVkVTLS0nXV1dPjwvZGVmYXVsdFZhbHVlRXhwcmVzc2lvbj4K
CTwvcGFyYW1ldGVyPgoJPHF1ZXJ5U3RyaW5nPgoJCTwhW0NEQVRBW1NFTEVD
VAogICAgWi5TRU5UX0lORCBBUyBJU19TRU5ULAogICBDT0FMRVNDRShYLkVN
QUlMUywgMCkgQVMgRU1BSUxTLAogICAgQ09BTEVTQ0UoWC5QRVJDRU5ULCAw
KSBQRVJDRU5UCkZST00KICAgIChTRUxFQ1QKICAgICAgICBDQVNFIFdIRU4g
U0VOVF9JTkQgPD0gMSBUSEVOIDEKICAgICAgICAgICAgV0hFTiBTRU5UX0lO
RCA8PSA1IFRIRU4gMgogICAgICAgICAgICBXSEVOIFNFTlRfSU5EIDw9IDEw
IFRIRU4gMwogICAgICAgICAgICBXSEVOIFNFTlRfSU5EIDw9IDE1IFRIRU4g
NAogICAgICAgICAgICBXSEVOIFNFTlRfSU5EIDw9IDIwIFRIRU4gNQogICAg
ICAgICAgICBXSEVOIFNFTlRfSU5EIDw9IDMwIFRIRU4gNgogICAgICAgICAg
ICBXSEVOIFNFTlRfSU5EIDw9IDUwIFRIRU4gNwogICAgICAgICAgICBXSEVO
IFNFTlRfSU5EIDw9IDc1IFRIRU4gOAogICAgICAgICAgICBXSEVOIFNFTlRf
SU5EIDw9IDEwMCBUSEVOIDkKICAgICAgICAgICAgRUxTRSAxMCBFTkQgQVMg
U0VORF9SQU5LLAogICAgICAgIENPVU5UKERJU1RJTkNUIFRBUkdFVF9JRCkg
QVMgRU1BSUxTLAogICAgICAgIChDT1VOVChESVNUSU5DVCBUQVJHRVRfSUQp
KzAuMCkvKFNFTEVDVCBDT1VOVChESVNUSU5DVCBUQVJHRVRfSUQpCiAgICAg
ICAgICAgICAgICAgICAgICBGUk9NIFNfVl9GX1BST01PVElPTl9ISVNUT1JZ
X0VNQUlMIFBICiAgICAgICAgICAgICAgICAgICAgICAgICAgIElOTkVSIEpP
SU4gU19WX0RfQ0FNUEFJR05fSElFUkFSQ0hZIENIIE9OIFBILlRPVUNIUE9J
TlRfRVhFQ1VUSU9OX0lEID0gQ0guVE9VQ0hQT0lOVF9FWEVDVVRJT05fSUQK
ICAgICAgICAgICAgICAgICAgICAgIFdIRVJFIDE9MQogICAJCSBBTkQgU0VO
RF9EVCA+PSAkUHtkYXRlU3RhcnR9CiAgIAkJIEFORCBTRU5EX0RUIDw9ICRQ
e2RhdGVFbmR9CiAgICAgICAgICAgICAgICAgICAgICBBTkQgKCRYe0lOLENI
LkNBTVBBSUdOX0lOSVRJQVRJVkUscGFyYW1fQ0FNUEFJR05fSU5JVElBVElW
RV8yfSBPUiAkWHtJTiwnLS1BTEwgSU5JVElBVElWRVMtLScscGFyYW1fQ0FN
UEFJR05fSU5JVElBVElWRV8yfSkKCgkJCQkJCSkgQVMgUEVSQ0VOVAogICAg
RlJPTSAoCiAgICAgICAgU0VMRUNUIFRBUkdFVF9JRCxDT1VOVChQUk9NT19I
SVNUX0lEKSBBUyBTRU5UX0lORAogICAgICAgIEZST00gU19WX0ZfUFJPTU9U
SU9OX0hJU1RPUllfRU1BSUwgUEgKICAgICAgICAgICAgIElOTkVSIEpPSU4g
U19WX0RfQ0FNUEFJR05fSElFUkFSQ0hZIENIIE9OIFBILlRPVUNIUE9JTlRf
RVhFQ1VUSU9OX0lEID0gQ0guVE9VQ0hQT0lOVF9FWEVDVVRJT05fSUQKICAg
ICAgICBXSEVSRSAxPTEKICAgCUFORCBTRU5EX0RUID49ICRQe2RhdGVTdGFy
dH0KICAgCUFORCBTRU5EX0RUIDw9ICRQe2RhdGVFbmR9CiAgICAgICAgICBB
TkQgKCRYe0lOLENILkNBTVBBSUdOX0lOSVRJQVRJVkUscGFyYW1fQ0FNUEFJ
R05fSU5JVElBVElWRV8yfSBPUiAkWHtJTiwnLS1BTEwgSU5JVElBVElWRVMt
LScscGFyYW1fQ0FNUEFJR05fSU5JVElBVElWRV8yfSkKICAgICAgICBHUk9V
UCBCWSBUQVJHRVRfSUQKICAgICAgICApIEEKICAgIEdST1VQIEJZCiAgICAg
ICAgU0VORF9SQU5LCiAgICAgICAgKSBYClJJR0hUIE9VVEVSIEpPSU4KKApT
RUxFQ1QgMSBBUyBTRU5EX1JBTkssICcxJyBBUyBTRU5UX0lORApVTklPTgpT
RUxFQ1QgMiAsJzItNScKVU5JT04KU0VMRUNUIDMgLCc2LTEwJwpVTklPTgpT
RUxFQ1QgNCAsJzExLTE1JwpVTklPTgpTRUxFQ1QgNSAsJzE2LTIwJwpVTklP
TgpTRUxFQ1QgNiAsJzIxLTMwJwpVTklPTgpTRUxFQ1QgNyAsJzMxLTUwJwpV
TklPTgpTRUxFQ1QgOCAsJzUxLTc1JwpVTklPTgpTRUxFQ1QgOSAsJzc2LTEw
MCcKVU5JT04KU0VMRUNUIDEwLCAnMTAxIE9SIE1PUkUnCikgWgpPTiBaLlNF
TkRfUkFOSyA9IFguU0VORF9SQU5LCk9SREVSIEJZIFouU0VORF9SQU5LIEFT
Q11dPgoJPC9xdWVyeVN0cmluZz4KCTxmaWVsZCBuYW1lPSJJU19TRU5UIiBj
bGFzcz0iamF2YS5sYW5nLlN0cmluZyIvPgoJPGZpZWxkIG5hbWU9IkVNQUlM
UyIgY2xhc3M9ImphdmEubGFuZy5Mb25nIi8+Cgk8ZmllbGQgbmFtZT0iUEVS
Q0VOVCIgY2xhc3M9ImphdmEubWF0aC5CaWdEZWNpbWFsIi8+Cgk8YmFja2dy
b3VuZD4KCQk8YmFuZCBzcGxpdFR5cGU9IlN0cmV0Y2giLz4KCTwvYmFja2dy
b3VuZD4KCTx0aXRsZT4KCQk8YmFuZCBoZWlnaHQ9Ijg3IiBzcGxpdFR5cGU9
IlN0cmV0Y2giPgoJCQk8c3RhdGljVGV4dD4KCQkJCTxyZXBvcnRFbGVtZW50
IHg9IjY1MiIgeT0iMCIgd2lkdGg9IjEwMCIgaGVpZ2h0PSIyMCIgdXVpZD0i
MTdmOWE2YjQtNDNiZC00ZjI3LTgwZDAtZjMxMGM5ZmQ0MDNiIi8+CgkJCQk8
dGV4dD48IVtDREFUQVtWZXJzaW9uOiAxLjEuMF1dPjwvdGV4dD4KCQkJPC9z
dGF0aWNUZXh0PgoJCQk8c3RhdGljVGV4dD4KCQkJCTxyZXBvcnRFbGVtZW50
IG1vZGU9Ik9wYXF1ZSIgeD0iMCIgeT0iMCIgd2lkdGg9IjMyOCIgaGVpZ2h0
PSI0MCIgZm9yZWNvbG9yPSIjRkZGRkZGIiBiYWNrY29sb3I9IiM4MTI5OTAi
IHV1aWQ9ImM3ZGU4MTIzLWY1MjItNGQ1NS04MTk5LTI2ZWNmNjA4MDg1NyIv
PgoJCQkJPHRleHRFbGVtZW50IHRleHRBbGlnbm1lbnQ9IkNlbnRlciIgdmVy
dGljYWxBbGlnbm1lbnQ9Ik1pZGRsZSI+CgkJCQkJPGZvbnQgc2l6ZT0iMjQi
IGlzQm9sZD0idHJ1ZSIvPgoJCQkJPC90ZXh0RWxlbWVudD4KCQkJCTx0ZXh0
PjwhW0NEQVRBW0F2ZXJhZ2UgRW1haWxzIFJlY2VpdmVkXV0+PC90ZXh0PgoJ
CQk8L3N0YXRpY1RleHQ+CgkJCTxzdGF0aWNUZXh0PgoJCQkJPHJlcG9ydEVs
ZW1lbnQgeD0iMCIgeT0iNjAiIHdpZHRoPSIxMTgiIGhlaWdodD0iMjAiIHV1
aWQ9IjBmODUxM2ZhLTY2ZDMtNGY4Yy04ZmM0LWU4OGFhYTFmYTZjOCIvPgoJ
CQkJPHRleHRFbGVtZW50PgoJCQkJCTxmb250IGlzQm9sZD0idHJ1ZSIvPgoJ
CQkJPC90ZXh0RWxlbWVudD4KCQkJCTx0ZXh0PjwhW0NEQVRBW0RhdGUgUmFu
Z2U6XV0+PC90ZXh0PgoJCQk8L3N0YXRpY1RleHQ+CgkJCTx0ZXh0RmllbGQ+
CgkJCQk8cmVwb3J0RWxlbWVudCB4PSIxMTgiIHk9IjYwIiB3aWR0aD0iNjM0
IiBoZWlnaHQ9IjIwIiB1dWlkPSIyZTM1ZTBjZC1mZGQwLTQ3NzQtODE2NS1j
ZjY2NDlkMjg4MDYiLz4KCQkJCTx0ZXh0RWxlbWVudD4KCQkJCQk8Zm9udCBp
c0JvbGQ9InRydWUiLz4KCQkJCTwvdGV4dEVsZW1lbnQ+CgkJCQk8dGV4dEZp
ZWxkRXhwcmVzc2lvbj48IVtDREFUQVtuZXcgU2ltcGxlRGF0ZUZvcm1hdCgi
TU1NIGRkLCB5eXl5IikuZm9ybWF0KCRQe2RhdGVTdGFydH0pICsgIiB0byAi
ICsgbmV3IFNpbXBsZURhdGVGb3JtYXQoIk1NTSBkZCwgeXl5eSIpLmZvcm1h
dCgkUHtkYXRlRW5kfSldXT48L3RleHRGaWVsZEV4cHJlc3Npb24+CgkJCTwv
dGV4dEZpZWxkPgoJCQk8dGV4dEZpZWxkPgoJCQkJPHJlcG9ydEVsZW1lbnQg
eD0iMTE4IiB5PSI0MCIgd2lkdGg9IjYyNiIgaGVpZ2h0PSIyMCIgdXVpZD0i
Yjc3OTdjMjgtZTdkNi00NmZiLTlkZTMtOThiOGRjMzU3NzI3Ii8+CgkJCQk8
dGV4dEVsZW1lbnQ+CgkJCQkJPGZvbnQgaXNCb2xkPSJ0cnVlIi8+CgkJCQk8
L3RleHRFbGVtZW50PgoJCQkJPHRleHRGaWVsZEV4cHJlc3Npb24+PCFbQ0RB
VEFbIiIrJFB7cGFyYW1fQ0FNUEFJR05fSU5JVElBVElWRV8yfV1dPjwvdGV4
dEZpZWxkRXhwcmVzc2lvbj4KCQkJPC90ZXh0RmllbGQ+CgkJCTxzdGF0aWNU
ZXh0PgoJCQkJPHJlcG9ydEVsZW1lbnQgeD0iMCIgeT0iNDAiIHdpZHRoPSIx
MTgiIGhlaWdodD0iMjAiIHV1aWQ9Ijk1MTc5NzZhLWJlNzEtNDVlNy1iNTlh
LTk3MGI4MDI2NDQ2YSIvPgoJCQkJPHRleHRFbGVtZW50PgoJCQkJCTxmb250
IGlzQm9sZD0idHJ1ZSIvPgoJCQkJPC90ZXh0RWxlbWVudD4KCQkJCTx0ZXh0
PjwhW0NEQVRBW0NhbXBhaWduIEluaXRpYXRpdmUocyk6XV0+PC90ZXh0PgoJ
CQk8L3N0YXRpY1RleHQ+CgkJPC9iYW5kPgoJPC90aXRsZT4KCTxzdW1tYXJ5
PgoJCTxiYW5kIGhlaWdodD0iMzI2IiBzcGxpdFR5cGU9IlN0cmV0Y2giPgoJ
CQk8Y29tcG9uZW50RWxlbWVudD4KCQkJCTxyZXBvcnRFbGVtZW50IHg9IjEw
IiB5PSIxMCIgd2lkdGg9IjczNCIgaGVpZ2h0PSIzMTUiIHV1aWQ9ImIzZWVm
NjI0LWY2MTQtNDNhNi05N2Y2LWFhNTk1NDEwMmE5NCIvPgoJCQkJPGZjOmNo
YXJ0IHhtbG5zOmZjPSJodHRwOi8vamFzcGVyc29mdC5jb20vZnVzaW9uIiB4
c2k6c2NoZW1hTG9jYXRpb249Imh0dHA6Ly9qYXNwZXJzb2Z0LmNvbS9mdXNp
b24gaHR0cDovL2phc3BlcnNvZnQuY29tL3NjaGVtYS9mdXNpb24ueHNkIiB0
eXBlPSJTdGFja2VkQ29sdW1uIj4KCQkJCQk8ZmM6Y2hhcnRQcm9wZXJ0eSBu
YW1lPSJzaG93WUF4aXNWYWx1ZXMiPgoJCQkJCQk8ZmM6cHJvcGVydHlFeHBy
ZXNzaW9uPjwhW0NEQVRBW0Jvb2xlYW4uRkFMU0VdXT48L2ZjOnByb3BlcnR5
RXhwcmVzc2lvbj4KCQkJCQk8L2ZjOmNoYXJ0UHJvcGVydHk+CgkJCQkJPGZj
OmNoYXJ0UHJvcGVydHkgbmFtZT0ic2hvd0xhYmVscyI+CgkJCQkJCTxmYzpw
cm9wZXJ0eUV4cHJlc3Npb24+PCFbQ0RBVEFbQm9vbGVhbi5UUlVFXV0+PC9m
Yzpwcm9wZXJ0eUV4cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFydFByb3BlcnR5
PgoJCQkJCTxmYzpjaGFydFByb3BlcnR5IG5hbWU9InNob3dEaXZMaW5lVmFs
dWVzIj4KCQkJCQkJPGZjOnByb3BlcnR5RXhwcmVzc2lvbj48IVtDREFUQVtC
b29sZWFuLkZBTFNFXV0+PC9mYzpwcm9wZXJ0eUV4cHJlc3Npb24+CgkJCQkJ
PC9mYzpjaGFydFByb3BlcnR5PgoJCQkJCTxmYzpjaGFydFByb3BlcnR5IG5h
bWU9InlBeGlzTWluVmFsdWUiPgoJCQkJCQk8ZmM6cHJvcGVydHlFeHByZXNz
aW9uPjwhW0NEQVRBW25ldyBJbnRlZ2VyKDApXV0+PC9mYzpwcm9wZXJ0eUV4
cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFydFByb3BlcnR5PgoJCQkJCTxmYzpj
aGFydFByb3BlcnR5IG5hbWU9InlBeGlzTWF4VmFsdWUiPgoJCQkJCQk8ZmM6
cHJvcGVydHlFeHByZXNzaW9uPjwhW0NEQVRBW25ldyBJbnRlZ2VyKDEpXV0+
PC9mYzpwcm9wZXJ0eUV4cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFydFByb3Bl
cnR5PgoJCQkJCTxmYzpjaGFydFByb3BlcnR5IG5hbWU9InNob3dMZWdlbmQi
PgoJCQkJCQk8ZmM6cHJvcGVydHlFeHByZXNzaW9uPjwhW0NEQVRBW0Jvb2xl
YW4uRkFMU0VdXT48L2ZjOnByb3BlcnR5RXhwcmVzc2lvbj4KCQkJCQk8L2Zj
OmNoYXJ0UHJvcGVydHk+CgkJCQkJPGZjOmNoYXJ0UHJvcGVydHkgbmFtZT0i
YWRqdXN0RGl2Ij4KCQkJCQkJPGZjOnByb3BlcnR5RXhwcmVzc2lvbj48IVtD
REFUQVtCb29sZWFuLkZBTFNFXV0+PC9mYzpwcm9wZXJ0eUV4cHJlc3Npb24+
CgkJCQkJPC9mYzpjaGFydFByb3BlcnR5PgoJCQkJCTxmYzpjaGFydFByb3Bl
cnR5IG5hbWU9InNob3dUb29sVGlwIj4KCQkJCQkJPGZjOnByb3BlcnR5RXhw
cmVzc2lvbj48IVtDREFUQVtCb29sZWFuLkZBTFNFXV0+PC9mYzpwcm9wZXJ0
eUV4cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFydFByb3BlcnR5PgoJCQkJCTxm
YzpjaGFydFByb3BlcnR5IG5hbWU9InNob3dUb29sVGlwU2hhZG93Ij4KCQkJ
CQkJPGZjOnByb3BlcnR5RXhwcmVzc2lvbj48IVtDREFUQVtCb29sZWFuLkZB
TFNFXV0+PC9mYzpwcm9wZXJ0eUV4cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFy
dFByb3BlcnR5PgoJCQkJCTxmYzpjaGFydFByb3BlcnR5IG5hbWU9ImxhYmVs
UGFkZGluZyI+CgkJCQkJCTxmYzpwcm9wZXJ0eUV4cHJlc3Npb24+PCFbQ0RB
VEFbbmV3IEludGVnZXIoMCldXT48L2ZjOnByb3BlcnR5RXhwcmVzc2lvbj4K
CQkJCQk8L2ZjOmNoYXJ0UHJvcGVydHk+CgkJCQkJPGZjOmNoYXJ0UHJvcGVy
dHkgbmFtZT0icGxhY2VWYWx1ZXNJbnNpZGUiPgoJCQkJCQk8ZmM6cHJvcGVy
dHlFeHByZXNzaW9uPjwhW0NEQVRBW0Jvb2xlYW4uVFJVRV1dPjwvZmM6cHJv
cGVydHlFeHByZXNzaW9uPgoJCQkJCTwvZmM6Y2hhcnRQcm9wZXJ0eT4KCQkJ
CQk8ZmM6Y2hhcnRQcm9wZXJ0eSBuYW1lPSJ2YWx1ZVBhZGRpbmciPgoJCQkJ
CQk8ZmM6cHJvcGVydHlFeHByZXNzaW9uPjwhW0NEQVRBW25ldyBJbnRlZ2Vy
KDUpXV0+PC9mYzpwcm9wZXJ0eUV4cHJlc3Npb24+CgkJCQkJPC9mYzpjaGFy
dFByb3BlcnR5PgoJCQkJCTxmYzpjaGFydERhdGFzZXQ+CgkJCQkJCTxmYzpp
dGVtPgoJCQkJCQkJPGZjOnNlcmllc0V4cHJlc3Npb24+PCFbQ0RBVEFbJEZ7
SVNfU0VOVH1dXT48L2ZjOnNlcmllc0V4cHJlc3Npb24+CgkJCQkJCQk8ZmM6
bGFiZWxFeHByZXNzaW9uPjwhW0NEQVRBWyRGe0lTX1NFTlR9XV0+PC9mYzps
YWJlbEV4cHJlc3Npb24+CgkJCQkJCQk8ZmM6dmFsdWVFeHByZXNzaW9uPjwh
W0NEQVRBWyRGe0VNQUlMU31dXT48L2ZjOnZhbHVlRXhwcmVzc2lvbj4KCQkJ
CQkJPC9mYzppdGVtPgoJCQkJCTwvZmM6Y2hhcnREYXRhc2V0PgoJCQkJPC9m
YzpjaGFydD4KCQkJPC9jb21wb25lbnRFbGVtZW50PgoJCTwvYmFuZD4KCTwv
c3VtbWFyeT4KPC9qYXNwZXJSZXBvcnQ+Cg==

--001a113cd16ec7531a051194861b
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

--001a113cd16ec7531a051194861b--