pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcompression in replication
7+ messages / 5 participants
[nested] [flat]
* compression in replication
@ 2021-06-16 08:11 Massimo Ortensi <mortensi@unimaticaspa.it>
0 siblings, 2 replies; 7+ messages in thread
From: Massimo Ortensi @ 2021-06-16 08:11 UTC (permalink / raw)
To: pgsql-admin
This is a multi-part message in MIME format.
--------------75B86CE320617E8CC5427D98
Content-Type: text/html; charset=iso-8859-15
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body>
<p>is there any way to compress the traffic for streaming
replication ?<br>
</p>
<div class="moz-signature">-- <br>
<p class="MsoNormal" style="mso-margin-top<p class="
msonormal"="">
<b>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#1F497D">Massimo Ortensi - Responsabile
ICT</span>
</b>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#2E74B5"> <br>
</span><span
style="font-size:10.0pt;font-family:'Arial',sans-serif;color:black">
<a href="http://www.unimaticaspa.it/"; target="_blank"><span
style="font-family:'Segoe
UI',sans-serif;text-decoration:none"><img
style="width:1.177in;height:.3645in"
id="Immagine_x0020_1"
src="cid:part1.AB0B4A56.51484E89@unimaticaspa.it"
alt="logo" width="113" height="35" border="0"></span></a></span>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#2E74B5">
<br>
</span>
<span style="font-size:9.0pt;font-family:'Segoe
UI',sans-serif;color:#4F81BD">
<br>
<span style="background:white">Via Cristoforo Colombo, 21 -
40131, Bologna
<br>
Tel. 051 4195069
<br>
Cell. 3351092560</span>
<br>
<span
style="font-size:9.0pt;font-family:'Arial',sans-serif;color:#365F91"><br>
</span><u>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:blue">
<a href="javascript:message_new('mailto',
{mailto:'mortensi@unimaticaspa.it', folder:'SU5CT1g=',
msgid:'', subject: '', body:'0'})" target="_self">mortensi@unimaticaspa.it</a></span>
</u>
<span
style="font-size:10.0pt;font-family:'Arial',sans-serif;color:#2E74B5">
<o:p></o:p></span>
</span></p>
</div>
</body>
</html>
--------------75B86CE320617E8CC5427D98
Content-Type: image/jpeg;
name="UnimaticaSPA.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.AB0B4A56.51484E89@unimaticaspa.it>
Content-Disposition: inline;
filename="UnimaticaSPA.jpg"
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAAeAAD/4QODaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzE0MiA3OS4xNjA5MjQsIDIw
MTcvMDcvMTMtMDE6MDY6MzkgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcFJpZ2h0cz0iaHR0cDovL25zLmFkb2JlLmNvbS94
YXAvMS4wL3JpZ2h0cy8iIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8x
LjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBl
L1Jlc291cmNlUmVmIyIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAv
IiB4bXBSaWdodHM6TWFya2VkPSJGYWxzZSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDo5
RjVGQUM0REQwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wTU06SW5zdGFuY2VJRD0ieG1w
LmlpZDo5RjVGQUM0Q0QwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wOkNyZWF0b3JUb29s
PSJBZG9iZSBQaG90b3Nob3AgNy4wIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3Rh
bmNlSUQ9InV1aWQ6OWEzN2QwNWMtNjNlZi0xMWRmLWI1OTEtODhmYjNiMDkyY2NkIiBzdFJl
Zjpkb2N1bWVudElEPSJhZG9iZTpkb2NpZDpwaG90b3Nob3A6NmY3MTZlNzAtNjNlYS0xMWRm
LWI1OTEtODhmYjNiMDkyY2NkIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwv
eDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFkb2JlAGTAAAAAAf/bAIQAEAsL
CwwLEAwMEBcPDQ8XGxQQEBQbHxcXFxcXHx4XGhoaGhceHiMlJyUjHi8vMzMvL0BAQEBAQEBA
QEBAQEBAQAERDw8RExEVEhIVFBEUERQaFBYWFBomGhocGhomMCMeHh4eIzArLicnJy4rNTUw
MDU1QEA/QEBAQEBAQEBAQEBA/8AAEQgAggGkAwEiAAIRAQMRAf/EAKwAAQABBQEAAAAAAAAA
AAAAAAAGAQMEBQcCAQEAAwEBAAAAAAAAAAAAAAAAAgMEAQUQAAIBAwEEAwwIBgICAgMAAAEC
AwARBAUhMRIGQRMUUWFxgZGh0SIyklNUscFCUmJygiOistKTFRYzQ8IkY3M0RDURAAEEAAMF
BQcBBwUBAAAAAAEAEQIDIRIEMUFRYVJxkaEiE4GxwTJCYhQj8NHh8ZIzU3KConMVY//aAAwD
AQACEQMRAD8A6BSlKIlKUoiUpSiJSlKIlKUoiUpSiJSrc00WPE887iOKMFndjZVA3kmtDm6v
nZIYYobEi4OsjDALkTIbqrfuArCjNsuwLbvVWiLfySxxLxyuqL95iFHlNY66rpbNwrmQFu4J
UJ/mqNdnxo5hLkLEzsyOvaQZpmQe0rdcXc3va6LbZcb69tPhGV8dnj49r9S0TbFuGtY443L5
u5RFLFZWAZSCDtBG0VWolFDDHfJxD1AuA0mG4RU9piWReONrbFVHUXrZYmtSwHqtT4TGGEXb
kHCiyMARHOtzwNt9oEoT0g7KIt3SrU2RjwWM8qRBtil2C3I7l6t/5DA+ah/uL6a6Ik7AVxxx
WTSsft+D8zF/cX01Xt2F8xF76+mmWXAo44q/SrHbcP48fvr6ar2vE+PH76+mmU8Cjjir1Ktd
qxvjJ7w9NO04/wAVPeFGPArrhXaVb7RB8RPeFOuh+IvlFGPBHVyleOti++vlFV6xPvDyiuMi
9UrzxL3R5arcd2iKtKpWp1rW308dTi40mVlEXsqMY0B6XZR5h5qlCEpnLEOVwkAOVtt201jv
qWnRnhkyoUbuNIoPnNQHNn13UGJy1yHU7oxG6RjwIo+msQYOYN2LKPBE3orZHRBvNYH+1UHU
HdHvXTIcvFn/AOCaOX8jq30Gr1ct7DmA8Qxpgw3MI3B8oFbjTda5gwGCvDPlY43xSo/EB+CT
hv5b1yeiYPCYlyOC7G9/miRzU6pWPhZkebjrPGroDsZJFKOrDeCGrIrGQQWOBCvBdKUpXESl
KURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSsLWMp8TTZ5otk3DwQ/8A
2SERx/xMKItbkTf5HKMpXrcPGl6nDx/s5OWh9aVz9yIg+MFuhaxUSTU/383rMjH9fsqqpI4r
2WUqu1SxF0+6tunbV3LjOJiNjYps8SLp+G2zY7rxzS+Gw81YJz2hxdM0/GkkiAhEkk6sbM3V
FurNrXIuNnF4qIqIW07Mglb1cjGDrYbXyhOP2ldumTrU4XPTa9ZNkxMrG1c5C5cEksjhVAUG
ScBC0O1ibBT6u9vDYVr5lllyIyWkyHZgnHf10DyJFxLx33cdZ5MXVS4zRhm7aGhUpxI7FlVw
wG08FiDbZRFe1GTF1TUBFjKrpAqvkyRH96VZP+r1fWaMLtcdOxe7XkGXCcYqRl9NyCyR4koA
FmUkxhGHqrIoPADuYcO5tnjHSDFj1N4g0edLO+FiMtusFlDqE6w2C3JarebNlPgJCC3+Sw85
OrViHPCXLRgtchr2t4aIstMWDKxzok7GXFnj6/SshtrKq/8AWS23iiuO+V37jUTbFlhleGWE
iSNijgISLrs2G1SvKkU4Zzccf8HV6pjqNpCnZkJ4CvF5akasGUMpupFwe8a0UamVQIbMDizs
yqsqEyC7Fc1SJvhN7h9FX0jPw29w+iuiUqw61/o/5fwUfx/u8FAUjPwz7h9FXkjPwz7p9FTi
lROrf6fFd9Hn4KGoh+4fdPoq8iH7h90+ipZSonUP9Piu+lzUaRT90+6avIp+6fIa39KibuXi
penzWmRT90+SryDveatnSomx9y7l5rCQd6r6VepUTJdZeGkjjA43VL7uIgfTXntOP8VPeFQL
mvMTK1mVCwKYoEKg22H2n85rT/s/h81bIaHNCMjMgyDs3FUS1DSIEXbmuq9px/ip7wp2nH+K
nvCuVfs/h81P2fw+apf+eOs/0/xXPyT0+K6r2nH+KnvCnacf4qe8K5V+z+HzU/Z/D5qf+eOs
/wBP8U/JPT4rqvacf4qe8KuKysAykEHcRtFcm/Z/D5qm/JWZ12nSYpYE4sllsb2RxxAeW9VX
6T04ZxLMxxwZTruzyykMpHSlKyK5KUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKU
pREpSlEStZrpPVYajarZuMH8HWA/SBWzrX67G76VO0QvLBw5CAby0DLNbx8NqItfkgHJxwfj
5rW/EI3C/wANaLGdOyYbQZPFPxN+zHwvwIqAmVlHtMpNkv0kA7K3uaxEX+QhUvFjyx6hEwB9
eGReGYDvhbmrOrS6JkTw42BwnV4iJcY44RSjbHtIzlU4W2XUm/SBRFrMrFWPClfE6+LJICbJ
mnLzF1tGTKD6zSKPXQAX3GrogzYc7HjgjWXrV+1I0aMYAydWird4+Aybj3ySSaudfkxwYw1D
EEuXExnzVgt1oSMtJfhdgxCFrKVJvf1e5WbkZWmx5Wm6p13/AK0qSlsiTZuEfCG2bGFiLHuU
Ra/Iw9VWZxNjQCXJaRoU6xiUeYIjNYLt2LY+GkYlhzcXFyhHFkY8mHFHGjcTPFxvtctbiKle
ju1madq2KMzJzdQusztbHsjHgitbh2X2i209/ZVBn43aNU1GILOQkMeK4FyZnMqqin71yLgb
R00Re8UL/hlB2A4uan6Fc2rA5imePTdGKysjND63C5W46uPfYithlY8mHpr4igiTqI9PhJ3S
TZJ/cZd17Xv5a3vYsUxxxvEkixKFTjUNYAW2X8FWUzELBMh2fBRnHNExBZ1zhMqb5h/7jf1V
fTJl+O/9xv6qn/YMH5aL3F9FV7DhfLxe4vorUdZA/Qe9UiiXUoMmRL8d/wC43pq+k8nxm98+
mpl2PD+BH7i+iq9kxfgx+4voqB1UT9C6KT1KJpPJ8VvfPpq+kz/Eb3j6ak3Zcb4Ke6PRTs+P
8JPdFROoifpUvSPFR9JX+I3vH01fSRvvn3jW66iD4a+6Kr1MX3F8gqBtHBdyHitWjt94+U1f
Rj94+Ws3q4/uL5BVeBPujyVEzB3KWXmrCE92ryV64V7gpUCV1lZbDw2Ys0EbMxuWKKST39lU
7DhfLxe4voqEcxnMxNZnQTyrHLaWMB2AswsbAHoYGtZ2zM+Zl/uP/VW2GklKMZCzCQB2KiV4
BIMdhXSuw4Xy8XuL6Kdhwvl4vcX0VzXtmZ8zL/cf+qnbMz5mX+4/9Vd/Cn/k8Fz8iPQuldhw
vl4vcX0U7DhfLxe4vormvbMz5mX+4/8AVTtmZ8zL/cf+qn4U/wDJ4J+RHoXSuw4Xy8XuL6Ku
RY8EN+pjSPi38Chb28Fcx7ZmfMy/3H/qqX8mJkNhz5U0jyCWThj42LerGLG3Ee6aru00q4GR
m+5lOu0SkwiykdKUrIrkpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURK
pVaURRmaLIwsiPTDJ1eFEXyMQFiiugswiYrdmEJv+2PaW3QCK1zpiNo0uEccDEkyFlBA9aGX
ruFxMo4uFW4SVPQvqta1zL83CgzoDBODYEPG6nheN12q6N0MtRrNwsvBRxL+3wo642fCtoUe
W5kmlRFZklf2S+1LXtw3tRFsexCTFRcWdex5KAFWa7wr7R6iTaSpItwnd0HorQ6jp8KS5OZ1
sYwcyeJE4VedhJJ/zCOJXCleK53E3vsq9Di4s2RHIuHEjZcxQyY4UwKvC3VcYKyoWdlvsAsp
F9teRHEmPj5RgjZcmKWWJI8fHuBGUG8RX3PxbBewoi8wSPEwdo5smHbxSzNLB1RS3DdiUjcO
N3TfZYirsONDHkIkAnxp0gefDSRnnRJD7WTJHK5C8TXUBQSL3axIFXhHp2l5sc0sUMkM0fDJ
lBj1ysSwVoQSLiwsRGvECbi9X8LRp8sIshmh0+Ni0TTse1OCOBlT7UKuPa+0dtgt6Iq4eTNN
xatqcofDwAxQqvCj5AHVuyLxNfg2pcGzMSR0VoX1vVppXl7VLGJGLCNWsqA7lHgqb5Wk4GXj
xYs0V8eG3VxKSiDhFl2IRuG6sUcr6GN2N/G/9VaaLaawc8TKR5AgBVWQnIjKQAOaiq6rqh//
AHJveq6up6n83L71SYctaKN2P/G/9Vehy7o4/wCj+N/6qtOpo6D/AEhQ9Kzq8So4upaj81L7
1Xl1DP8AmZPerfjQNKG6D+Jv6qqND0wbof4m9NRN9PT/AMQu+nPj4rSLnZ3zEnlq8uZmfHfy
1txo2nDdF/E3pr0NJwBui/ib01A3V9PgFLJPj4rVrl5Xxn8tXVycj4reWtgNNwhuj859Nehg
Yg3J5z6aibIcPBdyy4rDWef4jeWrqyy/fPlrJGHjjcnnNehjQjcvnNQM48FLKVZV3+8auqzd
2vQhjG4V6CKNwqJIXWWPlabgZrK+XjpMyAhS4uQD0VY/1/RPkofdFbCtVrONrbDr9JyuBgPW
xmVCGt0ozDYfDsqUJSJERZkHMkBckAz5c3sxV3/X9E+Sh90U/wBf0T5KH3RUPm5h5igkMU+Q
0Uo3o8SKfOtef9m175v+BP6a1fi6j/KP6pKn1qujwCmX+v6J8lD7op/r+ifJQ+6Khh5m10b8
v+BP6ay9P1LmzUnC4kxZL2aZo0ES+FuHb4BQ6e+Ic2gAbzKSC2slhAn2BSj/AF/RPkofdFZs
EEONEsECCOJBZUUWAq3hQZEGOqZM5yZt7ykBbk9Cqu4VkVjlKRwMjMDmW8VeABiAyUpSorqU
pSiJSlKIlKVjT6hgY0giyMiKGQjiCO6qbd2xNdAJwAfsQkDasmlYq6pprCMrlQkSsUjIdfXY
EAhdu07auHLxRkDFMydoI4hDxDjt3eHfTLLge5cccVepVKrXF1KUpREqlVrxNIIYXlb2Y1LH
wKL0Re6Vy/8AyOoP6/aphxEtbrG6dvdqWcmHIlxsnInleUNII06xi1uBbm3Ee61ardIa4GZk
C25lTC4SllAUkpStfr2S2Lo+XMhKuIyqEGxDP6ot5azRiZSER9RA71aSwJ4YrYUrl4z88bO1
z/3X9NTjlfrf8LFNPI0jSl5OKRixAJsNrd4Vou0pqjmMgXLMyrruEyzNg63FUrmmRqedLkTS
rkzKskjsqiRgApY2AF+5XmPVNQhlSYZMzGJg/C0jENwm9iCemrPwJN847lD8kcCunUq3BMk8
Mc8Zukqh1PeYXFeyQASdgG81ibctCrVK5nNqefLPLKMmZRI7sFEjAAFjYAA9ypVyYciXDyMi
eV5eOXgTrGLWCKL24u+a1W6U1wzmQOzBlTC4SllAW0m0TS5pDK2OqSm95IiYnN992iKmvA0H
BBHrZBA3DtE1h4LPsqH63qWY+r5fVZEqRpJ1aqjsq+oAu4Hu1m8oy5mTqrGXIlkjhiZiruzK
SxCjYT4aS0hjX6hkPlzM3ggvBnlA3spVi6Xp2G3HjY6RyHfJa77fxtdvPWXWk5tzXxdJKxOU
lndY1ZSQwHtNYjvLUK7fn/Nz/wB1/TXKdLKyGbMI4tsXbLhAszrp9VqAcv5+YdaxFlyJXR2Z
SrOzKbq3QTU/qu+k1SESczh1KuwTBLMxZKpXieaPHhknlPDHEpdz3Aoua5xlavqGVky5HaJY
xKxZY1dlVV+yoAPQKlRp5WuxyiO9cstEGwd10ulcvOoZ4BPap9n/AMr+muhaKsi6TiCVmeQx
KzMxJYlhxbSfDXb9MaogmQk5bYuV25yQzMs6lKsZmVFh4suVMbRwqWbxdHjqgAksN6tV6q1z
KXVNRmleZsmVWkYsUWRgq3PsgA9FW2z9Q4TbLnvY/wDa/praNBLrHcs/5I6Suo1SsfTpTNp+
NMTcyRIxJ27SovUA1DU8yXUMqSPJlWNpX4FWRgAqnhFgD3qop05slKL5cisnaIAFnzLpFK5f
2/P+bn/uv6advz/m5/7r+mr/AMCXWO5V/kjpK6hSuX9vz/m5/wC6/podQzwCe1T7Nv8Ayv6a
fgS6x3J+SOkrpWRiY2UnV5MSTJ3HUN9Na1+VdCc37Nwfld1Hk4q12rz5OFythx9c4yJuqVpO
I8e0dY3rb6i7ahqAUntU+wfFf01ynT2GJMLTAZjHB8W3pZZAECUM2DqfQct6JAwZMRGYbi93
/nJrZKqqoVQFUbABsArG0yN4tOxkkYvIIk42YksWIubk9+veXmY2FA2RlSCOJd7HpPcA6TWW
RnKTGUpl2G9XARAcARV6lQvUeccyYlNPQY0XRI4DSnxeyvnrRz5ubkm+RkSyk/edreQG1aIa
Gwh5EQ5bSqpaiI2DMun8a3tcX8NVrlNvD5TWz0KfUn1LGxsbJlRXcGReIsvAvrP6rXG4VKeh
yxJFgwD4hlyOocgZdvNdDqtUpWJaEqtQzmzWJjnLhYsrRpji8rRsVJkb7JKn7I+mtF2/P+bn
/uv6a116KU4CRkI5sWZUSvEZEM7LqFR/nGGD/FNO0adaJIlEhA4gpcbOLfasTkvMnmly4Z5X
lsEdeNi1vaU24qlLxpIvDIodd9mFxs8NVEGi4P5shBwwfepgiyHDMopzDhQvnRY2OixGHDny
YUQBQJVZWBsO7w1bwpev1nTtXf1W1GWfgB3iJI1jjHmNS8xxl+MqC4HCGsL27l6p1UXqngW6
exsHq+DuVIahoCJD+WUXfqd/ghqxd94PcvVVpSs6sSlKURK1fMk/UaJlsDZnTq18Mh4PrraV
G+d5+HT4Mcb5pgT4IwW+m1W0RzWwH3DwxULC0JHkoZYDZ0VP+VYOp0PHO4y8Up/Wxt5q5+wJ
BA3nYPCdldRw4Bj4kEAFuqjVLflAFbdfJoRj1Sfu/mqNMPMTwHvV+o7zrPwaZHCN80yjxIC5
+gVIqhvO8/FmYuOD/wAcbSEd9zwj+Wsmli90eXm7ldcWrPPBRlr8Jtvtsrok5Gm8usNxx8Xh
H5uDhHnqB4EHac/Fx7XEkyA+C9z5hUz5xn6rRjGDtnkSO3evxn+Wtmq81lNfGTlUU4RnLkoI
BwqAegV6ZWRijgqy7Cp3iqBS5CDe5Cj9R4frrbcz4nZdYkAFkmRJF79hwN51rSZATEeoE9zK
kDyk8CB3qRcnZnX6Wcdjd8Rin6G9ZPR4q2WsZHZtKy5ulYnt4SLDzmofylmdm1dYmNo8pTGf
zr6yfWK3/OM/VaOYwbGeREt3QDxn+WvOtqbVAbpyEu/atUJ/ok9II/coKo4VAPQK6By5GuJo
EEjC10ad/wBRL/RUAILeqN7eqPCdldB1huwcuzopsY4BCtu6QI9nlrRrMRXX1z/b3qujDNLp
iuftIZXaVt8jM5/UeL66lnI8FosvJI9p1jU/kHEf5qiQFtg6Kn3KcHU6JC3TMWlP6m2eYVLW
SakjqIHxXKA9j8A603O2Tx5mNiA7IkMjeFzwjzLUdSJnimlHswhC3624BWZruT2rWMuW91D9
Wp70Y4PpvV/Exz/rWo5NvamiUHvRlSfO9Sr/AE6axxyj2yOKjLzTke3wWLo78Gr4Lbv30Hve
r9ddKrluM/V5UEn3JY28jiuoSyxwxPNIeGONSzsegKLms2vHmgeIIV2mOEu1RrnTUuCGPTYz
6037k1vhqfVX9TfRUUjhZ4pptyQhbnutIeFV+k17z8187LmzZdnWtcA/ZQbFXxCs/PxTg6Hh
QuLTZkpyZR0gKvDGviDeWtNcfShCH1SOPbtkqpnPKUtwH8lqCOIcI+16vl2V1SGMRQxxDcih
R4hauaafF12o4kPQ80YPg4gT9FdPrPrzjAdpVmmHzHsVKifOmpXMemRndaWe38C/X5Kk+Vkx
YmNLkzG0cSl2PeArmeTky5eTLlTf8kzF2HcvuXxDZVeiqzTznZDZ2qWom0co2y9yyNJwe3ZT
RsCYoopJZLdxVPCPG1qwVN1BPSBeprynpvVaXJkSC0maDbuiICyeXfUKAsOHubPJsrdXZnss
A2Qyj3uqJQyxiepyuhctP1ug4m2xCFCRvHCStYn+k6V8XI98f0165Mk4tHK/DmkXy2b6639e
bZOddtghIxeZ2LVGMZQjmD+VQvmDl7TtKwO0QvK0rSLGgdgV9badgUdAqNk2BPc21LOeJ9mH
jDuvKw8A4R9NRaKIzSxwjfK6oP1ELXoaaUjUJTJJLlzwWW0ATIiGZSzB5P0+fCgmneYTSxq7
hWAALC+wcNX/APSdJP8A2T++P6akCqEUIuwKAB4BXqvOOpuckTkFqFUG+UKH87SgSYWIuxUV
pLeRF+uo7iwnIy4Mcb5ZUTxFhfzVsua5+u1uUA3EKJGPDbjPnavPLEHX65j3FxEHlP6RYedq
9Cr9PTA8IGXfis0/NaR9zKfTzRY0DzzMEiiUs7HoArnWr6tPquUZ5LrEtxBD0IvdP4j0nxVI
udc4pjw4CGxnPWS/kTcPG30VDybC++q9FSBH1CMZfLyCnqJl8g2DasjBwMrUMgY2KnFIdrMd
iov3mPcqW4fJmnxKDmO+TJ0gExx+JV2+es7l/S103TkRh/7EoEk7dPER7PgXdW0qi/VzMjGs
5YjBxtKnXTEAGQclag8q6CRbsgHfDOD/ADVXTuXMHTcxsvGLkshQI54gtzclTv6K21Ko9awg
gzkQdrl1bkg75RhySsTU86PTsGbLfb1a+ov3nOxV8ZrKqGc5al12Umnxm8ePZ5bdMjD1R+lf
prtFXqWCO7bLsXLJ5Yk9yjskjuzyynjkcl3PSzMbmszVMHsE0EBBEjY8ckt/iMW4vJuq9y7p
/b9ViRheGD96XuWU+qvjas7nVLapA/Q8Fvdc+mvTNg9aNY6ST8FkEf0zM8QF45Mk4dXkTokg
PlVlP11Oa57yxJ1eu4xO5+NPeU+iuhVi1wa0HjELRpz5OwpSlKyK5KUpREpSlESoVztPx6hj
44OyKIuR33a30LU1rn/NTE67kX+yI1Hg4A3/AJVq0Qe5+mJPwVOoPk7SsHTIO0aniQEXDzJx
D8KniP0V02oByqobXce/QshHh4bfXXQKlrz+pEcIv3lc0w8pPNUrnvM0/X65kkG4i4Yh+kXP
nNT+aaOCF5pTwxxqXc9wKLmuXzzNkTy5De1M7SH9RvXdBHzSlwDd65qTgBxLra8qQddrcTEX
EKPIfDbgH81bHnie74eMDu45WHkRfrr1yPin/wBrNI2ErCh/L67fSK1vNk/Xa3Iu8QRpGPCf
XP8ANV3z6z/rh+3vUPlo/wBclhaPD1+rYcW8GZWPgT1/qqR874nFj4+ao2xP1Tn8Mm7yMK1n
J8HW6z1nRBEzeNyEH11MNUwxnafkYh3yoQp7jDap8tQ1FuXU1ndAY/7tvgpVQeqX3fBc1imb
HljyE2PC6yL4VN6k3OmUk0Wnqh9WQNNbvFQFP8VRfbuYWI2MO+NhFZmdk9oxtOUm7QY7Rt3i
rkD+ECtM4PZXPpzDvCpjJoSjxZNIg7RquHFa4Mqsw7yeufoqUc6z8GmxQDfNMPIgLH6q0/J8
HW6z1nRBEzeNyEH11kc7z8WbjY4OyONnI77nh/8AGqbPNqq49EcysjhTI9RZRpr8Jtv6PDXS
gV0zRgTsGJjjyonprn2nQdp1DFg3iSZA35QeI+YVMucMnqdHMQPrZLrHb8I9dvMtc1Qz2VV8
ZOexKfLGcuAUFuSOJt59Zj3ztNS0Ypi5HdbWaSPr2/U4f6KiaRtNIkK+1Kyovhc8P110bU8d
RomTjoPVTHdVHeVNn0VLVTY1D/6CXcuUxcTP2t3rnBPD6w+yQfIb1MucNS4MCLCQ2fLs0lui
Jdp8psKhe1o9m8j6qztWze25rTBrxIiRxE/cRdp8bXNW2V5rKydkMx9uDKEZtGQ6mC96Hpx1
LU4oCLwp+7P+RTu/UdlbHnSUNqkMI3RQ3I77sfqWt1ynppw9O7RItp8u0hvvVPsL5NvjqMcy
TddrmUehCsY/Qo9NUwn6mpLfLVEgduwqyUctI4zIVeWohLrmKDuTjk91Tbzmuh1B+S4+LVZZ
OiOA+V2HoqZ5E8WNBJkTHhjiUu57wF6z60vcAN0QO9W6fCD81GedNSssWmRna1pZ7fdB9RfG
dviqN6fhnPzYcQGyyN+427hjG1z5K85eVJm5UuXL7czFrfdH2V8Q2Vjlk3EjwXrdVVkqEBhJ
sT9xWac808x2fBdUR8eNFjRlCKAqqCNgGwCuY5KdXlTx7+CWRb+BjVi8XdHlr2LW2buio0af
0jI5s2bkylZbnbBmUu5GkJgzIuhZFYfqW3/jUpqGckSWzsqLoaJWt+VrfXUzrBqw18ubHwWi
gvWPaoHzfP1utMnRBEieNrufprG5dg6/W8RehGMp/QCfprH1SftGp5c17hpnCn8KngH0VuOS
oOPUZ5yNkUQUHvu3oWt0v09N2Vt7Ss481vbJTSlVrG1KcY2n5ORe3VxOwPfANq8oByAN+C2k
sHXOM6ftGdk5HxZXYeC9h5hW+5Ig4svKyehEWMeFzxH+Woyt+EX3221N+SoODS5JiNs8zG/4
UAQfQa9XVHLQQN7RCxUh7Ae0rR83yF9bZSdkUSKPHxN9da3T4hNqOJC21ZJ41Yd7iBrZc3Rl
NbdjulijYeK6fVWpxp+zZUGTv6iRJCO8pufNUqv7EW/x4drLk/7hfqXU6V5jdJEWRDxI4DKw
3EHaDXqvHW5KUqlEWNqObHgYU2XJuiUkL95tyr4zXNJJZJZHmmN5JGLyN+Jjc1I+c9S63Ij0
6M+pDaSa3S5HqL4htqMkgbSbeGvU0dWWvMds8fZuWO+byYbI+9TnlPDjwtO6+VlWfLIkYEi4
T7C+Tb4613O4RpcOVSGuJENjf7rVFbxHpHlqqlPskeKpR05F3qmbnHBuOC4bXhkyt7VmaVJ1
Wq4UnQJ0B8DHh+uum1ylHMbpINhRlYH8pBrqqkMAw3EXFZ9eMYHkR3K3THCQ7FWlKVhWhKUp
REpSlESoLzhjPDqwnt6mTGpB/FH6rDyWqdVharpWPquKcea6kHiilHtI/dH1irtPaK7BI7Dg
VXbDPFht2hc7w8ubCyosuD/kia4B3MNxU94iplDzlpDxhpRJDJb1kKFrHvMtwajWby7rGG5B
gM6DdLAOMEd9faFYHZcq/D2eXi3W6t7/AEV6M66bmkS7b4lZoysrcN3hbrX+ZTqUfZMVWixC
byM2x5LdFhuX6a0cccksixRKXlkIVEG9mO4VnYug6xlMBHiugP25v21HvbfNUt0LlyDS/wB+
VhPmEW6y1lQHeEH11GVtNEMsGJ3RBfHmuiE7JPLv/cs7ScBdO0+HEG1kF5GH2nbax8tc81Cf
tOoZU/RJM5XwA8I8wrpOU8iY0zxKXkVGKKu8sBsArnS6JrVhfBmv0+qN/lqnRyGayc5AGTbS
3Mqd4LRjEFgpByPB6mZkkb2WJT+UcR/mqV1qOV8KXC0hEnQxyyO8jowsVLGwv4hW3rNqJZrp
kY4t3YK6oNCI5LnnMmF2PWJ1AtHP++n6/a/iBrV1NubtLnzMeCfFiMs8LcJRRdij7/IQKi3+
F1n5Gb3R6a9DT3RlVHNIAgMXPBZbayJlgW2qQcjwft5mSR7TLEp/KOI/zVpeZZ+v1vJI3RlY
h+gbfOalvLGHLhaQiToY5nZ5HRh6wJOy/iFRDI0rWp8mac4M15ZHf2R9pie7VVUonUWzMhh5
Q5/bgpzBFUIgHiVkcpQddrcbEXEEbyHwmyD+asvnbJ483HxQdkUZkb8znhHmWsvk/TMvFlyp
8uF4GYJHGHFiRtZreatVrWn6vmarlZC4czRl+GNguwog4QRt6d9dEoy1RkZRauDAvvP81xiK
WYvKSsctY3adbxgfZi4pm/QNn8RFT/IXjx5U+8jDyio3yhpeXiz5OTlwtAxVY4w4sSL8TEea
pRWfV2CVuBcQAGHeraItDHeuUKLKB3BathoenHUtSixyLwp+5P8AkU+z+o7KyX5U1zjfhgQr
xNwnrF3Em1SblnR5NMxHOQAMudryAHi4VXYi389a79TCNZMJRMjgGPHeqa6pGQzAgDa63AAA
sNgFcvzZevzcmbf1k0jDwcRtXTchnWCVowWcIxVRvJA2AVzhdF1qwvgzX6fVG/y1RoTEZySB
sGJVmoBOUAE7Vv8AkaLZmzW6Y4wfACx+mvXOmpcMcemRn1pLSz2+4D6q+NtvirM5VxMjB0uU
5MTxyvK7mMj17AADZ37VGs3A13Oy5suXBm4pm4gLeyu5V39AqURGeqnOUo5YMznadi4XjTGI
BeS1sccksiQxDillYIg7rMbCuj4ekYOLiRY/UxuY1Cl2QEsekkkdJqOcr6HlpqBy86BoVx1/
aEgtxSNsuPyipjUNZc8hCJwjiW4lSorYGRG3isfsOD8vF7i+ioBr0Sw6zlxqoVeMFVAsAGVT
sro9QnmTStRn1mabHxZJYnWOzoLi4Wx6e9UdFNrDmlhk3nml8XiGG/crHKMnBraL8SKRfJZv
qqb5cwx8Wac/9UbP7oJqE6HpurYur4s0mJLHGrEO5XYFZSpvtqU8xLkSaPkRYsbSzSgIFQXN
mIDeau6oRlfBiCJCIJfmlLiuWBwdc6UkgE7ztPhO2pnyRDw4GROf+2aw8EYA+kmo1/hdY+Rm
90empxy9iPh6PjQyoUl4S0ineGcljfy1frLI+k0SDmkNhVdETncghgtlWk5un6rRJVG+Z0i8
pufMK3dRvnDHzsuPFgxIJJ1VmkkKC4FhwrfymsOnAN0HIABfHlitFr5JNwZQwmwJ7m2uj6DA
cfRsOI7+qVj4X9c/TUGXQtYdlQ4UqhiFLECwBNiTtro6IqIqLsVQAPAK1a6wGMIgg4kli+xU
6eJBkSG3KPc46Y+RipnQrxSYt+sA3mJt5/SdvlqF98V1bfsNRbV+TxI7ZGlssZYktjPsS/4G
Hs+Dd4K5pdTGMfTmWb5T8F26ok5o+0LWaLzNkaZGMaZDkYg9gA2ePvLfYR3q3685aMRcmVT3
DGb+a9RGfSNVxyRLhzC32lXjXyperK4uWxsuPKx7gjf0VfPT0WHNx2mJVUbbIhveFLpedcDi
VMeCWQsyrxPaNRxG19pJ81bvPzI8HDmy5fZiUtbun7K+M1AINB1nJIEeHIvSGl/bXZ+bbUg5
rTVcsQYWNjSSxKBLM6C6l9yqDs3b/JWeyinPXGEg2OfzbgrY2TyyMgftwUTllknleeY3llYu
5/E22pPydpUckc2fkRh1c9VCrgEWX22se6dnirRroWsu6oMOVOMheNgAFubcR27hXQsPFjw8
WLFi/wCOFQg79unx1bq7gKxCBHm6TsAUaIEyzSGzjxVOw4Py8XuL6K0HOWJjxabDJDEkZE6g
lFC7GVt9qk9afmnFny9JaPHjaWUSIwRdpIB21jomRbAk4Zt5V9kXhJhuXP32qfAa6VDmcGjR
5vCX4ccS8I3mycVqgf8AhNZ+Rm90empjgy52Dy7jnsbzZUSBDjbFewbh6fw7a16zLIQYxl52
bMN6oocGTgjy8Fi6Ln6xqITUHzMYYl2M+KiXeNQDYcW+9ZcXNWiyvEizMOuPCCUYKpJsAxtY
XrRPDPDPm6xFhPpmImNIrxuQOslkHCtkG4XN6pi4OZm6fp+mJhyQY0DDIyslwB1n2v2rXJLA
7KhKqokyLCOzy5RlwJL8SMFMTmMBieb4rccxaxmYjLi6cV7SI3yZmYcQSGMdzvmtrp2QcrAx
slvamiR26NrKCajiaPqWoJqGp5DTYmRkcax4oC3eJR6kb3B396t1y9HPFouLFkxtFMiFWRth
FmIHmqq2MI1ARMTKMmk23EYqUDIzLuxGC2VKUrMrUpSlEVKrSlEVKrSlEVKrSlEVKrSlESlK
URUqtKURUqtKURKUpREpSlESlKURUqtKURKUpREqlKURVpSlESlKURKUpRFSlKURVpSlESlK
URUqtKURKUpREpSlESlKURaTnD/+Bkb96bvzDf3q2uH/APiQbv8AjTdu9kUpVx/sR/7Je4KA
/uH/AEj4q9SlKpU0pSlEX//Z
--------------75B86CE320617E8CC5427D98--
Attachments:
UnimaticaSPA.jpg (image/jpeg, 11.3K) download
view image
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-16 14:54 Vijaykumar Jain <vijaykumarjain.github@gmail.com>
parent: Massimo Ortensi <mortensi@unimaticaspa.it>
1 sibling, 2 replies; 7+ messages in thread
From: Vijaykumar Jain @ 2021-06-16 14:54 UTC (permalink / raw)
To: Massimo Ortensi <mortensi@unimaticaspa.it>; +Cc: pgsql-admin
On Wed, 16 Jun 2021 at 13:41, Massimo Ortensi <mortensi@unimaticaspa.it>
wrote:
> is there any way to compress the traffic for streaming replication ?
> --
>
I think this should help reduce traffic as it would decompress only when
replaying.
I have not used it, but now that you asked, I will test it out.
PostgreSQL: Documentation: 13: 19.5. Write Ahead Log
<https://www.postgresql.org/docs/current/runtime-config-wal.html#wal_compression;
Also, pg_basebackup supports gzip stream, and so does COPY but I do not see
exclusive mention of compression support in replication slot details.
But if you try having a sidecar like envoyproxy or any tcpproxy per server,
maybe communication between sidecars can be compressed but not db to
sidecar.
Gzip Compressor — envoy 1.19.0-dev-069478 documentation (envoyproxy.io)
<https://www.envoyproxy.io/docs/envoy/latest/api-v3/extensions/compression/gzip/compressor/v3/gzip.pr...;
(this is not pg stuff but ... )
[pg -> sidecar -> compressed wal stream] -> [sidecar -> decompress -> pg]
I have not tried any option, FYI.
--
Thanks,
Vijay
Mumbai, India
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-16 14:55 Vijaykumar Jain <vijaykumarjain.github@gmail.com>
parent: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Vijaykumar Jain @ 2021-06-16 14:55 UTC (permalink / raw)
To: Massimo Ortensi <mortensi@unimaticaspa.it>; +Cc: pgsql-admin
sorry, the link was broken.
this was the param.
"wal_compression (boolean)
When this parameter is on, the PostgreSQL server compresses a full
page image written to WAL when full_page_writes is on or during a base
backup. A compressed page image will be decompressed during WAL
replay. The default value is off. Only superusers can change this
setting.
Turning this parameter on can reduce the WAL volume without increasing
the risk of unrecoverable data corruption, but at the cost of some
extra CPU spent on the compression during WAL logging and on the
decompression during WAL replay."
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-16 15:00 Massimo Ortensi <mortensi@unimaticaspa.it>
parent: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Massimo Ortensi @ 2021-06-16 15:00 UTC (permalink / raw)
To: pgsql-admin
This is a multi-part message in MIME format.
--------------1553ED15CC70BAB9B8EB79B2
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I tried with wal_compression=on but seems to have no effect<br>
</p>
<div class="moz-signature">
<p class="MsoNormal" style="mso-margin-top<p class="
msonormal"="">
<b>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#1F497D">Massimo Ortensi - Responsabile
ICT</span>
</b>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#2E74B5"> <br>
</span><span
style="font-size:10.0pt;font-family:'Arial',sans-serif;color:black">
<a href="http://www.unimaticaspa.it/"; target="_blank"><span
style="font-family:'Segoe
UI',sans-serif;text-decoration:none"><img
style="width:1.177in;height:.3645in"
id="Immagine_x0020_1"
src="cid:part1.0F0CE5FD.A56BDC06@unimaticaspa.it"
alt="logo" width="113" height="35" border="0"></span></a></span>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:#2E74B5">
<br>
</span>
<span style="font-size:9.0pt;font-family:'Segoe
UI',sans-serif;color:#4F81BD">
<br>
<span style="background:white">Via Cristoforo Colombo, 21 -
40131, Bologna
<br>
Tel. 051 4195069
<br>
Cell. 3351092560</span>
<br>
<span
style="font-size:9.0pt;font-family:'Arial',sans-serif;color:#365F91"><br>
</span><u>
<span style="font-size:10.0pt;font-family:'Segoe
UI',sans-serif;color:blue">
<a href="javascript:message_new('mailto',
{mailto:'mortensi@unimaticaspa.it', folder:'SU5CT1g=',
msgid:'', subject: '', body:'0'})" target="_self">mortensi@unimaticaspa.it</a></span>
</u>
<span
style="font-size:10.0pt;font-family:'Arial',sans-serif;color:#2E74B5">
<o:p></o:p></span>
</span></p>
</div>
<div class="moz-cite-prefix">Il 16/06/2021 16.54, Vijaykumar Jain ha
scritto:<br>
</div>
<blockquote type="cite"
cite="mid:CAM+6J97VdKJjaU2Uwn_GYThy23q0-29c2hjRrbZZh3_8eO-oJA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, 16 Jun 2021 at
13:41, Massimo Ortensi <<a
href="mailto:mortensi@unimaticaspa.it"
moz-do-not-send="true">mortensi@unimaticaspa.it</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>is there any way to compress the traffic for
streaming replication ?<br>
</p>
<div>--</div>
</div>
</blockquote>
</div>
<div><br>
</div>
<div>I think this should help reduce traffic as it would
decompress only when replaying.</div>
<div>I have not used it, but now that you asked, I will test
it out.</div>
<div><a
href="https://www.postgresql.org/docs/current/runtime-config-wal.html#wal_compression";
moz-do-not-send="true">PostgreSQL: Documentation: 13:
19.5. Write Ahead Log</a><br>
</div>
<div><br>
</div>
<div>Also, pg_basebackup supports gzip stream, and so does
COPY but I do not see exclusive mention of compression
support in replication slot details.</div>
<div>But if you try having a sidecar like envoyproxy or any
tcpproxy per server, maybe communication between sidecars
can be compressed but not db to sidecar.</div>
<div><a
href="https://www.envoyproxy.io/docs/envoy/latest/api-v3/extensions/compression/gzip/compressor/v3/gzip.pr...;
moz-do-not-send="true">Gzip Compressor — envoy
1.19.0-dev-069478 documentation (envoyproxy.io)</a>
(this is not pg stuff but ... )<br>
</div>
<div><br>
</div>
<div>[pg -> sidecar -> compressed wal stream] ->
[sidecar -> decompress -> pg]</div>
<div>I have not tried any option, FYI.</div>
<div><br>
</div>
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">Thanks,
<div>Vijay</div>
<div>Mumbai, India</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</body>
</html>
--------------1553ED15CC70BAB9B8EB79B2
Content-Type: image/jpeg;
name="UnimaticaSPA.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.0F0CE5FD.A56BDC06@unimaticaspa.it>
Content-Disposition: inline;
filename="UnimaticaSPA.jpg"
/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAAeAAD/4QODaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjYtYzE0MiA3OS4xNjA5MjQsIDIw
MTcvMDcvMTMtMDE6MDY6MzkgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcFJpZ2h0cz0iaHR0cDovL25zLmFkb2JlLmNvbS94
YXAvMS4wL3JpZ2h0cy8iIHhtbG5zOnhtcE1NPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8x
LjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL3NUeXBl
L1Jlc291cmNlUmVmIyIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAv
IiB4bXBSaWdodHM6TWFya2VkPSJGYWxzZSIgeG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDo5
RjVGQUM0REQwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wTU06SW5zdGFuY2VJRD0ieG1w
LmlpZDo5RjVGQUM0Q0QwNzIxMUU3OUVGMjhENTY5RTA2MkUxMCIgeG1wOkNyZWF0b3JUb29s
PSJBZG9iZSBQaG90b3Nob3AgNy4wIj4gPHhtcE1NOkRlcml2ZWRGcm9tIHN0UmVmOmluc3Rh
bmNlSUQ9InV1aWQ6OWEzN2QwNWMtNjNlZi0xMWRmLWI1OTEtODhmYjNiMDkyY2NkIiBzdFJl
Zjpkb2N1bWVudElEPSJhZG9iZTpkb2NpZDpwaG90b3Nob3A6NmY3MTZlNzAtNjNlYS0xMWRm
LWI1OTEtODhmYjNiMDkyY2NkIi8+IDwvcmRmOkRlc2NyaXB0aW9uPiA8L3JkZjpSREY+IDwv
eDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFkb2JlAGTAAAAAAf/bAIQAEAsL
CwwLEAwMEBcPDQ8XGxQQEBQbHxcXFxcXHx4XGhoaGhceHiMlJyUjHi8vMzMvL0BAQEBAQEBA
QEBAQEBAQAERDw8RExEVEhIVFBEUERQaFBYWFBomGhocGhomMCMeHh4eIzArLicnJy4rNTUw
MDU1QEA/QEBAQEBAQEBAQEBA/8AAEQgAggGkAwEiAAIRAQMRAf/EAKwAAQABBQEAAAAAAAAA
AAAAAAAGAQMEBQcCAQEAAwEBAAAAAAAAAAAAAAAAAgMEAQUQAAIBAwEEAwwIBgICAgMAAAEC
AwARBAUhMRIGQRMUUWFxgZGh0SIyklNUscFCUmJygiOistKTFRYzQ8IkY3M0RDURAAEEAAMF
BQcBBwUBAAAAAAEAEQIDIRIEMUFRYVJxkaEiE4GxwTJCYhQj8NHh8ZIzU3KConMVY//aAAwD
AQACEQMRAD8A6BSlKIlKUoiUpSiJSlKIlKUoiUpSiJSrc00WPE887iOKMFndjZVA3kmtDm6v
nZIYYobEi4OsjDALkTIbqrfuArCjNsuwLbvVWiLfySxxLxyuqL95iFHlNY66rpbNwrmQFu4J
UJ/mqNdnxo5hLkLEzsyOvaQZpmQe0rdcXc3va6LbZcb69tPhGV8dnj49r9S0TbFuGtY443L5
u5RFLFZWAZSCDtBG0VWolFDDHfJxD1AuA0mG4RU9piWReONrbFVHUXrZYmtSwHqtT4TGGEXb
kHCiyMARHOtzwNt9oEoT0g7KIt3SrU2RjwWM8qRBtil2C3I7l6t/5DA+ah/uL6a6Ik7AVxxx
WTSsft+D8zF/cX01Xt2F8xF76+mmWXAo44q/SrHbcP48fvr6ar2vE+PH76+mmU8Cjjir1Ktd
qxvjJ7w9NO04/wAVPeFGPArrhXaVb7RB8RPeFOuh+IvlFGPBHVyleOti++vlFV6xPvDyiuMi
9UrzxL3R5arcd2iKtKpWp1rW308dTi40mVlEXsqMY0B6XZR5h5qlCEpnLEOVwkAOVtt201jv
qWnRnhkyoUbuNIoPnNQHNn13UGJy1yHU7oxG6RjwIo+msQYOYN2LKPBE3orZHRBvNYH+1UHU
HdHvXTIcvFn/AOCaOX8jq30Gr1ct7DmA8Qxpgw3MI3B8oFbjTda5gwGCvDPlY43xSo/EB+CT
hv5b1yeiYPCYlyOC7G9/miRzU6pWPhZkebjrPGroDsZJFKOrDeCGrIrGQQWOBCvBdKUpXESl
KURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSsLWMp8TTZ5otk3DwQ/8A
2SERx/xMKItbkTf5HKMpXrcPGl6nDx/s5OWh9aVz9yIg+MFuhaxUSTU/383rMjH9fsqqpI4r
2WUqu1SxF0+6tunbV3LjOJiNjYps8SLp+G2zY7rxzS+Gw81YJz2hxdM0/GkkiAhEkk6sbM3V
FurNrXIuNnF4qIqIW07Mglb1cjGDrYbXyhOP2ldumTrU4XPTa9ZNkxMrG1c5C5cEksjhVAUG
ScBC0O1ibBT6u9vDYVr5lllyIyWkyHZgnHf10DyJFxLx33cdZ5MXVS4zRhm7aGhUpxI7FlVw
wG08FiDbZRFe1GTF1TUBFjKrpAqvkyRH96VZP+r1fWaMLtcdOxe7XkGXCcYqRl9NyCyR4koA
FmUkxhGHqrIoPADuYcO5tnjHSDFj1N4g0edLO+FiMtusFlDqE6w2C3JarebNlPgJCC3+Sw85
OrViHPCXLRgtchr2t4aIstMWDKxzok7GXFnj6/SshtrKq/8AWS23iiuO+V37jUTbFlhleGWE
iSNijgISLrs2G1SvKkU4Zzccf8HV6pjqNpCnZkJ4CvF5akasGUMpupFwe8a0UamVQIbMDizs
yqsqEyC7Fc1SJvhN7h9FX0jPw29w+iuiUqw61/o/5fwUfx/u8FAUjPwz7h9FXkjPwz7p9FTi
lROrf6fFd9Hn4KGoh+4fdPoq8iH7h90+ipZSonUP9Piu+lzUaRT90+6avIp+6fIa39KibuXi
penzWmRT90+SryDveatnSomx9y7l5rCQd6r6VepUTJdZeGkjjA43VL7uIgfTXntOP8VPeFQL
mvMTK1mVCwKYoEKg22H2n85rT/s/h81bIaHNCMjMgyDs3FUS1DSIEXbmuq9px/ip7wp2nH+K
nvCuVfs/h81P2fw+apf+eOs/0/xXPyT0+K6r2nH+KnvCnacf4qe8K5V+z+HzU/Z/D5qf+eOs
/wBP8U/JPT4rqvacf4qe8KuKysAykEHcRtFcm/Z/D5qm/JWZ12nSYpYE4sllsb2RxxAeW9VX
6T04ZxLMxxwZTruzyykMpHSlKyK5KUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKU
pREpSlEStZrpPVYajarZuMH8HWA/SBWzrX67G76VO0QvLBw5CAby0DLNbx8NqItfkgHJxwfj
5rW/EI3C/wANaLGdOyYbQZPFPxN+zHwvwIqAmVlHtMpNkv0kA7K3uaxEX+QhUvFjyx6hEwB9
eGReGYDvhbmrOrS6JkTw42BwnV4iJcY44RSjbHtIzlU4W2XUm/SBRFrMrFWPClfE6+LJICbJ
mnLzF1tGTKD6zSKPXQAX3GrogzYc7HjgjWXrV+1I0aMYAydWird4+Aybj3ySSaudfkxwYw1D
EEuXExnzVgt1oSMtJfhdgxCFrKVJvf1e5WbkZWmx5Wm6p13/AK0qSlsiTZuEfCG2bGFiLHuU
Ra/Iw9VWZxNjQCXJaRoU6xiUeYIjNYLt2LY+GkYlhzcXFyhHFkY8mHFHGjcTPFxvtctbiKle
ju1madq2KMzJzdQusztbHsjHgitbh2X2i209/ZVBn43aNU1GILOQkMeK4FyZnMqqin71yLgb
R00Re8UL/hlB2A4uan6Fc2rA5imePTdGKysjND63C5W46uPfYithlY8mHpr4igiTqI9PhJ3S
TZJ/cZd17Xv5a3vYsUxxxvEkixKFTjUNYAW2X8FWUzELBMh2fBRnHNExBZ1zhMqb5h/7jf1V
fTJl+O/9xv6qn/YMH5aL3F9FV7DhfLxe4vorUdZA/Qe9UiiXUoMmRL8d/wC43pq+k8nxm98+
mpl2PD+BH7i+iq9kxfgx+4voqB1UT9C6KT1KJpPJ8VvfPpq+kz/Eb3j6ak3Zcb4Ke6PRTs+P
8JPdFROoifpUvSPFR9JX+I3vH01fSRvvn3jW66iD4a+6Kr1MX3F8gqBtHBdyHitWjt94+U1f
Rj94+Ws3q4/uL5BVeBPujyVEzB3KWXmrCE92ryV64V7gpUCV1lZbDw2Ys0EbMxuWKKST39lU
7DhfLxe4voqEcxnMxNZnQTyrHLaWMB2AswsbAHoYGtZ2zM+Zl/uP/VW2GklKMZCzCQB2KiV4
BIMdhXSuw4Xy8XuL6Kdhwvl4vcX0VzXtmZ8zL/cf+qnbMz5mX+4/9Vd/Cn/k8Fz8iPQuldhw
vl4vcX0U7DhfLxe4vormvbMz5mX+4/8AVTtmZ8zL/cf+qn4U/wDJ4J+RHoXSuw4Xy8XuL6Ku
RY8EN+pjSPi38Chb28Fcx7ZmfMy/3H/qqX8mJkNhz5U0jyCWThj42LerGLG3Ee6aru00q4GR
m+5lOu0SkwiykdKUrIrkpSlESlKURKUpREpSlESlKURKUpREpSlESlKURKUpREpSlESlKURK
pVaURRmaLIwsiPTDJ1eFEXyMQFiiugswiYrdmEJv+2PaW3QCK1zpiNo0uEccDEkyFlBA9aGX
ruFxMo4uFW4SVPQvqta1zL83CgzoDBODYEPG6nheN12q6N0MtRrNwsvBRxL+3wo642fCtoUe
W5kmlRFZklf2S+1LXtw3tRFsexCTFRcWdex5KAFWa7wr7R6iTaSpItwnd0HorQ6jp8KS5OZ1
sYwcyeJE4VedhJJ/zCOJXCleK53E3vsq9Di4s2RHIuHEjZcxQyY4UwKvC3VcYKyoWdlvsAsp
F9teRHEmPj5RgjZcmKWWJI8fHuBGUG8RX3PxbBewoi8wSPEwdo5smHbxSzNLB1RS3DdiUjcO
N3TfZYirsONDHkIkAnxp0gefDSRnnRJD7WTJHK5C8TXUBQSL3axIFXhHp2l5sc0sUMkM0fDJ
lBj1ysSwVoQSLiwsRGvECbi9X8LRp8sIshmh0+Ni0TTse1OCOBlT7UKuPa+0dtgt6Iq4eTNN
xatqcofDwAxQqvCj5AHVuyLxNfg2pcGzMSR0VoX1vVppXl7VLGJGLCNWsqA7lHgqb5Wk4GXj
xYs0V8eG3VxKSiDhFl2IRuG6sUcr6GN2N/G/9VaaLaawc8TKR5AgBVWQnIjKQAOaiq6rqh//
AHJveq6up6n83L71SYctaKN2P/G/9Vehy7o4/wCj+N/6qtOpo6D/AEhQ9Kzq8So4upaj81L7
1Xl1DP8AmZPerfjQNKG6D+Jv6qqND0wbof4m9NRN9PT/AMQu+nPj4rSLnZ3zEnlq8uZmfHfy
1txo2nDdF/E3pr0NJwBui/ib01A3V9PgFLJPj4rVrl5Xxn8tXVycj4reWtgNNwhuj859Nehg
Yg3J5z6aibIcPBdyy4rDWef4jeWrqyy/fPlrJGHjjcnnNehjQjcvnNQM48FLKVZV3+8auqzd
2vQhjG4V6CKNwqJIXWWPlabgZrK+XjpMyAhS4uQD0VY/1/RPkofdFbCtVrONrbDr9JyuBgPW
xmVCGt0ozDYfDsqUJSJERZkHMkBckAz5c3sxV3/X9E+Sh90U/wBf0T5KH3RUPm5h5igkMU+Q
0Uo3o8SKfOtef9m175v+BP6a1fi6j/KP6pKn1qujwCmX+v6J8lD7op/r+ifJQ+6Khh5m10b8
v+BP6ay9P1LmzUnC4kxZL2aZo0ES+FuHb4BQ6e+Ic2gAbzKSC2slhAn2BSj/AF/RPkofdFZs
EEONEsECCOJBZUUWAq3hQZEGOqZM5yZt7ykBbk9Cqu4VkVjlKRwMjMDmW8VeABiAyUpSorqU
pSiJSlKIlKVjT6hgY0giyMiKGQjiCO6qbd2xNdAJwAfsQkDasmlYq6pprCMrlQkSsUjIdfXY
EAhdu07auHLxRkDFMydoI4hDxDjt3eHfTLLge5cccVepVKrXF1KUpREqlVrxNIIYXlb2Y1LH
wKL0Re6Vy/8AyOoP6/aphxEtbrG6dvdqWcmHIlxsnInleUNII06xi1uBbm3Ee61ardIa4GZk
C25lTC4SllAUkpStfr2S2Lo+XMhKuIyqEGxDP6ot5azRiZSER9RA71aSwJ4YrYUrl4z88bO1
z/3X9NTjlfrf8LFNPI0jSl5OKRixAJsNrd4Vou0pqjmMgXLMyrruEyzNg63FUrmmRqedLkTS
rkzKskjsqiRgApY2AF+5XmPVNQhlSYZMzGJg/C0jENwm9iCemrPwJN847lD8kcCunUq3BMk8
Mc8Zukqh1PeYXFeyQASdgG81ibctCrVK5nNqefLPLKMmZRI7sFEjAAFjYAA9ypVyYciXDyMi
eV5eOXgTrGLWCKL24u+a1W6U1wzmQOzBlTC4SllAW0m0TS5pDK2OqSm95IiYnN992iKmvA0H
BBHrZBA3DtE1h4LPsqH63qWY+r5fVZEqRpJ1aqjsq+oAu4Hu1m8oy5mTqrGXIlkjhiZiruzK
SxCjYT4aS0hjX6hkPlzM3ggvBnlA3spVi6Xp2G3HjY6RyHfJa77fxtdvPWXWk5tzXxdJKxOU
lndY1ZSQwHtNYjvLUK7fn/Nz/wB1/TXKdLKyGbMI4tsXbLhAszrp9VqAcv5+YdaxFlyJXR2Z
SrOzKbq3QTU/qu+k1SESczh1KuwTBLMxZKpXieaPHhknlPDHEpdz3Aoua5xlavqGVky5HaJY
xKxZY1dlVV+yoAPQKlRp5WuxyiO9cstEGwd10ulcvOoZ4BPap9n/AMr+muhaKsi6TiCVmeQx
KzMxJYlhxbSfDXb9MaogmQk5bYuV25yQzMs6lKsZmVFh4suVMbRwqWbxdHjqgAksN6tV6q1z
KXVNRmleZsmVWkYsUWRgq3PsgA9FW2z9Q4TbLnvY/wDa/praNBLrHcs/5I6Suo1SsfTpTNp+
NMTcyRIxJ27SovUA1DU8yXUMqSPJlWNpX4FWRgAqnhFgD3qop05slKL5cisnaIAFnzLpFK5f
2/P+bn/uv6advz/m5/7r+mr/AMCXWO5V/kjpK6hSuX9vz/m5/wC6/podQzwCe1T7Nv8Ayv6a
fgS6x3J+SOkrpWRiY2UnV5MSTJ3HUN9Na1+VdCc37Nwfld1Hk4q12rz5OFythx9c4yJuqVpO
I8e0dY3rb6i7ahqAUntU+wfFf01ynT2GJMLTAZjHB8W3pZZAECUM2DqfQct6JAwZMRGYbi93
/nJrZKqqoVQFUbABsArG0yN4tOxkkYvIIk42YksWIubk9+veXmY2FA2RlSCOJd7HpPcA6TWW
RnKTGUpl2G9XARAcARV6lQvUeccyYlNPQY0XRI4DSnxeyvnrRz5ubkm+RkSyk/edreQG1aIa
Gwh5EQ5bSqpaiI2DMun8a3tcX8NVrlNvD5TWz0KfUn1LGxsbJlRXcGReIsvAvrP6rXG4VKeh
yxJFgwD4hlyOocgZdvNdDqtUpWJaEqtQzmzWJjnLhYsrRpji8rRsVJkb7JKn7I+mtF2/P+bn
/uv6a116KU4CRkI5sWZUSvEZEM7LqFR/nGGD/FNO0adaJIlEhA4gpcbOLfasTkvMnmly4Z5X
lsEdeNi1vaU24qlLxpIvDIodd9mFxs8NVEGi4P5shBwwfepgiyHDMopzDhQvnRY2OixGHDny
YUQBQJVZWBsO7w1bwpev1nTtXf1W1GWfgB3iJI1jjHmNS8xxl+MqC4HCGsL27l6p1UXqngW6
exsHq+DuVIahoCJD+WUXfqd/ghqxd94PcvVVpSs6sSlKURK1fMk/UaJlsDZnTq18Mh4PrraV
G+d5+HT4Mcb5pgT4IwW+m1W0RzWwH3DwxULC0JHkoZYDZ0VP+VYOp0PHO4y8Up/Wxt5q5+wJ
BA3nYPCdldRw4Bj4kEAFuqjVLflAFbdfJoRj1Sfu/mqNMPMTwHvV+o7zrPwaZHCN80yjxIC5
+gVIqhvO8/FmYuOD/wAcbSEd9zwj+Wsmli90eXm7ldcWrPPBRlr8Jtvtsrok5Gm8usNxx8Xh
H5uDhHnqB4EHac/Fx7XEkyA+C9z5hUz5xn6rRjGDtnkSO3evxn+Wtmq81lNfGTlUU4RnLkoI
BwqAegV6ZWRijgqy7Cp3iqBS5CDe5Cj9R4frrbcz4nZdYkAFkmRJF79hwN51rSZATEeoE9zK
kDyk8CB3qRcnZnX6Wcdjd8Rin6G9ZPR4q2WsZHZtKy5ulYnt4SLDzmofylmdm1dYmNo8pTGf
zr6yfWK3/OM/VaOYwbGeREt3QDxn+WvOtqbVAbpyEu/atUJ/ok9II/coKo4VAPQK6By5GuJo
EEjC10ad/wBRL/RUAILeqN7eqPCdldB1huwcuzopsY4BCtu6QI9nlrRrMRXX1z/b3qujDNLp
iuftIZXaVt8jM5/UeL66lnI8FosvJI9p1jU/kHEf5qiQFtg6Kn3KcHU6JC3TMWlP6m2eYVLW
SakjqIHxXKA9j8A603O2Tx5mNiA7IkMjeFzwjzLUdSJnimlHswhC3624BWZruT2rWMuW91D9
Wp70Y4PpvV/Exz/rWo5NvamiUHvRlSfO9Sr/AE6axxyj2yOKjLzTke3wWLo78Gr4Lbv30Hve
r9ddKrluM/V5UEn3JY28jiuoSyxwxPNIeGONSzsegKLms2vHmgeIIV2mOEu1RrnTUuCGPTYz
6037k1vhqfVX9TfRUUjhZ4pptyQhbnutIeFV+k17z8187LmzZdnWtcA/ZQbFXxCs/PxTg6Hh
QuLTZkpyZR0gKvDGviDeWtNcfShCH1SOPbtkqpnPKUtwH8lqCOIcI+16vl2V1SGMRQxxDcih
R4hauaafF12o4kPQ80YPg4gT9FdPrPrzjAdpVmmHzHsVKifOmpXMemRndaWe38C/X5Kk+Vkx
YmNLkzG0cSl2PeArmeTky5eTLlTf8kzF2HcvuXxDZVeiqzTznZDZ2qWom0co2y9yyNJwe3ZT
RsCYoopJZLdxVPCPG1qwVN1BPSBeprynpvVaXJkSC0maDbuiICyeXfUKAsOHubPJsrdXZnss
A2Qyj3uqJQyxiepyuhctP1ug4m2xCFCRvHCStYn+k6V8XI98f0165Mk4tHK/DmkXy2b6639e
bZOddtghIxeZ2LVGMZQjmD+VQvmDl7TtKwO0QvK0rSLGgdgV9badgUdAqNk2BPc21LOeJ9mH
jDuvKw8A4R9NRaKIzSxwjfK6oP1ELXoaaUjUJTJJLlzwWW0ATIiGZSzB5P0+fCgmneYTSxq7
hWAALC+wcNX/APSdJP8A2T++P6akCqEUIuwKAB4BXqvOOpuckTkFqFUG+UKH87SgSYWIuxUV
pLeRF+uo7iwnIy4Mcb5ZUTxFhfzVsua5+u1uUA3EKJGPDbjPnavPLEHX65j3FxEHlP6RYedq
9Cr9PTA8IGXfis0/NaR9zKfTzRY0DzzMEiiUs7HoArnWr6tPquUZ5LrEtxBD0IvdP4j0nxVI
udc4pjw4CGxnPWS/kTcPG30VDybC++q9FSBH1CMZfLyCnqJl8g2DasjBwMrUMgY2KnFIdrMd
iov3mPcqW4fJmnxKDmO+TJ0gExx+JV2+es7l/S103TkRh/7EoEk7dPER7PgXdW0qi/VzMjGs
5YjBxtKnXTEAGQclag8q6CRbsgHfDOD/ADVXTuXMHTcxsvGLkshQI54gtzclTv6K21Ko9awg
gzkQdrl1bkg75RhySsTU86PTsGbLfb1a+ov3nOxV8ZrKqGc5al12Umnxm8ePZ5bdMjD1R+lf
prtFXqWCO7bLsXLJ5Yk9yjskjuzyynjkcl3PSzMbmszVMHsE0EBBEjY8ckt/iMW4vJuq9y7p
/b9ViRheGD96XuWU+qvjas7nVLapA/Q8Fvdc+mvTNg9aNY6ST8FkEf0zM8QF45Mk4dXkTokg
PlVlP11Oa57yxJ1eu4xO5+NPeU+iuhVi1wa0HjELRpz5OwpSlKyK5KUpREpSlESoVztPx6hj
44OyKIuR33a30LU1rn/NTE67kX+yI1Hg4A3/AJVq0Qe5+mJPwVOoPk7SsHTIO0aniQEXDzJx
D8KniP0V02oByqobXce/QshHh4bfXXQKlrz+pEcIv3lc0w8pPNUrnvM0/X65kkG4i4Yh+kXP
nNT+aaOCF5pTwxxqXc9wKLmuXzzNkTy5De1M7SH9RvXdBHzSlwDd65qTgBxLra8qQddrcTEX
EKPIfDbgH81bHnie74eMDu45WHkRfrr1yPin/wBrNI2ErCh/L67fSK1vNk/Xa3Iu8QRpGPCf
XP8ANV3z6z/rh+3vUPlo/wBclhaPD1+rYcW8GZWPgT1/qqR874nFj4+ao2xP1Tn8Mm7yMK1n
J8HW6z1nRBEzeNyEH11MNUwxnafkYh3yoQp7jDap8tQ1FuXU1ndAY/7tvgpVQeqX3fBc1imb
HljyE2PC6yL4VN6k3OmUk0Wnqh9WQNNbvFQFP8VRfbuYWI2MO+NhFZmdk9oxtOUm7QY7Rt3i
rkD+ECtM4PZXPpzDvCpjJoSjxZNIg7RquHFa4Mqsw7yeufoqUc6z8GmxQDfNMPIgLH6q0/J8
HW6z1nRBEzeNyEH11kc7z8WbjY4OyONnI77nh/8AGqbPNqq49EcysjhTI9RZRpr8Jtv6PDXS
gV0zRgTsGJjjyonprn2nQdp1DFg3iSZA35QeI+YVMucMnqdHMQPrZLrHb8I9dvMtc1Qz2VV8
ZOexKfLGcuAUFuSOJt59Zj3ztNS0Ypi5HdbWaSPr2/U4f6KiaRtNIkK+1Kyovhc8P110bU8d
RomTjoPVTHdVHeVNn0VLVTY1D/6CXcuUxcTP2t3rnBPD6w+yQfIb1MucNS4MCLCQ2fLs0lui
Jdp8psKhe1o9m8j6qztWze25rTBrxIiRxE/cRdp8bXNW2V5rKydkMx9uDKEZtGQ6mC96Hpx1
LU4oCLwp+7P+RTu/UdlbHnSUNqkMI3RQ3I77sfqWt1ynppw9O7RItp8u0hvvVPsL5NvjqMcy
TddrmUehCsY/Qo9NUwn6mpLfLVEgduwqyUctI4zIVeWohLrmKDuTjk91Tbzmuh1B+S4+LVZZ
OiOA+V2HoqZ5E8WNBJkTHhjiUu57wF6z60vcAN0QO9W6fCD81GedNSssWmRna1pZ7fdB9RfG
dviqN6fhnPzYcQGyyN+427hjG1z5K85eVJm5UuXL7czFrfdH2V8Q2Vjlk3EjwXrdVVkqEBhJ
sT9xWac808x2fBdUR8eNFjRlCKAqqCNgGwCuY5KdXlTx7+CWRb+BjVi8XdHlr2LW2buio0af
0jI5s2bkylZbnbBmUu5GkJgzIuhZFYfqW3/jUpqGckSWzsqLoaJWt+VrfXUzrBqw18ubHwWi
gvWPaoHzfP1utMnRBEieNrufprG5dg6/W8RehGMp/QCfprH1SftGp5c17hpnCn8KngH0VuOS
oOPUZ5yNkUQUHvu3oWt0v09N2Vt7Ss481vbJTSlVrG1KcY2n5ORe3VxOwPfANq8oByAN+C2k
sHXOM6ftGdk5HxZXYeC9h5hW+5Ig4svKyehEWMeFzxH+Woyt+EX3221N+SoODS5JiNs8zG/4
UAQfQa9XVHLQQN7RCxUh7Ae0rR83yF9bZSdkUSKPHxN9da3T4hNqOJC21ZJ41Yd7iBrZc3Rl
NbdjulijYeK6fVWpxp+zZUGTv6iRJCO8pufNUqv7EW/x4drLk/7hfqXU6V5jdJEWRDxI4DKw
3EHaDXqvHW5KUqlEWNqObHgYU2XJuiUkL95tyr4zXNJJZJZHmmN5JGLyN+Jjc1I+c9S63Ij0
6M+pDaSa3S5HqL4htqMkgbSbeGvU0dWWvMds8fZuWO+byYbI+9TnlPDjwtO6+VlWfLIkYEi4
T7C+Tb4613O4RpcOVSGuJENjf7rVFbxHpHlqqlPskeKpR05F3qmbnHBuOC4bXhkyt7VmaVJ1
Wq4UnQJ0B8DHh+uum1ylHMbpINhRlYH8pBrqqkMAw3EXFZ9eMYHkR3K3THCQ7FWlKVhWhKUp
REpSlESoLzhjPDqwnt6mTGpB/FH6rDyWqdVharpWPquKcea6kHiilHtI/dH1irtPaK7BI7Dg
VXbDPFht2hc7w8ubCyosuD/kia4B3MNxU94iplDzlpDxhpRJDJb1kKFrHvMtwajWby7rGG5B
gM6DdLAOMEd9faFYHZcq/D2eXi3W6t7/AEV6M66bmkS7b4lZoysrcN3hbrX+ZTqUfZMVWixC
byM2x5LdFhuX6a0cccksixRKXlkIVEG9mO4VnYug6xlMBHiugP25v21HvbfNUt0LlyDS/wB+
VhPmEW6y1lQHeEH11GVtNEMsGJ3RBfHmuiE7JPLv/cs7ScBdO0+HEG1kF5GH2nbax8tc81Cf
tOoZU/RJM5XwA8I8wrpOU8iY0zxKXkVGKKu8sBsArnS6JrVhfBmv0+qN/lqnRyGayc5AGTbS
3Mqd4LRjEFgpByPB6mZkkb2WJT+UcR/mqV1qOV8KXC0hEnQxyyO8jowsVLGwv4hW3rNqJZrp
kY4t3YK6oNCI5LnnMmF2PWJ1AtHP++n6/a/iBrV1NubtLnzMeCfFiMs8LcJRRdij7/IQKi3+
F1n5Gb3R6a9DT3RlVHNIAgMXPBZbayJlgW2qQcjwft5mSR7TLEp/KOI/zVpeZZ+v1vJI3RlY
h+gbfOalvLGHLhaQiToY5nZ5HRh6wJOy/iFRDI0rWp8mac4M15ZHf2R9pie7VVUonUWzMhh5
Q5/bgpzBFUIgHiVkcpQddrcbEXEEbyHwmyD+asvnbJ483HxQdkUZkb8znhHmWsvk/TMvFlyp
8uF4GYJHGHFiRtZreatVrWn6vmarlZC4czRl+GNguwog4QRt6d9dEoy1RkZRauDAvvP81xiK
WYvKSsctY3adbxgfZi4pm/QNn8RFT/IXjx5U+8jDyio3yhpeXiz5OTlwtAxVY4w4sSL8TEea
pRWfV2CVuBcQAGHeraItDHeuUKLKB3BathoenHUtSixyLwp+5P8AkU+z+o7KyX5U1zjfhgQr
xNwnrF3Em1SblnR5NMxHOQAMudryAHi4VXYi389a79TCNZMJRMjgGPHeqa6pGQzAgDa63AAA
sNgFcvzZevzcmbf1k0jDwcRtXTchnWCVowWcIxVRvJA2AVzhdF1qwvgzX6fVG/y1RoTEZySB
sGJVmoBOUAE7Vv8AkaLZmzW6Y4wfACx+mvXOmpcMcemRn1pLSz2+4D6q+NtvirM5VxMjB0uU
5MTxyvK7mMj17AADZ37VGs3A13Oy5suXBm4pm4gLeyu5V39AqURGeqnOUo5YMznadi4XjTGI
BeS1sccksiQxDillYIg7rMbCuj4ekYOLiRY/UxuY1Cl2QEsekkkdJqOcr6HlpqBy86BoVx1/
aEgtxSNsuPyipjUNZc8hCJwjiW4lSorYGRG3isfsOD8vF7i+ioBr0Sw6zlxqoVeMFVAsAGVT
sro9QnmTStRn1mabHxZJYnWOzoLi4Wx6e9UdFNrDmlhk3nml8XiGG/crHKMnBraL8SKRfJZv
qqb5cwx8Wac/9UbP7oJqE6HpurYur4s0mJLHGrEO5XYFZSpvtqU8xLkSaPkRYsbSzSgIFQXN
mIDeau6oRlfBiCJCIJfmlLiuWBwdc6UkgE7ztPhO2pnyRDw4GROf+2aw8EYA+kmo1/hdY+Rm
90empxy9iPh6PjQyoUl4S0ineGcljfy1frLI+k0SDmkNhVdETncghgtlWk5un6rRJVG+Z0i8
pufMK3dRvnDHzsuPFgxIJJ1VmkkKC4FhwrfymsOnAN0HIABfHlitFr5JNwZQwmwJ7m2uj6DA
cfRsOI7+qVj4X9c/TUGXQtYdlQ4UqhiFLECwBNiTtro6IqIqLsVQAPAK1a6wGMIgg4kli+xU
6eJBkSG3KPc46Y+RipnQrxSYt+sA3mJt5/SdvlqF98V1bfsNRbV+TxI7ZGlssZYktjPsS/4G
Hs+Dd4K5pdTGMfTmWb5T8F26ok5o+0LWaLzNkaZGMaZDkYg9gA2ePvLfYR3q3685aMRcmVT3
DGb+a9RGfSNVxyRLhzC32lXjXyperK4uWxsuPKx7gjf0VfPT0WHNx2mJVUbbIhveFLpedcDi
VMeCWQsyrxPaNRxG19pJ81bvPzI8HDmy5fZiUtbun7K+M1AINB1nJIEeHIvSGl/bXZ+bbUg5
rTVcsQYWNjSSxKBLM6C6l9yqDs3b/JWeyinPXGEg2OfzbgrY2TyyMgftwUTllknleeY3llYu
5/E22pPydpUckc2fkRh1c9VCrgEWX22se6dnirRroWsu6oMOVOMheNgAFubcR27hXQsPFjw8
WLFi/wCOFQg79unx1bq7gKxCBHm6TsAUaIEyzSGzjxVOw4Py8XuL6K0HOWJjxabDJDEkZE6g
lFC7GVt9qk9afmnFny9JaPHjaWUSIwRdpIB21jomRbAk4Zt5V9kXhJhuXP32qfAa6VDmcGjR
5vCX4ccS8I3mycVqgf8AhNZ+Rm90empjgy52Dy7jnsbzZUSBDjbFewbh6fw7a16zLIQYxl52
bMN6oocGTgjy8Fi6Ln6xqITUHzMYYl2M+KiXeNQDYcW+9ZcXNWiyvEizMOuPCCUYKpJsAxtY
XrRPDPDPm6xFhPpmImNIrxuQOslkHCtkG4XN6pi4OZm6fp+mJhyQY0DDIyslwB1n2v2rXJLA
7KhKqokyLCOzy5RlwJL8SMFMTmMBieb4rccxaxmYjLi6cV7SI3yZmYcQSGMdzvmtrp2QcrAx
slvamiR26NrKCajiaPqWoJqGp5DTYmRkcax4oC3eJR6kb3B396t1y9HPFouLFkxtFMiFWRth
FmIHmqq2MI1ARMTKMmk23EYqUDIzLuxGC2VKUrMrUpSlEVKrSlEVKrSlEVKrSlEVKrSlESlK
URUqtKURUqtKURKUpREpSlESlKURUqtKURKUpREqlKURVpSlESlKURKUpRFSlKURVpSlESlK
URUqtKURKUpREpSlESlKURaTnD/+Bkb96bvzDf3q2uH/APiQbv8AjTdu9kUpVx/sR/7Je4KA
/uH/AEj4q9SlKpU0pSlEX//Z
--------------1553ED15CC70BAB9B8EB79B2--
Attachments:
UnimaticaSPA.jpg (image/jpeg, 11.3K) download
view image
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-16 19:21 LEROY TENNISON <leroy_tennison@prodigy.net>
parent: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: LEROY TENNISON @ 2021-06-16 19:21 UTC (permalink / raw)
To: pgsql-admin
Keep in mind that this can be accomplished in other ways depending on what archive_command you're using. rsync, and sftp (I don't recommend scp due to security concerns but it does compression as well) both have parameters to do in-transit compression. If i remember correctly Postgresql compression must be enabled on both ends. I had a situation where that wasn't easy to do and opted for external (to Postgresql) compression.
On Wednesday, June 16, 2021, 2:56:09 PM UTC, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:
sorry, the link was broken.
this was the param.
"wal_compression (boolean)
When this parameter is on, the PostgreSQL server compresses a full
page image written to WAL when full_page_writes is on or during a base
backup. A compressed page image will be decompressed during WAL
replay. The default value is off. Only superusers can change this
setting.
Turning this parameter on can reduce the WAL volume without increasing
the risk of unrecoverable data corruption, but at the cost of some
extra CPU spent on the compression during WAL logging and on the
decompression during WAL replay."
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-17 16:30 Stephen Frost <sfrost@snowman.net>
parent: LEROY TENNISON <leroy_tennison@prodigy.net>
0 siblings, 0 replies; 7+ messages in thread
From: Stephen Frost @ 2021-06-17 16:30 UTC (permalink / raw)
To: LEROY TENNISON <leroy_tennison@prodigy.net>; +Cc: pgsql-admin
Greetings,
We generally prefer to do in-line replies (not top-posting) on these
lists. So, more below.
* LEROY TENNISON (leroy_tennison@prodigy.net) wrote:
> Keep in mind that this can be accomplished in other ways depending on what archive_command you're using. rsync, and sftp (I don't recommend scp due to security concerns but it does compression as well) both have parameters to do in-transit compression. If i remember correctly Postgresql compression must be enabled on both ends. I had a situation where that wasn't easy to do and opted for external (to Postgresql) compression.
In general, rsync, sftp, and scp are very poor choices for archive
command as they don't do anything to ensure that the WAL is actually
written out to disk and also don't do a variety of other sensible checks
to make sure the WAL matches the PG database, there's a history file for
the timeline the WAL is on, etc.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: compression in replication
@ 2021-06-28 10:36 Andrey Borodin <x4mmm@yandex-team.ru>
parent: Massimo Ortensi <mortensi@unimaticaspa.it>
1 sibling, 0 replies; 7+ messages in thread
From: Andrey Borodin @ 2021-06-28 10:36 UTC (permalink / raw)
To: Massimo Ortensi <mortensi@unimaticaspa.it>; +Cc: pgsql-admin
Hi Massimo!
> 16 июня 2021 г., в 13:11, Massimo Ortensi <mortensi@unimaticaspa.it> написал(а):
>
> is there any way to compress the traffic for streaming replication ?
libpq compression is being discussed here [0]. When the patch will be committed subsequent PostgreSQL version will be able to benefit from protocol copmression. Replication traffic also will be compressed. If you wish, you can join efforts as the reviewer of that patch.
As for now, you can use compressed archive recovery - many solutions like WAL-G, pgBackRest, pg_probackup support compressing WALs with decent compression algorithms. They also support parallel upload\download of WAL segments, while replication is TCP-based (serial). Keep in mind that archiving sends only at minimum one segment (16Mb by default) at a time. Also, you will not be able to use features like synchronous commit.
Thanks!
Best regards, Andrey Borodin.
[0] https://www.postgresql.org/message-id/flat/aad16e41-b3f9-e89d-fa57-fb4c694bec25%40postgrespro.ru
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2021-06-28 10:36 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-16 08:11 compression in replication Massimo Ortensi <mortensi@unimaticaspa.it>
2021-06-16 14:54 ` Vijaykumar Jain <vijaykumarjain.github@gmail.com>
2021-06-16 14:55 ` Vijaykumar Jain <vijaykumarjain.github@gmail.com>
2021-06-16 19:21 ` LEROY TENNISON <leroy_tennison@prodigy.net>
2021-06-17 16:30 ` Stephen Frost <sfrost@snowman.net>
2021-06-16 15:00 ` Massimo Ortensi <mortensi@unimaticaspa.it>
2021-06-28 10:36 ` Andrey Borodin <x4mmm@yandex-team.ru>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox