Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bsHXJ-00026R-O3 for pgsql-admin@arkaria.postgresql.org; Thu, 06 Oct 2016 22:53:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bsHXJ-0008U4-An for pgsql-admin@arkaria.postgresql.org; Thu, 06 Oct 2016 22:53:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bsHXH-0008Ty-Vl for pgsql-admin@postgresql.org; Thu, 06 Oct 2016 22:53:08 +0000 Received: from mail-qt0-x229.google.com ([2607:f8b0:400d:c0d::229]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bsHXF-000804-6X for pgsql-admin@postgresql.org; Thu, 06 Oct 2016 22:53:06 +0000 Received: by mail-qt0-x229.google.com with SMTP id f6so14489921qtd.2 for ; Thu, 06 Oct 2016 15:53:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:to:references:in-reply-to:subject:date:message-id:mime-version :thread-index:content-language; bh=FVHWHcQ4asvPJwXGd+o/lRLsSD9DiwpDY9gPl/okjDM=; b=S8z19SxfiQNOBKOgAviijcOU/Sxq6h/7QZC7sV74CSOncdtWt1JsfpEWn+rLqyjfdb YnbB6jw5ZlBK+BuiXcpUxkOS747loXuerxws2237R0kgrACZngXvqrgH8w6XWhRiGukO jR+FdGWbWsJsqcnwSRzR2AdVEYFD6lWY7OneRxWAxVpqt3oCXcz5YQwTJEWYPKTL8Xon S2KFATxOxN+6SKynQ36cuagyXtxhxZpxlyoJpHq92htZIO8b2vwi9Dn6ONUwMmrt2EUP ST4yAhfNemaV8m/hUZWdSn0UdEk8z6CDE/2LLSFyPMvSDdNy7ZahOO1Vt8NQloxqpUzV fJtw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:to:references:in-reply-to:subject:date :message-id:mime-version:thread-index:content-language; bh=FVHWHcQ4asvPJwXGd+o/lRLsSD9DiwpDY9gPl/okjDM=; b=e9Rz59jtBh/lY+FZnFFycUnJctRISVDP4wNdCuhyCYquDvN7VsFPE9rS5qnus9NF/E LcVlsqhMLKUyZKD2kfCUScsPXHFfNgCpR/vkmZI+rpgkZmIsRYUsH31CwzDyhaU+K7iV YIutXj/3oN3yxmtdLBnN0SCjGjfVpGUtt8SAJyWq8m7pwsnuWBv1H97jgmCGtcvgZomW SXKvtJ6ssUbgMi82Us78QsBqRuoz7ksDPl5HNjlfov1xBkImEjUjTO17dPLZR1i/6gjm ikgh5VWCxDvkH5I+lYMDsweFsaZXyNG9J6QHqDlcsSnMabwiCZAuqPoPe4SFEMav3rN1 OuQw== X-Gm-Message-State: AA6/9Rn0tAOCpOLrdYOqaerNA3XPqlEbIsp77jAJI3AxnhjX47/v2B/d5NWv5nZqACtKPg== X-Received: by 10.200.45.246 with SMTP id q51mr16883553qta.108.1475794383856; Thu, 06 Oct 2016 15:53:03 -0700 (PDT) Received: from lazaro ([200.55.161.75]) by smtp.gmail.com with ESMTPSA id k44sm1632898qtk.3.2016.10.06.15.53.00 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Thu, 06 Oct 2016 15:53:03 -0700 (PDT) From: "Lazaro Garcia" To: References: In-Reply-To: Subject: Pruebas de carga PostgreSQL vs SQLServer Date: Thu, 6 Oct 2016 18:53:00 -0400 Message-ID: <000a01d22024$649e67a0$2ddb36e0$@gmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000B_01D22002.DD8DB200" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdIgFElHLsyKiOnRRAenz0uP3Guo2QAD/iXA Content-Language: es X-Pg-Spam-Score: -1.4 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_000B_01D22002.DD8DB200 Content-Type: multipart/alternative; boundary="----=_NextPart_001_000C_01D22002.DD8EEA80" ------=_NextPart_001_000C_01D22002.DD8EEA80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hola a todos, les escribo porque estoy realizando unas pruebas de carga utilizando HammerDB a una base SQLServer-2014 y otra con PostgreSQL 9.5. Realmente lo que me tiene un poco confundido son los resultados pues por lo general las pruebas de SQLServer o sea la gr=E1fica de TPM que genera Hamme= rDB siempre se van por encima casi al doble de las gr=E1ficas de TPM que se generan para las pruebas a PostgreSQL. En la documentaci=F3n de HammerDB comentan que para comparar diferentes bases de datos TPM no es lo m=E1s aconsejable sino NOPM (Numero de ordenes por minuto), pero este =FAltimo va= lor no s=E9 de d=F3nde es que se saca. Les agradecer=EDa me ayudaran a entender= mejor este proceso y como podr=EDa realizar pruebas para establecer una comparaci= =F3n entre ambos motores. SQLServer fue probado sobre la instalaci=F3n por defecto y PostgreSQL fue tuneado. Adunto se encuentra la configuraci=F3n de PostgreSQL. =20 Es acaso SQLServer m=E1s r=E1pido que postgreSQL?? =20 La imagen amarilla es de SQLServer, la azul de PostgreSQL y hay 50 usuarios conectados a la base. =20 Ambos servers son m=E1quinas virtuales con las mismas prestaciones de hardw= are y software. =20 Saludos a todos. ------=_NextPart_001_000C_01D22002.DD8EEA80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hola a todos, les escribo porque estoy realizando unas pruebas de = carga utilizando HammerDB a una base SQLServer-2014 y otra con PostgreSQL 9= .5. Realmente lo que me tiene un poco confundido son los resultados pues po= r lo general las pruebas de SQLServer o sea la gr=E1fica de TPM que genera = HammerDB siempre se van por encima casi al doble de las gr=E1ficas de TPM q= ue se generan para las pruebas a PostgreSQL. En la documentaci=F3n de Hamme= rDB comentan que para comparar diferentes bases de datos TPM no es lo m=E1s= aconsejable sino NOPM (Numero de ordenes por minuto), pero este =FAltimo v= alor no s=E9 de d=F3nde es que se saca. Les agradecer=EDa me ayudaran a ent= ender mejor este proceso y como podr=EDa realizar pruebas para establecer u= na comparaci=F3n  entre ambos motores.

SQLServer fue probado sobre la instalaci=F3= n por defecto y PostgreSQL fue tuneado. Adunto se encuentra la configuraci= =F3n de PostgreSQL.

 

E= s acaso SQLServer m=E1s r=E1pido que postgreSQL??

 

La imagen amarilla es de SQLServer, la azul de= PostgreSQL y hay 50 usuarios conectados a la base.

 

Ambos servers son m=E1quinas virtuales con = las mismas prestaciones de hardware y software.

 

Saludos a todos.

= ------=_NextPart_001_000C_01D22002.DD8EEA80-- ------=_NextPart_000_000B_01D22002.DD8DB200 Content-Type: image/png; name="ws1_50c.png" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="ws1_50c.png" iVBORw0KGgoAAAANSUhEUgAAAmMAAAEFCAIAAAAg73fwAAAAAXNSR0IArs4c 6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAB8qSURB VHhe7dyhk/y8fcfxHw0NfmhwWKdzsLQ4tPAmNCCooKSdks4zx4pDgzPHgh8a nIPF/Q86s/1a+kgr27JWXku78u37NZ95uqeVvbbO6093f9f+uAAAgG00JQAA JTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0JYAX 9eMWzdumeds0rye90jbN26Z52zTvhbEEAF6OGuAWzc7RjFs0uw+9xi2anaMZ t2j2C2MJALwW3f7raJs5PVdH27SmvdfRNnN6ro62eVU0JYAX4m/6/u5/k99k wY/7CTf5TRa2xres5/uR6QUq+E0W/LifcFOc/7Je+uQBvBR/3zfp4y1+kwU9 12gPNTQ7ma+fGx2DHm1bzH9Nr3vmAF6KbvaBRvfQloFG99CWgUa3aV6QHdlL WwYa3aZ5gUZfzIueNoBXozt9oNE9tGWg0T20ZaDRbZoXZEf20paBRrdpXqDR F/Oipw3g1ehOH2h0D20ZaHQPbRlodJvmBdmRvbRloNFtmhdo9MW86GkDeDW6 0wca3UNbBhrdQ1sGGt2meUF2ZC9tGWh0m+YFGi37fH/7+NLjb+GehQaA09Gd PtDoHtoy0Oge2jLQ6DbNC7Ije2nLQKPbNC/Q6KbPdzeNpgSAk3F37yuN7qEt A43uoS0DjW7TvCA7spe2DDS6TfMCjW77+njzM2lKADgZf/uONLqHtgw0uoe2 DDS6TfOC7Mhe2jLQ6DbNCzS6jaYEgLPyt+9Io3toy0Cje2jLQKPbNC/Ijuyl LQONbtO8QKPbaEoAOCt/+440uoe2DDS6h7YMNLpN84LsyF7aMtDoNs0LNLqN pgSAs/K370ije2jLQKN7aMtAo9s0L8iO7KUtA41u07xAozmxIxdCZeovfVY/ e1vFutxq/irLrer2eY971hoAzkU3z0Cje2jLQKN7aMtAo9s0L8iO7KUtA41u 07xAozl7mnJjbqbabm/1/jmfOdeqLe9ZawA4Hd07c5Wz5jdZ0HMP3IMeJXvT z42OoYZm35pf35Qf2U7zls1Ws5V15daLmzZdWbtYAHB2duP0/63hN1nw437C TX6TBT/uJ9wU56fieA2/ycLW+Jb6+bGyVgW1/MwXPguaWc/NN1xstbWRlzyb bpcM323fegHAqenuWUfbzOm5OtpmTs/V0TZzeq6OtnmIuqbMfM67Ft/syWSr 1UaFgp3ETTOvthtNCeBV2G3T/7dGnL/mJ9zkZ/pNFvyEm/xMv0kUx2vE+an1 SFn9/Jqm3GiubLNdt8p8MkyqsvQsTQkANfw90yx+vMnPX9PTFbTBip6uoA1a nIV+3j6qBc2unl/RlJvFlds2bpX9CrXuWZoSAG7yN8xIo9s0L9DoHtoy0Oge 2jLIjpRpXpAdKdO8QKNFt5uy0FuZKUe6kKYEgGr+hhlpdJvmBRrdQ1sGGt1D WwbZkTLNC7IjZZoXaLSoSVMmtXikC2lKAKjmb5iRRrdpXqDRPbRloNE9tGWQ HSnTvCA7UqZ5gUaLaEoAOCV/w4w0uk3zAo3uoS0Dje6hLYPsSJnmBdmRMs0L NFrU69vXe7qQpgSAav6GGWl0m+YFGt1DWwYa3UNbBtmRMs0LsiNlmhdotOh2 U+b/xXGSm0FTAkB//m4ZaXSb5gUa3UNbBhrdQ1sG2ZEyzQuyI2WaF2j0loqm 3KrKOCHdlKYEgP783TLS6DbNCzS6h7YMNLqHtgyyI2WaF2RHyjQv0OhNm/UU i9BkuvL69GzLI11Yfnaf6vMHgBPyd8tIo9s0L9DoHtoy0Oge2jLIjpRpXpAd KdO8QKM3xcZb9tO1Cp306fhBdDJvUZoSAPrzd8tIo9s0L9DoHtoy0Oge2jLI jpRpXpAdKdO8QKM3LQrx2lOxt96SWlxalRpNCQD9+btlpNFtmhdodA9tGWh0 D20ZZEfKNC/IjpRpXqDR22YfECf6kJj01mqKl2s0mhIA+vN3y0ij2zQv0Oge 2jLQ6B7aMsiOlGlekB0p07xAo1XmTaiiWvRWds4aTQkAD+FvmCZ9vGUxf03P bUvn+E3uoO2TPejn+f63LOZ7+vnAHg5o2VuP12QJAGBo/nbv79U3xflrfsJN fqbf5G7rPcQ914jzU3G8RpzfAk0JAMPzN+pK2mZOz9XRNq1p73W0zZyeq6Nt GqApAeAM/L36Js3O0YxbNLsPvcYtmp2jGbdodhs0JQCchL9dF2jeNs3bpnk9 6ZW2ad42zdumec3QlAAAlNCUAACU0JQAAHxfNCUAACU0JQAAJTQlAAAlNCUA ACU0JQAAJTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0ZS3//7MQAE5Bdy60 wGrWanvlNb+OB98h53sQ53sQ54sjWM1avNOO4HwP4nwP4nxxBKtZi3faEZzv QZzvQZwvjmA1a/FOO4LzPYjzPYjzxRGsZi2uPABnwf2qLVazFlcegLPgftUW q1mLKw/AWXC/aovVrMWVB+AsuF+1xWrW4soDcBbcr9piNWtx5QE4C+5XbbGa tbjyAJwF96u2WM1aXHkAzoL7VVusZi2uPABnwf2qLVazFlcehmIXJNfkLn7F jH4ejA6u0eG12g88VrMWVx7GYVfjvznTnTXQc8ix9fmPwC+Xp6efzY7kj4E/ ME9P73dkW6ydcjW/Pt78ZfTj/dOPfL5rIA6t5zg2Mfk5bDabssGm6RHwVHYp +ppccNfyRPMQ2JqoJFf8inma/XD20irJFX9gnmbX2TsfZSdcTevAt48vPfIl dx2SzBzjizHWov3oJqVTtj34ypuOlGsdK3ZVqBi3+YvH02YvzBZBrXiLXzFP Gz+EvZyKscgfWKSNN9ycgF3Ot5qrVsxUXWbONGZzks+U10m56SuPvPLstf7T md4QXPEI7GJQGVbzl5DRLl6MnbhqcCe/aJ721YftX024kz82T/tKZAdxt/Ot 5tR1H+GrVd9604fDt3QkM0eSpsw/3GR70qPO7IV8TUbuNLjuX51dA2q/u/ir yNMevzs7U/XeMX7RPO26Eduheu8Yf2xe3LN/gCbOt5rWav5LU/9YDff15Ufi J8fMnEnyU/7hJn8VRhptzfaselzxr2s0Fa/Efu9qvBZe4UKyE1TRNeWXzuhl DrCdqOga8QcW6WXQwvlWM2219demfmR7TvLM9Yn1bjIecOXZS6gVi9y7gLfB C7FftyquEXf9fOdLyE5QzdZBk9WznajfOrCdu4NEMydczfVnwXn9LUaShyb9 yR67grRt0ikbel95tn81YR33XuDN8BLsF62Ka8FdNjHfkJ2gOq2DVqtn+1Gt teaO8Hfuv2jmlKs5VZsTPwla6S1G1nOcVW86t3vSXdl61IHtXAW4kzt83hLf mf1+VXEtuKtlkW/FTlCd1kGr1bP9qNY6uFx+ulx+doeKZljNWv2uPNuzeu9e tod+h4cnsl+rKq4Rd50s8n3Y2anTOsgtnc8+th91WgfuIH93ufzZPUAzrGat Tlee7VZ1d4A7Nn6V3439WtVvjYTrZJ2W7FXcCz2avag6rQN3RoXUsv2o0zpw B/nby+UPl8tfnvIr+MZYzVo9rjzbp7ruAHdgMfgm7Neqfmtkfp2s04a9yn85 9sDTE/3Za6nWWnNnUU4V2486rQN3kD+5D5Q/Xy6/PHLlXwGrWav5lWc7VNcd 4I5qEZye/VrVb43krpNFGrBX8TWZssFI8zqwnavWWnOHXZMbbD/qtD4ul19d Lv94ufz+cvlvmrI5VrNW2yvP9qauO2DjPYxzs1+r+q2RjetknUPsVdSN22yO p20asR2q1jpwR1uZEtuPOq0Dd5C/cR8o//Vy+fPl8rfmi/ziWM1aDa8825W6 7gB3PFvpy17avTras4VVvzXiflP1uZO9isqwznQBOdr+ANuJOq0Dd4S7kmf7 Uad14A7yp8vln9wHyp8vl79cLn9vsraIWM1ara4824+67gB3MOX0Yi+d3uw0 ihZsPdVvjbhf0K7cw17FXxJ3mK6hQLvbw7ZSp3XgDumOLNl+1GkduIP8lftD HvtA+Qf31StN2R6rWavVlWf7Ud3dyx1JTdqzl9YdLrARTzNwL1tD9Vsj7pdy R/axV9GlcNh0GTna9S02U53WgTuM+zJj+1Gn9eGO8zfuA+W/uK9e/3S5/JWm bI7VrNXkyrOdqO7u5Q6jMo3ZS+uWlmPPepqNPWzd1G/tuN/FfaniftvNajLl 96yX2WAT1GkduFc/ErH9qND6cMf5k/tDHv+B8mf3j5S/XC7/c3MBsQurWev4 lWd7UN3dyx3DrjRjL63bWJFN87TZA+mFW9Pee7JXUbm144787txm+9evvIPk 4PNsgjqtg2NLF6PjVKd14I7z1/MPlDRlL6xmrYNXnm2uuruXO4A70oC9tO5h dWx+pF30oddwvhJ+5P9a8LvS63VgO1e5teMO+GBKbP/6TXeQO/gZm6BO66DF 0ilGndaBO85fJR8of3+5/Hv4R0qasj1Ws9aRK8+2Vd3dy7363TnEXlr3sP1s W0/7akF7dFSMG/wcNd4xfldGB9GI7VDl1o47yCbJs/3rt9tB8eD16uq0Dtot ne3pMd+7/jZ8oPRfvf7JNeXfaMrmWM1ad195tqHq7l7upY/kfvbSuocdYDuJ tN89tGWgGqymzYasTNuP+q0Rd2CtkmH71y+1g5sHb9RpHTRduilGtdaaO1T/ vWv8QBm/ev0rTdkDq1nrvivPtlLd3cu97vHcw15a97Bj4imk9BobNMlR4x3m 96bGO8bvyuhw72Kbq98accfTNjO2f/1GO6g8eE/l1o7tc/FCTWJUbu24Q/Xf u6YfKP1XrzRlL6xmrTuuPNtEdXcv96KtsoO9rtE97Jj1KaT0eo6GHJVbB3qB Z1embaJ+a8QdQ4+I7V+/0Q72HrynljvMdrXYf6sY9Vsj7lDTmkw/UPqvXn+5 XP5+ufyvm4lmWM1ae688m6+6O8C9aKvUshfVDeyw8vEvqMoexb+oGu8Yvyuj FbzFZqrfGnEv3Sk6YP1GO7j74I267oCeSzfFqOVacEcbv3f9Z5ryYVjNWruu PJusrjvAvWLb3GYvqhvYYZXHn1KJPZB/XTXeYX5vRquZY8+q39pxr9grRr/R Dg4euafS28+2XeywR4yK7hh3tIsPlIuvXmnKXljNWvVXns1U1x3gXq5HSuxF dQM77I7jj1Rij6JX7UMrG9iIyq0d9yp9Y/R7barVkXtqv2q2yWI//WJUd/dy R+trMvuBMv4jJU3ZBatZq/LKs2nqugPca/VLnr2obmCHHTn+SD3Wh17DWRxA w0RxhVVu7bidd4/Rr7ad5kdu1IF1mh9AIUaNdxd3qMZ/77r4QBm/eo1/zkNT tsdq1qq58myOuu4A90Jdk2EvqhvYYU2OP6VyO0b7ChYv1zuR+q0R2+HihfrF 6BfcQqcj99SERTZtsW3vGPXefu5o4/eu6QfK+NWr/0dKmrIXVrPWzSvPJqjr DnCv8oDM2IvqBnZY8+OP1Hh7aEtnsdunJFLRHWP7Wey/d4x+zcf0PnJPlZhj zy42eUyMqm8Pd7Tp967rD5TpP1JO/yciNGVzrGatm1fe9D5wVHr72bb+HfWQ iL2obmCH9Tv+SB24QZOCxU7GSaTS28+2XezzATH6Td9r2sWjjtyoGOcedgDZ GBVgHXe0VpO/3v5ASVM+wilX8/N9uuCc989p4OvjTT9rILAn3j6+4uPFnPVI gc3Sow024R8ct8fdfWmb+PfSAzMds+5hhz3m+D0Vo6MhZzF5/EQqwDo2f7Gf h8Xo973f4w/bU0M69uNizoNj1IEV3NEaX5OLD5T+b3l8U8Z/pKQpeznjaqb1 N5kKT1WXPDSuCTX1ulGYsx4pKl959qyvychGjGrwFpvp30iPjNE97LAHH39q 8dQZE6kJi2zaYvMHx+i3vscTD9sboSZ9jJrwFnfA8XtX/4c86QfK+NVr/EdK /4evNGV7J1zNYq9d6889fH9P2nDxaD1SVL7y7Fk15JyNG/XhBpvg30KPj9Gd 7F7TLsa4AX2DRGrFHHt2sdWDY/S7r/b0Y7aMcAwxRmW4zR3w4nvX9APl+qtX mrKjE67m5/uPtzd9bbpsTHtOQ779Zh1oP0zbJKW4Htlm8/Qox55VN+ZML7LR lzbu3zxPidHN7C7PPfhvnEj1GNjIYuZTYnQFVBjkmEeLUSXmuEUz8XvX9ANl /Fue9KvX9A9facr2zrmaX1++2qzpkq6cKlSdFxry2pTXJ6d6nLZajxRNl3ZC o4GNqBW3+Q3VkI796N82T4zRLW2nEQ7+eycaqiZ9jK6DoqGOeagYteKKWzST fu+6/kCZfvWa/jkPTdnFuVfzWoRT2emhfkrYE9eZxn3yXI/o8Qbbjx6t2FMq wwruiKa+tP/698zTY3RjqzbOwb9CvMXgc2N0KWwb7ZhHi1E3zrl1i9+7xj/k iR8o07/liU0Z/5yHpuzihKuZtJq13fRwKsZ80V3r8PoJMjxcjxQVrjx7SjVY ze1toBjd3iqMdvDkKSlfM1wkNTGqx8CtW1qTWx8os/9ISVP2csrVtGLzfL3F H72089IPjtdpoVXXIwU2S49W7CkVYDW3t4FidIe7ZbQjJ0/M1mXDRVIfo5Is fe+afqDMfvVKU/bFatYqXHn2lAqwmtvbWDG6z20b8LDJE5O9ZrhIdsWsarL+ AyVN+SCsZq3ClWdPqQDruF2NGKO7Xc6wh02emMU1w0VyR0xoymxNrj9Q0pSP xmrW2rrybFwFWM3tasQY3fBWhj1m8vTEy4aL5O64pWtWk/6+5G9QaILVrLV1 5dm4CrCa29WgMf6ulxr5gMnT468ZLpIW4TPloFjNWltXno2rAKsNfk8xviC9 wY+WjBAukkahKQfFatbauvJsXAVY5xT3FENNEvLw0JSDYjVrZa88G1QBVjtF 9xhqkpCHh6YcFKtZK3vl2aAKsNpZ6ucsx0nINwpNOShWs1b2yrNBFWA1GogQ shGaclCsZi2akhDSOTTloFjNWk2akpokhGyHphwUq1lrfeXtrUlDUxJCtkNT DorVrEVTEkI6h6YcFKtZi6YkhHQOTTkoVrPW8aakJgkhxdCUg2I1ay2uvL01 aWhKQkgxNOWgWM1aNCUhpHNoykGxmrVoSkJI59CUg2I1a9GUhJDOoSkHxWrW Sq88apIQ0iE05aBYzVo0JSGkc2jKQbGatWhKQkjn0JSDOuVqfr7bZTB5/9wx 8vXxthhajxTYLD1yj1WA1dzmhBBSCE05qBOupnWgii08sv/59vE1jVj3uUfr OeEZ34/T0Hqk6EhTUpOEkIrQlIM69WqqBa+VN3/sZOZ465GyeOXtrUlDUxJC KkJTDuqsqzl9DIxfms4+U4aH8zlTYX64n8PQeqTMZsUHKsBqbltCCCmHphzU uVdTHxjdA+ft/X35SdHPmSaEJ7ZGyvwLROrAOjY/eTMQQkg2NOWgzr2a629Q 153n56TjWyP6YUO88vbWpKEpCSEVoSkHdcLVTCpOD+PI9H2re1SYUxgp8lce NUkI6RaaclCnXE0rNi9+EIwjsfDWc6YavTVSYNP8f1WA1dyGhBByMzTloFjN WjQlIaRzaMpBsZq1aEpCSOfQlINiNWvRlISQzqEpB8Vq1rIrz6j9qrnrlRBC akJTDorVrOWKkqYkhPQLTTkoVrOWK0qakhDSLzTloFjNWq4oaUpCSL/QlINi NWtRk4SQzqEpB8Vq1qIpCSGdQ1MOitWsRVMSQjqHphwUq1mLpiSEdA5NOShW sxZNSQjpHJpyUKxmrb1NSU0SQnaGphwUq1mLpiSEdA5NOShWsxZNSQjpHJpy UKxmLZqSENI5NOWgWM1au5qSmiSE7A9NOShWsxZNSQjpHJpyUKxmLZqSENI5 NOWgWM1aNCUhpHNoykGxmrVoSkJI59CUg2I1a9U3JTVJCLkrNOWgzriaXx9v dhk475/LIY1k5nj2xNvHl35w1iNZtic14S02M7n0CSGkMjTloM63mlMHJnU4 Pbx2nUYyc7zppx+zXlyPbKApCSGdQ1MO6tyraTVnJef/q6GV5Nnp4ft7Onk9 sommJIR0Dk05qFOv5ue7+7g4/Y+P6aPh5Pr50dMcs67V9UiB7VtNWGTTkuue EELqQ1MO6ryraRWogrNH8fvTazFOrnPiR8trL65HiqYaTqgYV+yp5LonhJD6 0JSDOudqWrkl/7aYtuOsCJM5008Je2I9oqkbbI7KsMimJdc9IYTUh6Yc1AlX c6q4+XesSVXq4XpOYM8sSnE9kkVTEkI6h6Yc1PlW07ow5UsufkD0P2bneDQl IWTU0JSDYjVr1TQlNUkIORCaclCsZi2akhDSOTTloFjNWjQlIaRzaMpBsZq1 aEpCSOfQlINiNWvdbEpqkhByLDTloFjNWjQlIaRzaMpBsZq1aEpCSOfQlINi NWvRlISQzqEpB8Vq1qIpCSGdQ1MOitWsVW5KapIQcjg05aBYzVo0JSGkc2jK QbGatWhKQkjn0JSDYjVr0ZSEkM6hKQfFatYqNCU1SQhpEZpyUKxmLZqSENI5 NOWgWM1aNCUhpHNoykGxmrVoSkJI59CUg2I1a9GUhJDOoSkHxWrW2mpKapIQ 0ig05aBYzVo0JSGkc2jKQbGatWhKQkjn0JSDYjVr0ZSEkM6hKQd13tX8fP/x /qnH0w/edWiSzvn6eNOcMLYeKbFZ6saEDSZXOSGEHAlNOaiTrqZvxtBv10JM q3E2Z2rF+cP1SJntS/WYsMHkKieEkCOhKQd1xtW0YrNeS0sxioOFOdNzbx9f +sFZj6zRlISQzqEpB3Xe1Vy24PTBsPTta7QezBfqAk1JCOkcmnJQ513NfL3N R7OluPj0uB7JsysvRVMSQlqHphzUeVcz35Tz71Hnc6ZPnfNSXI9si+0YUZOE kKahKQd13tVMWjD/0CQ/TaWYPGPWI0U0JSGkc2jKQZ13NWedaD9480+I1zlx gmfT1iNu4iabo4YMbCS5xAkh5GBoykGxmrVoSkJI59CUg2I1a9GUhJDOoSkH xWrWWjQlNUkIaR2aclCsZi2akhDSOTTloFjNWjQlIaRzaMpBsZq1aEpCSOfQ lINiNWulTUlNEkI6hKYcFKtZi6YkhHQOTTkoVrMWTUkI6RyaclCsZi2akhDS OTTloFjNWjQlIaRzaMpBsZq1YlNSk4SQPqEpB8Vq1qIpCSGdQ1MOitWsRVMS QjqHphwUq1mLpiSEdA5NOShWs5ZvSmqSENItNOWgWM1aNCUhpHNoykGxmrVo SkJI59CUg2I1a9GUhJDOoSkHxWrWoikJIZ1DUw6K1axlVx41SQjpGZpyUKxm LZqSENI5NOWgXns1P999/71/aqDAz0yu6UNpuCufwXc4+OFZ2u5w8MOztN3h 4IdnabvDbodHUw7qlVfTevLt4+ty+fp4q+jK6Vpu9/ZouCufwXc4+OFZ2u5w 8MOztN3h4IdnabvDbodHUw7qhVfTCtIVZfqooO17o+3eLIPvcPDDs7Td4eCH Z2m7w8EPz9J2h90Oj6Yc1Auvpn2kDJ8kk4eb2r432u7NMvgOBz88S9sdDn54 lrY7HPzwLG132O3waMpBvfBq7m9KADgL3bnQwguv5s5vXwEAr+mV//eOfX/R AwB4Ta/9Cd260qEnAQBb+C4bAIASmhIAgBKacq/Z38mGr29N9hvc6+TpH0MT 878gSp5004uTH+zO8zXXs1jPDTta7zq73wfqcr5xP/GZ9ciT3H++pVMIz8Wn ShfDQ3U53/VThck4I5pyF3/9x4vf3v6FFltMDqZ7xmwwGSg99wwHzvc6d30O NtM9d31mPfIUfc7XJurn8Gg98hzzU9h1vvbT9XwXW4Xn4koUFueh+pyvPaVZ 4VFhMs6JpqxnF729Da5vi9y7Pj67mhwkQ5lnF2+szIzHOXa+1zOJj8Kz66cy kx/PXnp1Ck3O96pm5GEOne/1dK+Pw7PX5/Qonfw8dhSzU5gGmpzvlUZyk3Fu NOVeydvDHr696UulxVtGVu+lG++b+fwh3mQHzteOf5q6Oof5LqeH65GnmR9K k/N1/JPpbtYjz3Dv+U6T/YlO5zE75/ksezj998MvztNPeHEKLc7Xmf02b03G 6dCUeyVvHvP15d8E9obIvdfmk9N3UMbyyeLkh7n3fK9HP90slquQzJoerkee Zv76Tc43sT67s56v+8F5e3+f/290ySz/cJoZZsx28QTz129yvom4Qc1knAhN udf8nRbYOy33flhMzm87me6uix1sT36oO893NmGxj+tz4dF65Gk6nG9ivZ9n n/Cd55tajl431qN0wjc838R6P4XJOBGacq/kyk8e2jsk936Yv022bhI2vn43 bU1+tHvP1x6G408eemHgeuLrkWeZn0J4eOh817tcjzxN/lCqztc/zPzK7Ln5 bzP/Ik+RP5RD57ueVZiMc6Ip90reFu4HfclyvUmmb4z5j4snw89xJ552tZz8 LLPjiIdac75xchhLng3PrWenu3uG/CkcPN/VfjIjT5I/hV3nG4aSZ8NzcfZU Gc63PN/VftaTcW40JQAAJTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0JQAA JTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0JQAAJTQlAAAlNCUAACU0JQAA JTQlAADbLpf/B7l3OEyWZLB5AAAAAElFTkSuQmCC ------=_NextPart_000_000B_01D22002.DD8DB200 Content-Type: image/png; name="ws1_50c_pg.png" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="ws1_50c_pg.png" iVBORw0KGgoAAAANSUhEUgAAAoEAAAEFCAIAAAAT+Kq8AAAAAXNSR0IArs4c 6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAABqPSURB VHhe7dwhkPRKucbxdUgcEofEIU5N4ZA4JA4zVTgkEodkFRKHxFGrcEgcgqrD KuqaS12DuXXl3u7008mbdCfdmckk05P/r546X7ank8ymk3nOfIfi7QsAAByB DgYA4Bh0MAAAx6CDAQA4Bh0MAMAx6GAAAI5BBwMAcAw6GACAY9DBAAAcgw4G cDpvJZr33PRe52nePM2bp3l4GC4xgBNRt5Ro9rPSuyzR7BzNKNFsPAyXGMBZ qFjqaJ/no/dXR/uM6bU62gePwfUFcCIqlpIwM+xys0ccoX9vNfr5Vj9eo5+P B+HiAjiX0C4L7Jywyw20/6ZH0M/jdzhnMj/Qz3ccAdviygLAiGon0uga2jPS 6BraM8qOLNO8KDuyTPMijWJTXFYAGFHnRBpdQ3tGGl1De0bZkWWaF2VHlmle pFFsissKACPqnEija2jPSKNraM8oO7JM86LsyDLNizSKTXFZAWBEnRNpdA3t GWl0De0ZZUeWaV6UHVmmeZFGl31cL++f2kaFussKAKehzok0uob2jDS6hvaM siPLNC/KjizTvEijsz6u3TQ6eJXyMgDAeXQ9MtDoGtoz0uga2jPKjizTvCg7 skzzIo3O+3y/hJl08CrlKwsA5xGKpKfRNbRnpNE1tGeUHVmmeVF2ZJnmRRqd RwffpnxlAeA8QpH0NLqG9ow0uob2jLIjyzQvyo4s07xIo/Po4NuUrywAnEco kp5G19CekUbX0J5RdmSZ5kXZkWWaF2l0Hh18m/KVBYDzCEXS0+ga2jPS6Bra M8qOLNO8KDuyTPMijeb07TsRy1j/W63k52Cusqd7jc8y3avumM+ovBIAcB76 GI80uob2jDS6hvaMsiPLNC/KjizTvEijOWs6eGZupjTLe10/xjPHWunh8koA wMvQJ/Q8OyfscgPtv+kR9PP4Hc6ZzA/08x1HyKrv4PdsWwbTzqzZy7Xw3Mmd Nlq4cHEB4GXow7kkzAy73OwRR+jfW41+vtWP1+jn1+jLMKm+6ffU+P3VGTXo eMfJXnM7BeZVu58Zflq11xcAmqbP5Tra5/no/dXRPmN6rY72qVDXwZnvpkOl jl40eyU7LVS31++aOdvToYMBnIU+mkvCzLDLzR5xhP691ejnW/14jX5+jZoO nunEbGcOe2W+zZoSXnqVDgaApxI+nGtoh/W0/6ZH0M9xRD9UCPMd/XzHEZZV dPBsJeb27ffK/oVy3at0MAA0JHx09zS6hvaMNLqG9oyyI8s0L8qOLNO8SKOL yh280IiZKfe0LB0MAA0KH909ja6hPSONrqE9o+zIMs2LsiPLNC/S6KJNOtgU 7j0tSwcDQIPCR3dPo2toz0ija2jPKDuyTPOi7MgyzYs0uogOvk3VxQWAMwgf 3T2NrqE9I42uoT2j7MgyzYuyI8s0L9Lookf9XfQtLUsHA0CDwkd3T6NraM9I o2tozyg7skzzouzIMs2LNLqo3MH5/7Lr5WbQwQBwJuFzu6fRNbRnpNE1tGeU HVmmeVF2ZJnmRRotqejguRLuJ9hd6WAAOJPwud3T6BraM9LoGtozyo4s07wo O7JM8yKNFs0WX1+xTqaFh5dHe97TssuvPpfq6wsALy18bvc0uob2jDS6hvaM siPLNC/KjizTvEijRX2XTptvKNmOfbn/8uyN+5kOBoAzCZ/bPY2uoT0jja6h PaPsyDLNi7IjyzQv0mjRpGqHBuwb8WIKdyqpSzoYAM4kfG73NLqG9ow0uob2 jLIjyzQvyo4s07xIo2WjL7WevtiaRkymBLmupIMB4EzC53ZPo2toz0ija2jP KDuyTPOi7MgyzYs0WmXcsarASSNm56ToYAB4IeFjeYGdE3a5gfbf9Aj6efwO 50zmB/r5jiPcoaVG3N8mlxgAnlpogaIwM+xys0ccoX9vNfr5Vj9eo5+/BTp4 yVZXGQCeVKiAStrn+ej91dE+Y3qtjvbZAB28hA4G8PpCCxRp9rPSuyzR7BzN KNHsbdDBS+hgAKcQimCB5j03vdd5mjdP8+Zp3mbo4CV0MADgcejgJXQwAOBx 6OAldDAAAMeggwEAOAYdDADAMehgAACOQQcDAHAMOhgAgGPQwQAAHIMOBgDg GHQwAADHoIMBADgGHQwAwDHo4LLw/3UKAE3QJxdawGqV7XBPv8YpHK5VPa5V Pa5VvX3Ogq2wWmU8//W4VvW4VvW4VvX2OQu2wmqV8fzX41rV41rV41rV2+cs 2AqrVcbzX49rVY9rVY9rVW+fs2ArrFYZ9zSAVvB51RZWq4x7GkAr+LxqC6tV xj0NoBV8XrWF1SrjngbQCj6v2sJqlXFPA2gFn1dtYbXKuKcBtILPq7awWmXc 0wBawedVW1itMu5pAK3g86otrFYZ9zSAVvB51RZWq+xs97T7fSf0Anahiz6m 15qit97REB6Pq90WVqvste/p7hNy5L/HNDqmnXEHXcrE/yT0QqT9n5LeYucf hoY6morH4Aq3pbHV+riGp/jt+hEGPt8vGumHkjnD0DDScTtf3j/1wzy3o7Ya Fy7ChJq2RLPf3v6rox8inQA5ukYJFewa2tPQOQ6lt9JR5S7S1I4Oge1wVdvS 1Gq5KlWLass3sEbiZjKn2+iq1sz2uvp+XAd3nzB5mvFIOtOY6vQ+4VChiXth sKc3cTL65RPqz03p0GN6H7vQKTuq1pvoEB0dGvfhSral0dUamraXfKmNc4YX 7BS/fb0+8Huw2+ubb77xHy1vb/87Fgbr6YjzNM9QYT5MOIsaOBFetfRGn57e 7k1Uj/vSud/evv32W2119PtsSofuqEI3pUN3dMoXpV9yTK/dbcNDYQftrVb3 9TVp4HErj+aYV/rN0Ma2kxfcdk+7vVwHB27bUQOvF3ZfoGLcnU4/X8Y9zYt0 jVbSzo/0fzfRzgfVcKB30JXxhn2sQ3RUlbvQKTt6K+3Q+573nxy91tGBbnLn 7thZq6s1/iLsfsqUqeakHRy7t76DLY0uctNUv0bYXb26kXBMVeJxwttQ31YI 89dS462knW/dfRWd6ZnK2NHPHd2gizS1o0o8VHgnenNPILyfBSrVO+hAHZ11 kaZGGkULWl2toT7d1sx/1dWc0VQN6Fbt5Hc23BxtVXO7qHgT3TlfrYnDG7BU thXCfJXYI+12Iiecy1Ex7kgnHlMbz/exhjqqvkPprYh7e0MeR2crUU/uRWft 6I0uqpyGJ9HUamW/0fZDQTrH/9n1bDJ5aOdFN9zTbhdV7gz/PD2miR0V42Po HFP+w3GcKVXuDE16fEfqNPuWsepxU+HIOZOFCBmojcd9rOo7lN6KTN5/JkU6 UjU9SDma0VE3HkHvYPGXX34Vz6ax1XJ1GoTu7H8MJoNDv8ahcV0f2cFB96Y2 bmInHFadeYdwnIT/+LspI+rehF5+rTLWmW4qY+2ZMbm89RlMylhluCOdWCbv sz55eh62pqM/Rxk7+tCJ0hE8M1arbO097earY+v4x2ienvv1wu6q0wph/lj4 gHtQplTCURhUiT3SbidywrkcFayhFzIm123bDHYrY51DJu/nnogegMfT+Trq xiPoHXTC50/4IEITWK2ytfe0m692reafnukHSp919PEQhUHVbBQGE5Pz7p8R 28SOSuxhdJpbT6Sd7zK5GvsnT815Nx3Om5x38wz0GDyeztdRN+5FZzX0SYQW sFpla+9pN1/VWi08OBulxmSX50yGGm8l7fxYkzffejLUpWtoT5mcYp+IqnIX OuUWZawDGd/5ztf3v//1ox99/fSnX7/4xdevf/31u999/fGPX3/5y9ff//71 73/7X1mfRGgBq1W29p5281WtdfyDNf3gINncbHIcsipTKtgZmiSTQx0YUU/u QqfsqFTH9JrhKva73/Ut+4Mf+KL98Y991/7sZ75uf/lL37i/+Y0v3d//3vfu n/7kq/evf/Xt+89/+gL+z3/8b6pPIrSA1SpbdU+7yarWav7Jm35eEPKcGVHr Pm/vZjNQVW5NR88JFfu976llf/hDFe1PfqKu/fnPVbe/+pUa97e/Ven+4Q/q 3T//WdX7t7+pff/1LxVw+AjqPorQBlarbNU97SarWqv5R3P6MUHI88eavNRK ROU5Q5NWmJxllEfXsD892sFqla26p91kVWs1/8wmDyohZMcsm0y+K3QwLFar bNU97SarWuv4Bzx5Sgkhrxo6GBarVVZ/T7uZqtZqvoKTp5QQ8qqhg2GxWmX1 97SbqWqt5is4eUoJIa8aOhgWq1VWf0+7marWar6Ck6eUEPKqoYNhsVpl9fe0 m6lqreYrOHlKCSGvGjoYFqtVVn9Pu5mq1jq+f5NHlBDywqGDYbFaZZX3tJum aq3mKzh5RAkhLxw6GBarVVZ5T7tpqtZqvoKTR5QQ8sKhg2GxWmWV97Sbpmqt 5is4eUQJIS8cOhgWq1VWeU+7aarWOr5/k+eTEPLaoYNhsVplNfe0m6NqreYr OHk+CSGvHToYFqtVVnNPuzmq1mq+gpPnkxDy2qGDYbFaZTX3tJujaq3mKzh5 Pgkhrx06GBarVVZzT7s5qtY6vn+Th5MQ8vKhg2GxWmXFe9pNULVW8xWcPJyE kJcPHQyrrdX6fL905eVcP8LQx1UD/dAwKc4J3Pjl/TNs93uNp+S5adqa4Sao Wqt1J9czSQg5T+hgWC2tli9X07Pdpi3WzjBgpjv+pze94hpYLwxbC4r3tJug aq3mKzh5OAkhLx86GFarq6WqHfesN+rgvp799vU6qWuHDiaE7Bo6GFajqxW7 0/15ueivnvsy9cXsDIUb2th2shNmlRv4AR3s313yZBJCzhA6GFaLq+WLdyjT z8+w6TrVF+rwoi9ZPxK7d9LBQc0X4a4yBxqN3IiqtVo4DCHkhKGDYbW2Wr5Y 0yb1QsWOirYrWL+HMdk5W8wTbi9t5bhXVa3VujeiB5IQcqrQwbCaWi1fp+Nv reZrrHtx/D3YbnpD3Zq9zOas5XvavapqreYrOHkyCSFnCB0Mq6XVcn1phULt B/u6HaaN29V+5U33WuCmaSvHvapqrdOdVk8jIeRsoYNhsVplC/e0e0nVWs1X cPJYEkJOEjoYFqtVtnBPu5dUrdV8BSePJSHkJKGDYbFaZQv3tHtJ1VrNV3Dy WBJCThI6GBarVbZwT7uXVK3VfAUnjyUh5CShg2GxWmVz97QbV69W8/2bPJOE kPOEDobFapXN3dNuXNVazVdw8kwSQs4TOhgWq1U2d0+7cVVrNV/ByTNJCDlP 6GBYrFbZ3D3txlWt1XwFJ88kIeQ8oYNhsVpl2XvaDapXq/n+TR5IQsipQgfD YrXKsve0G1S1VvMVnDyQhJBThQ6GxWqVZe9pN6hqreYrOHkgCSGnCh0Mi9Uq y97TblDVWs1XcPJAEkJOFToYFqtVlr2n3aCqtZqv4OSBJIScKnQwLFarLL2n 3Yh6tZrv3+RpJIScLXQwLFarLL2n3YiqtZqv4ORpJIScLXQwLFarLL2n3Yiq tZqv4ORpJIScLXQwLFarLL2n3YiqtZqv4ORpJIScLXQwLFarbHJPux/Vq9V8 /yaPIiHkhKGDYbFaZZN72v2oaq3mKzh5FAkhJwwdDIvVKpvc0+5HVWs1X8HJ o0gIOWHoYFisVtnknnY/qlqr+QpOHkVCyAlDB8NitcrsPe221avVfP8mzyEh 5Jyhg2G1uFof17frh7b9D0E/lI58vl/GQ8OAOdIsN0tbdDAh5L7QwbCaW63Q sLE53U+X90+/5Wq12xoKOm7FV0L1uiH9YUaW2Xvabataq/n3mzyHhJBzhg6G 1dZqucp0jTnU7FCv4+1OtoPHU7JDCXtPu21VazVfwclzSAg5Z+hgWC2u1tDB fnPo17gZfrB/zRx+Hl7vmUPNs/e021a1VvNnTp5DQsg5QwfDaryDux86l+t1 +o1W88Y9bSp3eGFZOEFP1Vqn22N4/AghJw8dDKv5Du6lo+HvmcM/NdRP8nVc VcBOf0+7DVVrNV/ByUNICDlt6GBYjXfwqFO7rfRF90dsW21Ovg+X9Pe021C1 VvMVnDyEhJDThg6G1XgHdz8E/VA/0n/P7UfCpOHHTvHrsJvTb6haq3Vn0LNH CCF0MCxWqyzc0+6f6tVqvn+TJ5AQcubQwbBYrbJwT7t/qlqr+QpOnkBCyJlD B8NitcrCPe3+qWqt5is4eQIJIWcOHQyL1SoL97T7p6q1mq/g5AkkhJw5dDAs Vqusq9LVBex0+w3PHiGE0MGwWK2yrkr5EkwI2SB0MCxWq6xrUzqYELJB6GBY rFZZ16Z0MCFkg9DBsFitshsK2KGDCSFp6GBYrFbZDR1MARNCsqGDYbFaZXQw IWSr0MGwWK0yOpgQslXoYFisVhkdTAjZKnQwLFarbG0HU8CEkLnQwbBYrTI6 mBCyVehgWKxWGR1MCNkqdDAsVquMDiaEbBU6GBarVUYHE0K2Ch0Mi9UqW9XB FDAhZCF0MCxWq4wOJoRsFToYFqtVRgcTQrYKHQyL1SqjgwkhW4UOhtXian1c 364f2v58v3St58Qx9/J4IDOnY4+zxO2ngi3pzjE8bIQQMgkdDKu51QoNq+70 7TrZdK9f3j814rcyc7zRcZa5eerYEn/I5JEjhJA+dDCstlbLlahrzfz311C5 Kl4zEraDOLJ0nBQdTAjZKnQwrBZXK9udcdD9qeJ1RRs3ZbIjHUwI2Tt0MKzX 6OCheMMPncv1ar8Hj+Z0VnSwpb7N6V4fHjZCCJmEDobVfgenX3ejYV5+zooO VscuooAJIcXQwbAa72BfruMe7V/sX0rnCB1MCNk7dDCstjvYbVnhq24/GCZl 53ToYELI3qGDYbFaZXQwIWSr0MGwWK2ymg6mgAkhNaGDYbFaZXQwIWSr0MGw WK0yOpgQslXoYFisVhkdTAjZKnQwLFarjA4mhGwVOhgWq1VW7GAKmBBSGToY FqtVRgcTQrYKHQyL1SqjgwkhW4UOhsVqldHBhJCtQgfDYrXKljuYAiaE1IcO hsVqldHBhJCtQgfDYrXK6GBCyFahg2GxWmV0MCFkq9DBsFitsoUOpoAJIatC B8NitcroYELIVqGDYbFaZXQwIWSr0MGwWK0yOpgQslXoYFisVhkdTAjZKnQw LFarbK6DKWBCyNrQwbBYrTI6mBCyVehgWKxWGR1MCNkqdDCs5lfr8/3SdeHb 2/VDQx03fnn/7Lencz6uk4EFbppad6w7wPBoEUJIMXQwrMZXa2ha37NDoXat O7wyneMauBsa7zQn28EUMCHkhtDBsNperaFeR/zw9aqXMnOGoZkDjNHBhJCt QgfDanu13PfZ63v8i+b4hTb0at+umTl+SJPN5iy3n4rX6A43PFeEEFITOhhW 8x0c/8Y5tmnsXtvB0zmmeM3mrK5uB3QwIeTm0MGw2v8eHBu0//rbtaO4kXTO 0M9ma4E7Tuhdqzv88FwRQkhN6GBYja/W/DfaoV0zc9yf3Yu+se1OeWkHU8CE kNtCB8NqfrV8jXYm32ftN9zMHNfCnXID08GEkO1CB8NitcroYELIVqGDYbFa ZXQwIWSr0MGwWK2ySQdTwISQm0MHw2K1yuhgQshWoYNhsVpldDAhZKvQwbBY rTI6mBCyVehgWKxWGR1MCNkqdDAsVqvMdjAFTAi5J3QwLFarjA4mhGwVOhgW q1VGBxNCtgodDIvVKqODCSFbhQ6GxWqV9R1MARNC7gwdDIvVKqODCSFbhQ6G xWqV0cGEkK1CB8NitcroYELIVqGDYbFaZaGDKWBCyP2hg2GxWmV0MCFkq9DB sFitMjqYELJV6GBYrFYZHUwI2Sp0MCxWq4wOJoRsFToYFqtV1rWvMzxFhBBy W+hgWKxWWWhg+xQRQshtoYNhnXW1Pq6hV68fGlgQZtqn6AF59PFddjiFyw5n eY1TuOxwltc4hcsOZ9npFHQwrHOulmvgy/vn19fn+6Wihbsnx+kfpEfk0cd3 2eEULjuc5TVO4bLDWV7jFC47nGWnU9DBsE65Wq56uwq2WwvCk/PgvMYpXHY4 y2ucwmWHs7zGKVx2OMtOp6CDYZ1ytdzX4Pjt12zOCk/Og/Map3DZ4SyvcQqX Hc7yGqdw2eEsO52CDoZFB1d2MAC0QZ9caMEpV2vl30UDAPAI5/w3pnX/mywA AB7hrH9r4Vq4QwMDAI7CfzkAAOAYdDAAAMegg+uN/jfU8S+znfzfZ4/+517z f/WdHsf/R+rRQIvuuFbeaPdef5zxa/nJ7bj5Wg13SmZuPNDkleRSt+Uh16o/ TnjFTPVavlxoAB1cKTyn/eNb+ijrnuM4w+3bbfrByQdAcpxhIDO7EfdcK2ey e+SGNTZszU5uxu3XytwfZlPcYbtZk1fM7g16zLUa7qZhS5K5wObo4BruWXSP onlEMw+nfYDdy5fr1ZTpdCtOTo+TmdwW97bdb3TrtUp3H20H/Ug6uS13XquB f8EPxsnxZ7u1sHsL3Jt/zLUaTEfSGcDm6OB65pF0m5eL+7fs0b+XR+Ehj4/6 dL/pU54ex3+4OG1+VMqt10qm16kXrs34tdnJjbjzWjnJFRgfMmzO796QB1yr jps5PUzjVwqtoIPrjZ/ez8/wfLpHNfvoDo/w+HNj+gEwOY7/ZAm7uYHcp0Ub br1WkrlO1vjlwuSnd/+1Gg845pDanN29LQ+4VoY9emEqsBE6uN74+Y8mz7n7 MfyreeBfGmYknwlGeG00I3/CJtx6raTwm4+P0/Bl6txxrfyonRUNO2srv3t7 HnCtDHOc1m8qNIMOrmceS7Ppntvswzp+nrtN/ykwnpseJ851zGZzzC+W/o4J c60Cs08vf0gnN7kl+V+sfK3c1uwv7g6Uv+WSS92WB1yr7CEbv0xoCB1czzys 3Q+jf8sev+qMnuI4O33Yk+MMI+PjtWV0NZLfcfSqk3zi2QnDdnKcYHq01oze f/I7Tn+7/lr1M4Nu0EyOL08uTePlMroa/RW481olx0mPBDwKHQwAwDHoYAAA jkEHAwBwDDoYAIBj0MEAAByDDgYA4Bh0MAAAx6CDAQA4Bh0MAMAx6GAAAI5B BwMAcAw6GACAY9DBAAAcgw4GAOAYdDAAAMeggwEAOAYdDADAMehgAACO8PX1 //gkd4lAMxMaAAAAAElFTkSuQmCC ------=_NextPart_000_000B_01D22002.DD8DB200 Content-Type: application/octet-stream; name="postgresql.conf" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="postgresql.conf" # -----------------------------=0A= # PostgreSQL configuration file=0A= # -----------------------------=0A= #=0A= # This file consists of lines of the form:=0A= #=0A= # name =3D value=0A= #=0A= # (The "=3D" is optional.) Whitespace may be used. Comments are introduce= d with=0A= # "#" anywhere on a line. The complete list of parameter names and allowed= =0A= # values can be found in the PostgreSQL documentation.=0A= #=0A= # The commented-out settings shown in this file represent the default value= s.=0A= # Re-commenting a setting is NOT sufficient to revert it to the default val= ue;=0A= # you need to reload the server.=0A= #=0A= # This file is read on server startup and when the server receives a SIGHUP= =0A= # signal. If you edit the file on a running system, you have to SIGHUP the= =0A= # server for the changes to take effect, or use "pg_ctl reload". Some=0A= # parameters, which are marked below, require a server shutdown and restart= to=0A= # take effect.=0A= #=0A= # Any parameter can also be given as a command-line option to the server, e= .g.,=0A= # "postgres -c log_connections=3Don". Some parameters can be changed at ru= n time=0A= # with the "SET" SQL command.=0A= #=0A= # Memory units: kB =3D kilobytes Time units: ms =3D milliseconds= =0A= # MB =3D megabytes s =3D seconds=0A= # GB =3D gigabytes min =3D minutes=0A= # TB =3D terabytes h =3D hours=0A= # d =3D days=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # FILE LOCATIONS=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # The default values of these variables are driven from the -D command-line= =0A= # option or PGDATA environment variable, represented here as ConfigDir.=0A= =0A= data_directory =3D '/var/lib/postgresql/9.5/main' # use data in another di= rectory=0A= # (change requires restart)=0A= hba_file =3D '/etc/postgresql/9.5/main/pg_hba.conf' # host-based authentica= tion file=0A= # (change requires restart)=0A= ident_file =3D '/etc/postgresql/9.5/main/pg_ident.conf' # ident configurati= on file=0A= # (change requires restart)=0A= =0A= # If external_pid_file is not explicitly set, no extra PID file is written.= =0A= external_pid_file =3D '/var/run/postgresql/9.5-main.pid' # write an extra= PID file=0A= # (change requires restart)=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # CONNECTIONS AND AUTHENTICATION=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Connection Settings -=0A= =0A= listen_addresses =3D '*' # what IP address(es) to listen on;=0A= # comma-separated list of addresses;=0A= # defaults to 'localhost'; use '*' for all=0A= # (change requires restart)=0A= port =3D 5432 # (change requires restart)=0A= max_connections =3D 103 # (change requires restart)=0A= superuser_reserved_connections =3D 3 # (change requires restart)=0A= unix_socket_directories =3D '/var/run/postgresql' # comma-separated list of= directories=0A= # (change requires restart)=0A= #unix_socket_group =3D '' # (change requires restart)=0A= #unix_socket_permissions =3D 0777 # begin with 0 to use octal notation=0A= # (change requires restart)=0A= #bonjour =3D off # advertise server via Bonjour=0A= # (change requires restart)=0A= #bonjour_name =3D '' # defaults to the computer name=0A= # (change requires restart)=0A= =0A= # - Security and Authentication -=0A= =0A= authentication_timeout =3D 1min # 1s-600s=0A= ssl =3D true # (change requires restart)=0A= #ssl_ciphers =3D 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers=0A= # (change requires restart)=0A= #ssl_prefer_server_ciphers =3D on # (change requires restart)=0A= #ssl_ecdh_curve =3D 'prime256v1' # (change requires restart)=0A= ssl_cert_file =3D '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change require= s restart)=0A= ssl_key_file =3D '/etc/ssl/private/ssl-cert-snakeoil.key' # (change requir= es restart)=0A= #ssl_ca_file =3D '' # (change requires restart)=0A= #ssl_crl_file =3D '' # (change requires restart)=0A= password_encryption =3D on=0A= #db_user_namespace =3D off=0A= #row_security =3D on=0A= =0A= # GSSAPI using Kerberos=0A= #krb_server_keyfile =3D ''=0A= #krb_caseins_users =3D off=0A= =0A= # - TCP Keepalives -=0A= # see "man 7 tcp" for details=0A= =0A= #tcp_keepalives_idle =3D 0 # TCP_KEEPIDLE, in seconds;=0A= # 0 selects the system default=0A= #tcp_keepalives_interval =3D 0 # TCP_KEEPINTVL, in seconds;=0A= # 0 selects the system default=0A= #tcp_keepalives_count =3D 0 # TCP_KEEPCNT;=0A= # 0 selects the system default=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # RESOURCE USAGE (except WAL)=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Memory -=0A= =0A= shared_buffers =3D 512MB # min 128kB=0A= # (change requires restart)=0A= #huge_pages =3D try # on, off, or try=0A= # (change requires restart)=0A= temp_buffers =3D 8MB # min 800kB=0A= max_prepared_transactions =3D 0 # zero disables the feature=0A= # (change requires restart)=0A= # Caution: it is not advisable to set max_prepared_transactions nonzero unl= ess=0A= # you actively intend to use prepared transactions.=0A= work_mem =3D 16MB # min 64kB=0A= maintenance_work_mem =3D 256MB # min 1MB=0A= #autovacuum_work_mem =3D -1 # min 1MB, or -1 to use maintenance_work_mem= =0A= #max_stack_depth =3D 2MB # min 100kB=0A= dynamic_shared_memory_type =3D posix # the default is the first option=0A= # supported by the operating system:=0A= # posix=0A= # sysv=0A= # windows=0A= # mmap=0A= # use none to disable dynamic shared memory=0A= =0A= # - Disk -=0A= =0A= #temp_file_limit =3D -1 # limits per-session temp file space=0A= # in kB, or -1 for no limit=0A= =0A= # - Kernel Resource Usage -=0A= =0A= #max_files_per_process =3D 1000 # min 25=0A= # (change requires restart)=0A= #shared_preload_libraries =3D '' # (change requires restart)=0A= =0A= # - Cost-Based Vacuum Delay -=0A= =0A= #vacuum_cost_delay =3D 0 # 0-100 milliseconds=0A= #vacuum_cost_page_hit =3D 1 # 0-10000 credits=0A= #vacuum_cost_page_miss =3D 10 # 0-10000 credits=0A= #vacuum_cost_page_dirty =3D 20 # 0-10000 credits=0A= #vacuum_cost_limit =3D 200 # 1-10000 credits=0A= =0A= # - Background Writer -=0A= =0A= bgwriter_delay =3D 200ms # 10-10000ms between rounds=0A= #bgwriter_lru_maxpages =3D 100 # 0-1000 max buffers written/round=0A= #bgwriter_lru_multiplier =3D 2.0 # 0-10.0 multipler on buffers scanned/rou= nd=0A= =0A= # - Asynchronous Behavior -=0A= =0A= #effective_io_concurrency =3D 1 # 1-1000; 0 disables prefetching=0A= #max_worker_processes =3D 8=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # WRITE AHEAD LOG=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Settings -=0A= =0A= #wal_level =3D minimal # minimal, archive, hot_standby, or logical=0A= # (change requires restart)=0A= fsync =3D on # turns forced synchronization on or off=0A= synchronous_commit =3D off # synchronization level;=0A= # off, local, remote_write, or on=0A= wal_sync_method =3D fsync # the default is the first option=0A= # supported by the operating system:=0A= # open_datasync=0A= # fdatasync (default on Linux)=0A= # fsync=0A= # fsync_writethrough=0A= # open_sync=0A= full_page_writes =3D on # recover from partial page writes=0A= #wal_compression =3D off # enable compression of full-page writes=0A= #wal_log_hints =3D off # also do full page writes of non-critical updates= =0A= # (change requires restart)=0A= wal_buffers =3D 8MB # min 32kB, -1 sets based on shared_buffers=0A= # (change requires restart)=0A= wal_writer_delay =3D 200ms # 1-10000 milliseconds=0A= =0A= commit_delay =3D 0 # range 0-100000, in microseconds=0A= commit_siblings =3D 5 # range 1-1000=0A= =0A= # - Checkpoints -=0A= =0A= checkpoint_timeout =3D 5min # range 30s-1h=0A= #max_wal_size =3D 1GB=0A= #min_wal_size =3D 80MB=0A= checkpoint_completion_target =3D 0.5 # checkpoint target duration, 0.0 - 1.= 0=0A= checkpoint_warning =3D 30s # 0 disables=0A= =0A= # - Archiving -=0A= =0A= #archive_mode =3D off # enables archiving; off, on, or always=0A= # (change requires restart)=0A= #archive_command =3D '' # command to use to archive a logfile segment=0A= # placeholders: %p =3D path of file to archive=0A= # %f =3D file name only=0A= # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archiv= edir/%f'=0A= #archive_timeout =3D 0 # force a logfile segment switch after this=0A= # number of seconds; 0 disables=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # REPLICATION=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Sending Server(s) -=0A= =0A= # Set these on the master and on any standby that will send replication dat= a.=0A= =0A= #max_wal_senders =3D 0 # max number of walsender processes=0A= # (change requires restart)=0A= #wal_keep_segments =3D 0 # in logfile segments, 16MB each; 0 disables=0A= #wal_sender_timeout =3D 60s # in milliseconds; 0 disables=0A= =0A= #max_replication_slots =3D 0 # max number of replication slots=0A= # (change requires restart)=0A= #track_commit_timestamp =3D off # collect timestamp of transaction commit= =0A= # (change requires restart)=0A= =0A= # - Master Server -=0A= =0A= # These settings are ignored on a standby server.=0A= =0A= #synchronous_standby_names =3D '' # standby servers that provide sync rep= =0A= # comma-separated list of application_name=0A= # from standby(s); '*' =3D all=0A= #vacuum_defer_cleanup_age =3D 0 # number of xacts by which cleanup is delay= ed=0A= =0A= # - Standby Servers -=0A= =0A= # These settings are ignored on a master server.=0A= =0A= #hot_standby =3D off # "on" allows queries during recovery=0A= # (change requires restart)=0A= #max_standby_archive_delay =3D 30s # max delay before canceling queries=0A= # when reading WAL from archive;=0A= # -1 allows indefinite delay=0A= #max_standby_streaming_delay =3D 30s # max delay before canceling queries= =0A= # when reading streaming WAL;=0A= # -1 allows indefinite delay=0A= #wal_receiver_status_interval =3D 10s # send replies at least this often=0A= # 0 disables=0A= #hot_standby_feedback =3D off # send info from standby to prevent=0A= # query conflicts=0A= #wal_receiver_timeout =3D 60s # time that receiver waits for=0A= # communication from master=0A= # in milliseconds; 0 disables=0A= #wal_retrieve_retry_interval =3D 5s # time to wait before retrying to=0A= # retrieve WAL after a failed attempt=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # QUERY TUNING=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Planner Method Configuration -=0A= =0A= enable_bitmapscan =3D on=0A= enable_hashagg =3D on=0A= enable_hashjoin =3D on=0A= enable_indexscan =3D on=0A= enable_indexonlyscan =3D on=0A= enable_material =3D on=0A= enable_mergejoin =3D on=0A= enable_nestloop =3D on=0A= enable_seqscan =3D on=0A= enable_sort =3D on=0A= enable_tidscan =3D on=0A= =0A= # - Planner Cost Constants -=0A= =0A= #seq_page_cost =3D 1.0 # measured on an arbitrary scale=0A= #random_page_cost =3D 4.0 # same scale as above=0A= #cpu_tuple_cost =3D 0.01 # same scale as above=0A= #cpu_index_tuple_cost =3D 0.005 # same scale as above=0A= #cpu_operator_cost =3D 0.0025 # same scale as above=0A= effective_cache_size =3D 1497MB=0A= =0A= # - Genetic Query Optimizer -=0A= =0A= geqo =3D on=0A= #geqo_threshold =3D 12=0A= #geqo_effort =3D 5 # range 1-10=0A= #geqo_pool_size =3D 0 # selects default based on effort=0A= #geqo_generations =3D 0 # selects default based on effort=0A= #geqo_selection_bias =3D 2.0 # range 1.5-2.0=0A= #geqo_seed =3D 0.0 # range 0.0-1.0=0A= =0A= # - Other Planner Options -=0A= =0A= #default_statistics_target =3D 100 # range 1-10000=0A= #constraint_exclusion =3D partition # on, off, or partition=0A= #cursor_tuple_fraction =3D 0.1 # range 0.0-1.0=0A= #from_collapse_limit =3D 8=0A= #join_collapse_limit =3D 8 # 1 disables collapsing of explicit=0A= # JOIN clauses=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # ERROR REPORTING AND LOGGING=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Where to Log -=0A= =0A= #log_destination =3D 'stderr' # Valid values are combinations of=0A= # stderr, csvlog, syslog, and eventlog,=0A= # depending on platform. csvlog=0A= # requires logging_collector to be on.=0A= =0A= # This is used when logging to stderr:=0A= logging_collector =3D on # Enable capturing of stderr and csvlog=0A= # into log files. Required to be on for=0A= # csvlogs.=0A= # (change requires restart)=0A= =0A= # These are only used if logging_collector is on:=0A= log_directory =3D 'pg_log' # directory where log files are written,=0A= # can be absolute or relative to PGDATA=0A= log_filename =3D 'postgresql-%a%S.log' # log file name pattern,=0A= # can include strftime() escapes=0A= #log_file_mode =3D 0600 # creation mode for log files,=0A= # begin with 0 to use octal notation=0A= log_truncate_on_rotation =3D on # If on, an existing log file with the=0A= # same name as the new log file will be=0A= # truncated rather than appended to.=0A= # But such truncation only occurs on=0A= # time-driven rotation, not on restarts=0A= # or size-driven rotation. Default is=0A= # off, meaning append to existing files=0A= # in all cases.=0A= log_rotation_age =3D 1d # Automatic rotation of logfiles will=0A= # happen after that time. 0 disables.=0A= log_rotation_size =3D 0 # Automatic rotation of logfiles will=0A= # happen after that much log output.=0A= # 0 disables.=0A= =0A= # These are relevant when logging to syslog:=0A= #syslog_facility =3D 'LOCAL0'=0A= #syslog_ident =3D 'postgres'=0A= =0A= # This is only relevant when logging to eventlog (win32):=0A= #event_source =3D 'PostgreSQL'=0A= =0A= # - When to Log -=0A= =0A= #client_min_messages =3D notice # values in order of decreasing detail:=0A= # debug5=0A= # debug4=0A= # debug3=0A= # debug2=0A= # debug1=0A= # log=0A= # notice=0A= # warning=0A= # error=0A= =0A= #log_min_messages =3D warning # values in order of decreasing detail:=0A= # debug5=0A= # debug4=0A= # debug3=0A= # debug2=0A= # debug1=0A= # info=0A= # notice=0A= # warning=0A= # error=0A= # log=0A= # fatal=0A= # panic=0A= =0A= #log_min_error_statement =3D error # values in order of decreasing detail:= =0A= # debug5=0A= # debug4=0A= # debug3=0A= # debug2=0A= # debug1=0A= # info=0A= # notice=0A= # warning=0A= # error=0A= # log=0A= # fatal=0A= # panic (effectively off)=0A= =0A= #log_min_duration_statement =3D -1 # -1 is disabled, 0 logs all statements= =0A= # and their durations, > 0 logs only=0A= # statements running at least this number=0A= # of milliseconds=0A= =0A= =0A= # - What to Log -=0A= =0A= #debug_print_parse =3D off=0A= #debug_print_rewritten =3D off=0A= #debug_print_plan =3D off=0A= #debug_pretty_print =3D on=0A= #log_checkpoints =3D off=0A= #log_connections =3D off=0A= #log_disconnections =3D off=0A= #log_duration =3D off=0A= #log_error_verbosity =3D default # terse, default, or verbose messages=0A= #log_hostname =3D off=0A= log_line_prefix =3D '%t [%p-%l] %q%u@%d ' # special values:=0A= # %a =3D application name=0A= # %u =3D user name=0A= # %d =3D database name=0A= # %r =3D remote host and port=0A= # %h =3D remote host=0A= # %p =3D process ID=0A= # %t =3D timestamp without milliseconds=0A= # %m =3D timestamp with milliseconds=0A= # %i =3D command tag=0A= # %e =3D SQL state=0A= # %c =3D session ID=0A= # %l =3D session line number=0A= # %s =3D session start timestamp=0A= # %v =3D virtual transaction ID=0A= # %x =3D transaction ID (0 if none)=0A= # %q =3D stop here in non-session=0A= # processes=0A= # %% =3D '%'=0A= # e.g. '<%u%%%d> '=0A= #log_lock_waits =3D off # log lock waits >=3D deadlock_timeout=0A= #log_statement =3D 'none' # none, ddl, mod, all=0A= #log_replication_commands =3D off=0A= #log_temp_files =3D -1 # log temporary files equal or larger=0A= # than the specified size in kilobytes;=0A= # -1 disables, 0 logs all temp files=0A= log_timezone =3D 'Cuba'=0A= =0A= =0A= # - Process Title -=0A= =0A= cluster_name =3D '9.5/main' # added to process titles if nonempty=0A= # (change requires restart)=0A= #update_process_title =3D on=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # RUNTIME STATISTICS=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Query/Index Statistics Collector -=0A= =0A= #track_activities =3D on=0A= #track_counts =3D on=0A= #track_io_timing =3D off=0A= track_functions =3D pl # none, pl, all=0A= #track_activity_query_size =3D 1024 # (change requires restart)=0A= stats_temp_directory =3D '/var/run/postgresql/9.5-main.pg_stat_tmp'=0A= =0A= =0A= # - Statistics Monitoring -=0A= =0A= #log_parser_stats =3D off=0A= #log_planner_stats =3D off=0A= #log_executor_stats =3D off=0A= #log_statement_stats =3D off=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # AUTOVACUUM PARAMETERS=0A= #--------------------------------------------------------------------------= ----=0A= =0A= autovacuum =3D on # Enable autovacuum subprocess? 'on'=0A= # requires track_counts to also be on.=0A= #log_autovacuum_min_duration =3D -1 # -1 disables, 0 logs all actions and= =0A= # their durations, > 0 logs only=0A= # actions running at least this number=0A= # of milliseconds.=0A= autovacuum_max_workers =3D 3 # max number of autovacuum subprocesses=0A= # (change requires restart)=0A= autovacuum_naptime =3D 1min # time between autovacuum runs=0A= autovacuum_vacuum_threshold =3D 50 # min number of row updates before=0A= # vacuum=0A= autovacuum_analyze_threshold =3D 50 # min number of row updates before=0A= # analyze=0A= autovacuum_vacuum_scale_factor =3D 0.2 # fraction of table size before vacu= um=0A= autovacuum_analyze_scale_factor =3D 0.1 # fraction of table size before ana= lyze=0A= autovacuum_freeze_max_age =3D 200000000 # maximum XID age before force vacu= um=0A= # (change requires restart)=0A= #autovacuum_multixact_freeze_max_age =3D 400000000 # maximum multixact age= =0A= # before forced vacuum=0A= # (change requires restart)=0A= #autovacuum_vacuum_cost_delay =3D 20ms # default vacuum cost delay for=0A= # autovacuum, in milliseconds;=0A= # -1 means use vacuum_cost_delay=0A= autovacuum_vacuum_cost_limit =3D -1 # default vacuum cost limit for=0A= # autovacuum, -1 means use=0A= # vacuum_cost_limit=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # CLIENT CONNECTION DEFAULTS=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Statement Behavior -=0A= =0A= #search_path =3D '"$user", public' # schema names=0A= #default_tablespace =3D '' # a tablespace name, '' uses the default=0A= #temp_tablespaces =3D '' # a list of tablespace names, '' uses=0A= # only default tablespace=0A= #check_function_bodies =3D on=0A= #default_transaction_isolation =3D 'read committed'=0A= #default_transaction_read_only =3D off=0A= #default_transaction_deferrable =3D off=0A= #session_replication_role =3D 'origin'=0A= #statement_timeout =3D 0 # in milliseconds, 0 is disabled=0A= #lock_timeout =3D 0 # in milliseconds, 0 is disabled=0A= vacuum_freeze_min_age =3D 50000000=0A= vacuum_freeze_table_age =3D 150000000=0A= vacuum_multixact_freeze_min_age =3D 5000000=0A= #vacuum_multixact_freeze_table_age =3D 150000000=0A= #bytea_output =3D 'hex' # hex, escape=0A= #xmlbinary =3D 'base64'=0A= #xmloption =3D 'content'=0A= #gin_fuzzy_search_limit =3D 0=0A= #gin_pending_list_limit =3D 4MB=0A= =0A= # - Locale and Formatting -=0A= =0A= datestyle =3D 'iso, mdy'=0A= #intervalstyle =3D 'postgres'=0A= timezone =3D 'Cuba'=0A= #timezone_abbreviations =3D 'Default' # Select the set of available tim= e zone=0A= # abbreviations. Currently, there are=0A= # Default=0A= # Australia (historical usage)=0A= # India=0A= # You can create your own file in=0A= # share/timezonesets/.=0A= #extra_float_digits =3D 0 # min -15, max 3=0A= #client_encoding =3D sql_ascii # actually, defaults to database=0A= # encoding=0A= =0A= # These settings are initialized by initdb, but they can be changed.=0A= lc_messages =3D 'en_US.UTF-8' # locale for system error message=0A= # strings=0A= lc_monetary =3D 'en_US.UTF-8' # locale for monetary formatting=0A= lc_numeric =3D 'en_US.UTF-8' # locale for number formatting=0A= lc_time =3D 'en_US.UTF-8' # locale for time formatting=0A= =0A= # default configuration for text search=0A= default_text_search_config =3D 'pg_catalog.english'=0A= =0A= # - Other Defaults -=0A= =0A= #dynamic_library_path =3D '$libdir'=0A= #local_preload_libraries =3D ''=0A= #session_preload_libraries =3D ''=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # LOCK MANAGEMENT=0A= #--------------------------------------------------------------------------= ----=0A= =0A= #deadlock_timeout =3D 1s=0A= #max_locks_per_transaction =3D 64 # min 10=0A= # (change requires restart)=0A= #max_pred_locks_per_transaction =3D 64 # min 10=0A= # (change requires restart)=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # VERSION/PLATFORM COMPATIBILITY=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # - Previous PostgreSQL Versions -=0A= =0A= #array_nulls =3D on=0A= #backslash_quote =3D safe_encoding # on, off, or safe_encoding=0A= #default_with_oids =3D off=0A= #escape_string_warning =3D on=0A= #lo_compat_privileges =3D off=0A= #operator_precedence_warning =3D off=0A= #quote_all_identifiers =3D off=0A= #sql_inheritance =3D on=0A= #standard_conforming_strings =3D on=0A= #synchronize_seqscans =3D on=0A= =0A= # - Other Platforms and Clients -=0A= =0A= #transform_null_equals =3D off=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # ERROR HANDLING=0A= #--------------------------------------------------------------------------= ----=0A= =0A= #exit_on_error =3D off # terminate session on any error?=0A= #restart_after_crash =3D on # reinitialize after backend crash?=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # CONFIG FILE INCLUDES=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # These options allow settings to be loaded from files other than the=0A= # default postgresql.conf.=0A= =0A= #include_dir =3D 'conf.d' # include files ending in '.conf' from=0A= # directory 'conf.d'=0A= #include_if_exists =3D 'exists.conf' # include file only if it exists=0A= #include =3D 'special.conf' # include file=0A= =0A= =0A= #--------------------------------------------------------------------------= ----=0A= # CUSTOMIZED OPTIONS=0A= #--------------------------------------------------------------------------= ----=0A= =0A= # Add settings for extensions here=0A= ------=_NextPart_000_000B_01D22002.DD8DB200 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ------=_NextPart_000_000B_01D22002.DD8DB200--