From rogerio.pereira@riosoft.com.br Mon Nov  18 16:38:25 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50790=pgsql-performance-ar@postgresql.org>)
 id 1ViRqD-00043L-MF
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:38:25 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50790=pgsql-performance-ar@postgresql.org>)
 id 1ViRqC-0002zq-PE
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:38:24 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1ViRq9-0002uI-1E
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:38:21 +0000
Received: from riosoftweb1.riosoft.com.br ([186.237.128.40]
 helo=emailserver.riosoft.com.br)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1ViRq3-0001Op-2S
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:38:20 +0000
Received: from [171.171.0.172] ([201.91.189.254]) by riosoft.com.br with
 MailEnable ESMTP; Mon, 18 Nov 2013 14:38:09 -0200
Message-ID: <528A4271.80806@riosoft.com.br>
Date: Mon, 18 Nov 2013 14:38:09 -0200
From: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Query in cache
Content-Type: multipart/alternative;
 boundary="------------020909000503050909080006"
X-Pg-Spam-Score: 0.3 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

This is a multi-part message in MIME format.
--------------020909000503050909080006
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

I am need help, about subject "Query cache in  Postgres".
how is it possible to put sql statements cached in postgres ?
I did some tests and I can not get even with improved tuning
parameters in the postgresql.conf.

Regards,

-- 
Assinatura de E-mail padrão Riosoft 20 anos

*Rogerio Pereira *
  rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br>


Respeite o meio-ambiente, não desperdice papel, imprima somente o 
necessário.
Esta mensagem, incluindo os seus anexos, contém informações 
confidenciais destinadas a indivíduo e propósito específicos e é 
protegida por lei. Caso você não seja o destinatário desta mensagem, 
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não 
autorizada das informações presentes neste e-mail. As informações 
contidas nesta mensagem e em seus anexos são de responsabilidade de seu 
autor, não representando idéias, opiniões, pensamentos da Riosoft.


--------------020909000503050909080006
Content-Type: multipart/related;
 boundary="------------070004010004040306050509"


--------------070004010004040306050509
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <pre wrap="">Hi,

I am need help, about subject "Query cache in  Postgres".
how is it possible to put sql statements cached in postgres ?
I did some tests and I can not get even with improved tuning
parameters in the postgresql.conf.

Regards,
</pre>
    <div class="moz-signature">-- <br>
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="author" content="Rafael F. Borges - Marketing Riosoft">
      <meta name="language" content="pt-br">
      <title>Assinatura de E-mail padr&atilde;o Riosoft 20 anos</title>
      <table width="100%" cellpadding="0" cellspacing="0" border="0">
        <tbody>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000"><font style="font-size:13px"
                color="#000000" face="Tahoma"><span id="_AthCaret"></span></font><br>
            </td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td>
              <table width="100%" cellpadding="0" cellspacing="0"
                border="0">
                <tbody>
                  <tr>
                    <td><font style="font-size:20px" color="#000000"
                        face="Tahoma"><b>Rogerio Pereira </b></font></td>
                  </tr>
                  <tr>
                    <td height="20"><font style="font-size:11px"
                        color="#000000" face="Tahoma">&nbsp;<a class="moz-txt-link-abbreviated" href="mailto:rogerio.pereira@riosoft.com.br">rogerio.pereira@riosoft.com.br</a></font></td>
                  </tr>
                  <tr>
                    <td><a href="http://www.riosoft.com.br"
                        target="_blank"><img
                          src="cid:part1.07040907.01020403@riosoft.com.br"
                          alt="Riosoft - Sistemas para Gest&atilde;o
                          Empresarial" width="522" border="0"
                          height="56"></a></td>
                  </tr>
                  <tr>
                    <td height="10"><br>
                    </td>
                  </tr>
                  <tr>
                    <td bgcolor="#0057a6" height="20"><br>
                    </td>
                  </tr>
                  <tr>
                    <td height="25"><font style="font-size:12px"
                        color="#777777" face="Tahoma">Respeite o
                        meio-ambiente, n&atilde;o desperdice papel, imprima
                        somente o necess&aacute;rio.</font></td>
                  </tr>
                  <tr>
                    <td><font style="font-size:10px" color="#777777"
                        face="Tahoma">Esta mensagem, incluindo os seus
                        anexos, cont&eacute;m informa&ccedil;&otilde;es confidenciais
                        destinadas a indiv&iacute;duo e prop&oacute;sito espec&iacute;ficos e
                        &eacute; protegida por lei. Caso voc&ecirc; n&atilde;o seja o
                        destinat&aacute;rio desta mensagem, deve apag&aacute;-la. &Eacute;
                        proibida a utiliza&ccedil;&atilde;o, acesso, c&oacute;pia ou
                        divulga&ccedil;&atilde;o n&atilde;o autorizada das informa&ccedil;&otilde;es
                        presentes neste e-mail. As informa&ccedil;&otilde;es contidas
                        nesta mensagem e em seus anexos s&atilde;o de
                        responsabilidade de seu autor, n&atilde;o representando
                        id&eacute;ias, opini&otilde;es, pensamentos da Riosoft.</font></td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>

--------------070004010004040306050509
Content-Type: image/jpeg;
 name="imgAssinaPadrao.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.07040907.01020403@riosoft.com.br>
Content-Disposition: inline;
 filename="imgAssinaPadrao.jpg"

/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QMpaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjAtYzA2MCA2MS4xMzQ3NzcsIDIw
MTAvMDIvMTItMTc6MzI6MDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4w
LyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5z
OnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYj
IiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzUgV2luZG93cyIgeG1wTU06
SW5zdGFuY2VJRD0ieG1wLmlpZDpCOTMyNzM3NzIzMzcxMUUwQjY1NUYwRjA2MEJEMjVENSIg
eG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpCOTMyNzM3ODIzMzcxMUUwQjY1NUYwRjA2MEJE
MjVENSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOkI5
MzI3Mzc1MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1IiBzdFJlZjpkb2N1bWVudElEPSJ4bXAu
ZGlkOkI5MzI3Mzc2MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1Ii8+IDwvcmRmOkRlc2NyaXB0
aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFk
b2JlAGTAAAAAAf/bAIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4P
EA8ODBMTFBQTExwbGxscHx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAOAIKAwERAAIRAQMR
Af/EAKcAAQABBQEBAAAAAAAAAAAAAAAFAQIDBAYHCAEBAAIDAQAAAAAAAAAAAAAAAAMEAQIF
BhAAAQMDAgQDBAcGBAcAAAAAAgEDBAARBRIGITETB0EiFFFhcTKBkUJSIxUIoWI1dbUWcjMk
NLHR4ZKiY5MRAQACAQIEAgUKBgMBAAAAAAABAgMRBCExEgVBMmFxkYKy8FGBobHB0SITBkJS
YnIjFeEUJKL/2gAMAwEAAhEDEQA/APqmgUCgUCgUCgUCgUCgUCgxuuNtNk44SA2CKpmSoiIi
c1VVrMRqTOjG3NhuGINvtmZipgIkKqopzVEReXGsTWY8GItDYoyjs7lPyyI3J6XV1yokXTq0
29XKajar2X5Orqt48q3x06509Ez7ImfuR5b9Ma+mI9sxCRHlWkJCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHj3fvf+f2weJjYOUsR+Qj
rr5IIlqAdIinmRfG9dftW0pl6pvGujk9z3N8fTFZ0cqxlf1DPwW5zMpXWHW0dbRPTalEk1J5
bc7eFWZ/6UW6Zj7UEf8AcmNYn7Ez2p71Z3J7ib25uYQJ+QpNx5Qh0zR0EVem4KeXjZePDjUW
/wC20rTrx8kmx397X6L821uHKd4R7guMwicY256tsQREYVPTppQ143PjxWo8cbWMPHz6enm3
yTuZy8PJr6OT2RXQBrqOkjYoiKSktkT6VrkRDrTKjMhh4VJpwXBTxBUJP2UmJjmxExPJloyw
tyorpKDbwGacxEkVfqRaTWYYi0SzUZYDlxGz6bjwCf3CJEX6lWnTMsTaGejLxrvT3XzWAyUf
bu3VRvIOgLkmTpQzHqLZttsVumpeaqtdjtuwrkrN7+VyN/vLUtFKc0TAyvd3a0J/c24sh67H
MMEqwHCUkV5ywNISiCIliL7JVJaNtmtGPHXSZnm1idxhib3nWNOTtO3W8ct3A2zkXpzDUI0c
6UZWUIg8qIVy1qt/NzSqe8wV2+SIidVra57Z8czMaJLbG1chjpjZvqINtErmkCI1Jwh0Gqko
N2FR5D5uPjUObPFoS4cE1l2tVVpAb3/g0f8AmmI/qkap9v5vdt8MoNz5fer8UJ9OVQJygUCg
UCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHy9+o
vIpJ7gNxVVVbgxWgVPeaq4X7CSvUdopph1+eXmu631y6fNDqI36kMJAw7MKHhpBux2kba6jg
C3cUsl7altVOezXm2s2ha/21YjSKy5btbtvOZzfA7rmsFHhg+5ON5RURMzVS/DRfspqverPc
NxSmL9Ks625IdjgvfL+raNI5sfbPKP5Lum9lpEk1iMHKnuqRKoIHm42VbcEKt9/SKbeKxHGd
IabG02zzaZ4RrK6Tmdzd2t6FBbkuRMOCkTUcFXS2yi2RVFLITh8Of/CsTTHs8Wumt/v/AAZi
193l010r9zHunC7i7Tbjx8nF5Fw2pIq6IkvlNGyRDbdBF0ki3Ss7fLXd0mL14w03GK20vE1n
m6/vjv8AzDm2sB+VOOQ8fnI6yZLjaqhLwH8FTTwTVxtzqr2va167dXGazp/ytdx3NuivTwi0
auT2t2+azmDj5TaWeINyR9JTIZuK24K38xCg+eyeC8b1Zz7y2O81y0/x+CDBtK5KROO35/F3
vcPuHuraOyMdjJT4HuqaJg5OAdOlkOCuiK/bW6De3O61Q2W1x5ss2iP8ceC5u9zfDjisz+ef
Fxu3+zGb3Jtw9wy8k6mRkAT8dHFUrpbUOsyXVcvdyq3l7nXHk6K1/LHBWx9utkx9drfmlKdm
d353Nw8rsebPcQ34jv5dMJVN1hbaDBFVUVUsVx48K07lgpjmuWI8eMfO27fnveLYpnw4S87X
a8yb3CXbnr3JEgZKxlnlcj/C5lxJV8un210Z3EVwfqaacOSjGCbZ+jXx5p/udsHNbSxMVybm
pE5uY90hjOEWnyDq1WUyThw8KrbDdxmtMRWK6LG+2k4qxrabauv7L9ucu2mH3QGRdSISk4UB
Lo35kULr5rLwW/y1T7lvYmbY+n6Vrt+zmIrk6voe+Vw3aaUrIsR5kaMSp1JJKgJ48EvVLLvI
pmpi/ivr9ERHP28ElcetZt8yN3t/Bo/80xH9UjV1Nv5vdt8Mqm58vvV+KE+nKoE6GyuZlM5S
Pi4TLRypDRvoch1Wm9LZCKiOkXCM/PyS1k40Fn9xhHN5vJCEZ5gGNTTJOSTVyQTgiAiDQkd+
ncbJdfYlBYW8MYmTahrrBt2OslJBtuiIoJ6FQ0IE0W8VK1vGgzhuvAkw+8UlWm4wgbvVadaL
QZaQMRMRIwJeCEN0oLWt24J2QjAvmLpOoxpNh8NLp/KB6gHRrumjVbV4cKC9N0YTW8DjxsKy
2bplIZeYFW2l85AToAhoN0+S9Bt4/KRJ7ROR+pYF0kjrTrJItr/K6IFy91BpNbswTrottyCJ
TVxALovIBk0iqYAehBIx0r5RVS91AHdeCVh+Qcgo7cbpddJDT0chR8tDZKLoAeky4IVrUFU3
VhFNoOq6iPEINvlHfRnUZaRFXVBG0VV8FKgy5jLHBWMywx6mbNd6MRjVoRVQVMiM7FpERG6q
ifRQYhzMmE2RZtluMuoQjrGJySrykirpBsWxcU0QflQVoKf3XglRkgfNzrIRIjTLzhCInoJX
AACVux+VdaJagj394dUZgQm1GRDlFGNHGJTyEIj8wiw2RKpHYbeCXLjyUNyNunHpj40mW8Kv
SVd0Mxm33V/CNRJNCB1fw+RqQJZeaJyoNjKZ1iJt2Rmo6DLYZjlJaQS0o4KDqSxWK31UGBjP
k1GflZRYceMwrY9SJJOXxdPQKEPRZ03JURLXoL4+7MFIeBht8+qbqsaSZeDS7ZVRtxTAUbJU
4ohWv4UFobw28aKaSlRlG3HUdVp0WyFkVJzQ4oIBqAiqqgqqpagqW7tvo0jySVcbXUV2mnXb
AFtTio2JKjfm+dfL76DMO4sQctYjTxOuJbUbbTptIpAjiIrwAraEoKhImq9BiTdWD6TzpyDj
hHETe9Qy8wqAZaENEdAFIVJbakulBa3urGuOPECq7HaBohNlt910uqbgW6INKVrs8FS9/dwV
Qq1uNiTOxzMP8SPNGRrcJDAwKPpuJAaCQrdeKEl6DckTjby0OEgooSW3zU15irWi1v8A6UCZ
mcbDV5JL6NenZ9S9qvwaVVHV/wByUFEzeKWakJJArKXk2iL9zq87W+TjQYR3LgzbYdGUJNyQ
Bxg0QlRRccFkVuicLuGg0GYc1iyc6YyBI/UrDsl1/wBQgK4TfLnoS9Br5LcmKgvOxXHw9a01
1vTlrTyqhKKqoiVhuHErLagLufDtm008/odcFsj0g4bbavIigjjiBoDVfhrtQVTc+EUn09Qq
BGRxXXibdFq7S6XEB1R6ZkK8LCqreg0crvSBHg9aJqdkFIajI080+2TZOrwNxtQ6iDpuo+Xz
ckoNnb+5GcqUlnQTcmI4rTqIDiASgg3ISMR+0VkTnQZj3JhgkuxyfVFY1o8703OgKtDrMSe0
q0hCKXVNV6DGG68CUd6QUlWm4/T6nVadaJEeLQ2SAYCZCZcBJEstAjbswUh9thp8+qbnQ0Ey
8Gl3mjZqQJoJU+VCtdOKUFMvuFrG5WBEeAiZmMyHFJsHHXNTCtWEG2hMlv1V8KDI3ufAuvxm
G5gm/LbByO2KEqkDhKAla3DzCqLfl40EqPJKCtAoFAoFAoFAoPlaWibk77ujbqtLkiFRLiih
F4Knw/Dr1E/4tn7v2vNR/k3fvfY9C7+7MxreywycGOLTsGQCuqCIl23Lgt7fvKNc7tGaYy9M
zzhf7phj9LWI5S1+2+6gb7I5h9VFJeIZkR9XjYxuzdfidq33e3/9cR4WmJa7bP8A+Wf6YmHG
9kNvycpE3UbA3fcxzkWOvtN0C4fWg1c7pmitsev82qp27HNq30/l0Xfp+zWIw265zGXfCE68
zoaN9UbFHGyXUCqVkRfj7Kd3xWvSs1jXQ7XlrS8xbhqs717mj7y3pBxmCVJjcMPTNOt8Rced
K56V8RGyJf41nt2GcGKbX4a8WN/ljNlitOOnB20vcnbpYUDtxuZh5tyK22ys54EbZac6dwcB
zVqRCv8ANa30Vz6YM/HPjnnx0Xr5cPDDeOXDV5VvvbjWx9yRiwWZGTqH1EZ+O4ius2KyIRAv
1e2uxtM056T110+9y91hjDeOi2v3J7vO5mMpiNo7hnNKJS8ejUlbWRJArqLh4a0LVaoO2dFb
XpXwt9SbuPVatLz41enMd0No4vtcxKYmsuS0hIwzBEk6yyNGjSQJ5ksvFV9lcqNjktn0mOGv
P0OlO9x1w6xPHTk8+/TzhpP57M3E8KhDiMuCjq8EIlTUdv8ACicfjXQ7xljSMcc5lR7VinWc
k8ohpdlGjzPdN3JuJfT15ZL7DdP/AJEtSd0nowRX1R7EfbY68829cp/9UEp1clg4nFGhZedv
4KREI/sQag7JX8tpTd4txrD1HtfmNvSdrY6BipzMl2LFb67LZIphw0+ceYrdPGuTvMV63mbR
prMuptMlJpEVnXSIdTNmsQ45PvlYE5J4qvgiVyt5u8e2xzkyTpWPlpC9ixWvbphxm3nH9w7n
cyp/7KCqhHVOIq4nAlH3D8vx1Vyuy4smW1t1ljS2Tyx/LTw9rbcWrrFK+Wn128fZy9qe3t/B
o/8ANMR/VI1en2/m923wypbny+9X4oT6cqgToTcMGTM0tLjIWUiKK3blkoEDn3h/DdS3wsqe
FBCxdn5GK051gayCqzDbAVkPMuAUYnyVQeEVMVHriIFe9kXlQJO1c/JiizJebkOSYEnHy3ic
NSbF9zW2QqoXe0D5V1adX0rQXJtWc9EkNlEjxpZA02MhZkiTrRt8HS4OD+GC9PgnHjw99Buy
ttznpU10TaQZOTgzm0VSujUQWENC8q+ZeiVrcOXGgjI2z8x1WnZrUeW60zKZkuPyXnFlk+iI
OpCbXpBw5De1/rCf27BycQJKTFUWnHEKLGV9ySrIIKIqdVxBJbldbeHKg5mJiNxZPARojSNY
9qM7LfjzNZq91bvi1+H0xRuxOatWpeXvoM47NybiyT6TEVHwx6I0Uh6SSrEmeodJxxwEXzBw
T30GxmdsZifkJDi9N1s5MWRGfdfdHoNMm2ZtCwIECkpNkupV46qCazuOmSThTISh67Huq620
6qi24JgrZtkQoWngV0Ky2VOVBzj+z8m9MXIqy01peBwMakp+yj03G3F6wiJAS9S6IiW4e+gz
v7Yygxw/LobOPmkhWmNTZBGyRnqJTuH+oS3HSXDV9dBfMwGfV6SDItnAenLOcbGQ5HN4DZQO
iZNtqoaXEQ7oq6kS3jQW4nbWcw7rUyO3FffT1gOROqYti3JkddtQdVpSuNtJXH/qG89tqWuy
X8CDrZSnozrauLcWuo7qJfAi0opLbhQWy8RlZuNdjFBgwHFfiPCUd4nEJI8kHi13js28oLp5
0FT25OJ6SetuzuXZyQcSujLbTQKK2T57tL7vfQQEbb+czm04UA2mIrDDElWHDcMjN11h6O2J
hoTQCdZSJUVV4JagmcvtiW9kWZzTIzBSIER2MUl6LbpkRCSE0i6r61RUJKDGm28szIaDGNs4
psQEXH2JLzgGIx+kIFHIEDUKoNnL6rDf3UGkOy8w5rJwWWTOK0w6ZSXpBuONyG3jcIjBNKEj
a2RKCRze3cvIycuZFcFWZHokdii84wbrcbr9RtXQG4oqvAqW52str0DB7YnwZkR9xGGwZenO
ky0ZmiJLUVARIxFV06bKtqCUmgS7kxZIKqIsS0JUTgl1Z50GDN7ecyWWx8oSEY7KG3ObW93G
9YPNIlvY6yl+PJV9tBEf2TkEwyRfUt/mHq+qkq5X9OjPo+drqfpefhqoNldmv6M42LrYtTWk
axSJqux5jfufwkO3S32USgrC2pNi5SNOF5o0bjm48BKXmyJoQq6nD5DF00X6OHOgzFg8q+WX
ekkwkjKY1iJZsjUBfbB5HPmG/T1PJa/1UGk9tfMpDn4troHEy3SWRKIzRxlRZaYd0hos5wZu
35ksq+ygpN2tmJLsgI6N4+IpE8rISHHmX3hfB9slZIEFm6guvQnFS8edBsO7fzM7JJlJQsRn
utCRGAdNwUahuOOKSnoC5GrqoiW5eNBtRoOehvZMIrcchlyklR3nXD5H0xcAwELoqCBWVC52
oNR3b2ZLGT8EIsehlnKdbnE4XUH1Bm8Im1o8yi4elV18R9/CgpkcBncq8cqUMeM8IxWmmgcN
wVRmYEl01NWwXijdgG31UGwe3JyuyDQ2tL2YZyQ3Uroy000Cj8vzXaWyezxoKzIO5CykDJix
EfdiBMZNkXXGkUH3GlaISVs/MgtedOCey9BTbW25mKnnIfcbNHIotmgKvB4pMiS7a6J5E9Qi
J8KDpUoFAoFAoFAoFAoODwnaHbOG3J+fQhNJWszubhn/AJi3L5l5rVvLvsmSnRM/lVMWyx0t
1RHF1eewkDOYiTisgHUiSg0Oiiqi87pZU5WVKr4sk0tFq84WMmOL1ms8pcfiuz22cfhcphm+
p6DLC2klvqucSaLUCot+HHn7atX7hltaLTprXlwVq7LHWs1jlb0pfZGwMPtBqS1jUVG5JIZ6
iIl1IluZKvsqLcbm+aYm3glwbamKNKobd/ZTaO4px5AmlizHV1PGyuhDL7ypZUv9FTYO45cU
aROselDm2GLJOsxpPoZtodoNs7af9THa6sm1us4qmdvYhL8qfBK03G+yZeFp4N8Gzx4uNY4t
7evbLbG7dDuRj6ZjQ6QlNqoHpTkKqnNK12+8yYvLPBnNtMeXzQ5rDfp/2lj5YSTEpKtrqBHi
UxRU/csIr9NWMvdM140109SDH23DWddNfW73LbYwuWwxYifGF+ESJ5CTkSciRfBfelUseW1L
dVZ0ldyY63jS0aw85H9Oe0Al9VCdNm90ZJwtPw4Jq/8AKuhPd82mnD2KEdqw668XoUHauHh4
RzDsMo1CeZKOYteSzZioqgqnFOC86505bTbqmdbL36VYr0xGkIXZfa7AbSnPS8YJCb4aD1ER
8EW6W1KvtqfcbzJmiItPJFg2mPFMzWObf3psLAbvhtR8qzqNglKO+KqJhq+ZEJPBbVrt91fD
OtZbZ9tTLGloQW1Nlbd7fFKejOmbksURWlNTMtN9Nkslk4rXO73+4aYqxOaePhWOcpe39s0m
eiOfOZRkzJ5TeGTKBAIhiNkoSpTfyNp9ppkvtOr9ovs/HhXltpss3cMsbjcx04o8lPx+XH1L
ufcVpE4sM8f4rfdHp+z1vR8NiouKgNQ4wI202KCgjwTgluFeyU61iI0hH73/AINH/mmI/qka
p9v5vdt8Modz5fer8UJ9OVQJygUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCg57eG4XMDBjTUDqNFJBp8fFQNC5L4Le1qq7
rLOOnVHHTn6lnaYa5L9EzpM8vW2IO68DNaRxqUI3S6g55ST4otV/9vttON4r6+DfLsM1J0mq
6RubDMp/uEcX7raKS1U3H7j2WOPP1f28WKbHLbw0cvuDuTHhN21jF18G0L8R81XwbbG6qtcP
J+4N1u56NpjmP6p+WkfWnvgwbeNc1vo+XGUFAwe5d1PdSWjuNxRrdxsitLeT/wBhov4Ir91P
N8Kv9t/bkUt+ruJ/Uy+nlH4qefe5M0dNY/Tx/wD1P4fa9LwuDx+IhtxYbQtNtigigpZERPBE
r1SCtYrGkckjRlAb3/g0f+aYj+qRqn2/m923wyg3Pl96vxQn05VAnKBQKBQKBQKBQKBQKBQK
BQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKCOzmEg
ZvFP4yeCnGkDpKyqhIqLcSEk4oQql0WtZjWNJYtGrzB/trvrGv6cXko8uMnyFKaXqW/eJvn9
VcTd/t7b5+eseqU/+x3kRpFq2j+qOP1NmJ263pMRByeY6Df2ghNCyqovNOofUJPoRKjwftjZ
4516er+6dUd91urxpbJp/bGn1uo2/wBt8Bh3OuLPVll/mSXFJx0v8TpqpfQlkru48VaRpWIi
EFMNazrzt888ZdY2222CA2KCKckTglSJV9AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAo
FAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoP/9k=
--------------070004010004040306050509--

--------------020909000503050909080006--





From akretschmer@spamfence.net Mon Nov  18 16:44:03 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50791=pgsql-performance-ar@postgresql.org>)
 id 1ViRvf-0004Hv-KF
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:44:03 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50791=pgsql-performance-ar@postgresql.org>)
 id 1ViRvf-0006zo-4X
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:44:03 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <andreas@a-kretschmer.de>) id 1ViRve-0006zi-Cm
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:44:02 +0000
Received: from mailout01.ims-firmen.de ([213.174.32.96])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <andreas@a-kretschmer.de>) id 1ViRva-0001VN-UO
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:44:01 +0000
Received: from mailin01.ims-firmen.de ([192.168.1.141])
 by mailout01.ims-firmen.de with esmtp
 (envelope-from <andreas@a-kretschmer.de>) id 1ViRvZ-00037F-ha
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 17:43:57 +0100
Received: from [87.170.145.191] (helo=a-kretschmer.de)
 by mailin01.ims-firmen.de with esmtpsa (TLSv1:AES256-SHA:256)
 (envelope-from <andreas@a-kretschmer.de>) id 1ViRvZ-0005hD-0y
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 17:43:57 +0100
Received: from kretschmer by a-kretschmer.de with local (Exim 4.69)
 (envelope-from <andreas@a-kretschmer.de>) id 1ViRvY-00077Q-1B
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 17:43:56 +0100
Date: Mon, 18 Nov 2013 17:43:56 +0100
From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-performance@postgresql.org
Subject: Re: Query in cache
Message-ID: <20131118164355.GA27277@tux>
References: <528A4271.80806@riosoft.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <528A4271.80806@riosoft.com.br>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
X-GPG-Fingerprint: EE16 3C01 7B9C 10F7 2C8B  3B86 4DB3 D9EE 7F45 84DA
X-Message-Flag: "Windows" is not the answer. "Windows" is the question and
 the answer is "no"!
X-Lugdd: Gerd Kube
X-Info: My name is root. Just root. And I am licensed to kill -9
User-Agent: Mutt/1.5.18 (2008-05-17)
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Rogerio Pereira <rogerio.pereira@riosoft.com.br> wrote:

> Hi,
>
> I am need help, about subject "Query cache in  Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.

No, there isn't something like a query cache. But you can use
materialized views, since 9.3.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



From ktm@rice.edu Mon Nov  18 16:57:22 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50792=pgsql-performance-ar@postgresql.org>)
 id 1ViS8Y-0004pA-CS
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:57:22 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50792=pgsql-performance-ar@postgresql.org>)
 id 1ViS8X-0004Nb-RF
 for pgsql-performance@arkaria.postgresql.org; Mon, 18 Nov 2013 16:57:21 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <ktm@aart.rice.edu>) id 1ViS8W-0004NU-GT
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:57:20 +0000
Received: from proofpoint2.mail.rice.edu ([128.42.201.101] helo=pp2.rice.edu)
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <ktm@aart.rice.edu>) id 1ViS8T-0006zN-Hx
 for pgsql-performance@postgresql.org; Mon, 18 Nov 2013 16:57:19 +0000
Received: from pps.filterd (pp2.rice.edu [127.0.0.1])
 by pp2.rice.edu (8.14.5/8.14.5) with SMTP id rAIGvG09023995;
 Mon, 18 Nov 2013 10:57:16 -0600
Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20])
 by pp2.rice.edu with ESMTP id 1g61dh8nss-1;
 Mon, 18 Nov 2013 10:57:15 -0600
X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel
X-SMTP-Auth: no
X-SMTP-Auth: no
Received: from aart.rice.edu (aart.rice.edu [168.7.56.48])
 by mh1.mail.rice.edu (Postfix) with ESMTP id C438B4602C5;
 Mon, 18 Nov 2013 10:57:15 -0600 (CST)
Received: by aart.rice.edu (Postfix, from userid 18612)
 id BA9AF10033B; Mon, 18 Nov 2013 10:57:15 -0600 (CST)
Date: Mon, 18 Nov 2013 10:57:15 -0600
From: "ktm@rice.edu" <ktm@rice.edu>
To: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query in cache
Message-ID: <20131118165715.GM28440@aart.rice.edu>
References: <528A4271.80806@riosoft.com.br>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <528A4271.80806@riosoft.com.br>
User-Agent: Mutt/1.5.20 (2009-12-10)
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0
 kscore.is_bulkscore=0
 kscore.compositescore=0 circleOfTrustscore=0
 compositescore=0.999264499702524 urlsuspect_oldscore=0.999264499702524
 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0
 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0
 recipient_domain_to_sender_domain_totalscore=0 rbsscore=0.999264499702524
 spamscore=0 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9
 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=7.0.1-1305240000 definitions=main-1311180113
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Mon, Nov 18, 2013 at 02:38:09PM -0200, Rogerio Pereira wrote:
> Hi,
> 
> I am need help, about subject "Query cache in  Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.
> 
> Regards,
> 

Hi Rogerio,

PostgreSQL does not have a query cache. I think you would need to
roll your own.

Regards,
Ken


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



From s_jubeh@yahoo.com Tue Nov  19 00:36:27 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50795=pgsql-performance-ar@postgresql.org>)
 id 1ViZIp-0004Jc-Jl
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 00:36:27 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50795=pgsql-performance-ar@postgresql.org>)
 id 1ViZIo-00006j-Ru
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 00:36:26 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <s_jubeh@yahoo.com>) id 1ViZIn-00006Y-JQ
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 00:36:25 +0000
Received: from nm18-vm0.bullet.mail.ne1.yahoo.com ([98.138.91.37])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <s_jubeh@yahoo.com>) id 1ViZIj-00079h-Lm
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 00:36:23 +0000
Received: from [98.138.100.113] by nm18.bullet.mail.ne1.yahoo.com with NNFMP;
 19 Nov 2013 00:36:20 -0000
Received: from [98.138.101.169] by tm104.bullet.mail.ne1.yahoo.com with NNFMP;
 19 Nov 2013 00:36:20 -0000
Received: from [127.0.0.1] by omp1080.mail.ne1.yahoo.com with NNFMP;
 19 Nov 2013 00:36:20 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 703473.72149.bm@omp1080.mail.ne1.yahoo.com
Received: (qmail 64455 invoked by uid 60001); 19 Nov 2013 00:36:20 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
 t=1384821380; bh=ks4lhTJ8HwEJDltq80C+FcOZN1NdHhCGAuvla2xMKTU=;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
 b=4iZIYhQoUGZ05s8F6aJzKyji9xn/wrLLpLgo+4q0ofWXm5XDHWf/otCq4BeZLCUexCOibWRox4GMupEzm6wGzd2UlPty5sQciYqGMkLhcI6o5rt1SNLwvs6RG4NJTb4vnbCzU4NNmTyktnnkE8SnI6uN7t5g5fHTeqtkXzeVTHk=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
 b=YbII3uONssGsAIddHWZGcfoYTle3w4vIU1hKAQaUWCvHiH1WIsOO1Wm2TMFcfWrlakBwQEwWRdke3P5JBkH4ZE5WujuqArozs+tvaHd0sGy1YzJKTOv7bjQ2aGVuTqQEfGrIsQ4lry3Q9cMrhR+rsVf040epi5sxvhTryecxBq0=;
X-YMail-OSG: _P6RImoVM1kHlhMKWLeKz13sR71PTwFLweChheJYBeVb9qF
 PsagU.tjXrXQT_MSXTDtUtU5bzejXomkf4iPmGMNGIohMJRQbX2eSQbeaYkD
 7c9a318Z9hnBUkfJ3XqnsgwkQwLr9R3yhxc4uLNfZZTEK16AZaCe5EzyLl8I
 3ZO.83rcKOBOORc4oPNtiLAi9U61pCeIVJr3g9FoPwY_4A8NBH12r2tkqtoO
 6KvdQ62fxxazfRbh.XplGvSYZRmdim7hT77_8Sn_uBQ0LxnZR3Kh6hIexTIe
 Ws58v3B2TeQOQFMhwZ65oKyfx1SgOsdifm8sWpLd2juf9d.o99V58Jr9zH74
 k7aMXHqFJoHZh9H9.pOsMwWnmi807mif_4G3Pv8.ouq0STh4xDy3j09N8djX
 P3vHgl97wXW.S40whybRDkWF1IqyA2X7nQcCgpmyecIBlrLIGX4owD3jqsNr
 LdCiD2K90CyYAFLty51tLv2Lq7W_pA6szZBHRV1kLjm43ZE675I198qaa9_W
 lQS0XVbal_Xp1inQmydkM.Cm52PS91QKjMlU__51BtQUBazDjgI8lA8sm8Nw
 Nevuqy3fqvEgLN3NZDQp.1N0E31vTBgANOg5oatk-
Received: from [93.194.241.169] by web122202.mail.ne1.yahoo.com via HTTP;
 Mon, 18 Nov 2013 16:36:20 PST
X-Rocket-MIMEInfo: 002.001,
 SGVsbG8sCgpwZ3Bvb2wgc3VwcG9ydHMgbWVtY2FjaGUuClJlZ2FyZHMKCgoKCk9uIE1vbmRheSwgTm92ZW1iZXIgMTgsIDIwMTMgNjoyOSBQTSwgQW5kcmVhcyBLcmV0c2NobWVyIDxha3JldHNjaG1lckBzcGFtZmVuY2UubmV0PiB3cm90ZToKIApSb2dlcmlvIFBlcmVpcmEgPHJvZ2VyaW8ucGVyZWlyYUByaW9zb2Z0LmNvbS5icj4gd3JvdGU6CgoKPiBIaSwKPgo.IEkgYW0gbmVlZCBoZWxwLCBhYm91dCBzdWJqZWN0ICJRdWVyeSBjYWNoZSBpbsKgIFBvc3RncmVzIi4KPiBob3cgaXMgaXQgcG9zc2libGUgdG8BMAEBAQE-
X-Mailer: YahooMailWebService/0.8.166.601
References: <528A4271.80806@riosoft.com.br> <20131118164355.GA27277@tux>
Message-ID: <1384821380.63647.YahooMailNeo@web122202.mail.ne1.yahoo.com>
Date: Mon, 18 Nov 2013 16:36:20 -0800 (PST)
From: salah jubeh <s_jubeh@yahoo.com>
Reply-To: salah jubeh <s_jubeh@yahoo.com>
Subject: Re: Query in cache
To: Andreas Kretschmer <akretschmer@spamfence.net>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <20131118164355.GA27277@tux>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="251260810-2142066884-1384821380=:63647"
X-Pg-Spam-Score: 0.2 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--251260810-2142066884-1384821380=:63647
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hello,=0A=0Apgpool supports memcache.=0ARegards=0A=0A=0A=0A=0AOn Monday, No=
vember 18, 2013 6:29 PM, Andreas Kretschmer <akretschmer@spamfence.net> wro=
te:=0A =0ARogerio Pereira <rogerio.pereira@riosoft.com.br> wrote:=0A=0A=0A>=
 Hi,=0A>=0A> I am need help, about subject "Query cache in=A0 Postgres".=0A=
> how is it possible to put sql statements cached in postgres ?=0A> I did s=
ome tests and I can not get even with improved tuning=0A> parameters in the=
 postgresql.conf.=0A=0ANo, there isn't something like a query cache. But yo=
u can use=0Amaterialized views, since 9.3.=0A=0A=0AAndreas=0A-- =0AReally, =
I'm not out to destroy Microsoft. That will just be a completely=0Aunintent=
ional side effect.=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 (Linus Torvalds)=0A"If I was god, I would recompile penguin with --enab=
le-fly."=A0  (unknown)=0AKaufbach, Saxony, Germany, Europe.=A0 =A0 =A0 =A0 =
=A0 =A0 =A0 N 51.05082=B0, E 13.56889=B0=0A=0A=0A-- =0ASent via pgsql-perfo=
rmance mailing list (pgsql-performance@postgresql.org)=0ATo make changes to=
 your subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-performance
--251260810-2142066884-1384821380=:63647
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><body><div style=3D"color:#000; background-color:#fff; font-family:He=
lveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;fo=
nt-size:10pt"><div><span>Hello,<br></span></div><div style=3D"color: rgb(0,=
 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvetica Neue,Hel=
vetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-=
style: normal;"><span>pgpool supports memcache.</span></div><div style=3D"c=
olor: rgb(0, 0, 0); font-size: 13.3333px; font-family: HelveticaNeue,Helvet=
ica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transp=
arent; font-style: normal;"><span>Regards<br></span></div><div style=3D"dis=
play: block;" class=3D"yahoo_quoted"> <br> <br> <div style=3D"font-family: =
HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;=
 font-size: 10pt;"> <div style=3D"font-family: HelveticaNeue, Helvetica Neu=
e, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir=
=3D"ltr">
 <font face=3D"Arial" size=3D"2"> On Monday, November 18, 2013 6:29 PM, And=
reas Kretschmer &lt;akretschmer@spamfence.net&gt; wrote:<br> </font> </div>=
  <div class=3D"y_msg_container">Rogerio Pereira &lt;<a shape=3D"rect" ymai=
lto=3D"mailto:rogerio.pereira@riosoft.com.br" href=3D"mailto:rogerio.pereir=
a@riosoft.com.br">rogerio.pereira@riosoft.com.br</a>&gt; wrote:<div class=
=3D"yqt7664869097" id=3D"yqtfd86247"><br clear=3D"none"><br clear=3D"none">=
&gt; Hi,<br clear=3D"none">&gt;<br clear=3D"none">&gt; I am need help, abou=
t subject "Query cache in&nbsp; Postgres".<br clear=3D"none">&gt; how is it=
 possible to put sql statements cached in postgres ?<br clear=3D"none">&gt;=
 I did some tests and I can not get even with improved tuning<br clear=3D"n=
one">&gt; parameters in the postgresql.conf.</div><br clear=3D"none"><br cl=
ear=3D"none">No, there isn't something like a query cache. But you can use<=
br clear=3D"none">materialized views, since 9.3.<br clear=3D"none"><br clea=
r=3D"none"><br
 clear=3D"none">Andreas<br clear=3D"none">-- <br clear=3D"none">Really, I'm=
 not out to destroy Microsoft. That will just be a completely<br clear=3D"n=
one">unintentional side effect.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &n=
bsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Linus Torvald=
s)<br clear=3D"none">"If I was god, I would recompile penguin with --enable=
-fly."&nbsp;  (unknown)<br clear=3D"none">Kaufbach, Saxony, Germany, Europe=
.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N 51.05082=B0, E 13.56889=
=B0<br clear=3D"none"><br clear=3D"none"><br clear=3D"none">-- <br clear=3D=
"none">Sent via pgsql-performance mailing list (<a shape=3D"rect" ymailto=
=3D"mailto:pgsql-performance@postgresql.org" href=3D"mailto:pgsql-performan=
ce@postgresql.org">pgsql-performance@postgresql.org</a>)<br clear=3D"none">=
To make changes to your subscription:<br clear=3D"none"><a shape=3D"rect" h=
ref=3D"http://www.postgresql.org/mailpref/pgsql-performance"
 target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-performance</a>=
<div class=3D"yqt7664869097" id=3D"yqtfd21047"><br clear=3D"none"></div><br=
><br></div>  </div> </div>  </div> </div></body></html>
--251260810-2142066884-1384821380=:63647--




From gray.ru@gmail.com Tue Nov  19 01:37:40 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50796=pgsql-performance-ar@postgresql.org>)
 id 1ViaG3-0006Aw-Um
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 01:37:40 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50796=pgsql-performance-ar@postgresql.org>)
 id 1ViaG2-0001CI-B8
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 01:37:38 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <gray.ru@gmail.com>) id 1ViaFz-0001C9-VZ
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 01:37:36 +0000
Received: from mail-pd0-x234.google.com ([2607:f8b0:400e:c02::234])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <gray.ru@gmail.com>) id 1ViaFw-0008GN-If
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 01:37:34 +0000
Received: by mail-pd0-f180.google.com with SMTP id q10so2175787pdj.39
 for <pgsql-performance@postgresql.org>; Mon, 18 Nov 2013 17:37:31 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:in-reply-to:references:from:date:message-id:subject:to
 :cc:content-type;
 bh=w3w+Vyv6ejVgltKvwakiCYzEr/+K2kHMmWmv1HbKFC0=;
 b=wawfZ3vKC9/WJ4KIDG72nwJ5nf6OOCSFnoxZ6exzjn7rB2wct3Dw/p5h73mxxzF4uD
 xHAfPrxHypZ8Btj5xxanSAB+0p6AnR10W0dU/4g//XI37RiL9y1NIgpMKjEt/wzFUj63
 qRWop5jG/JFIXfwxyL8TO+BwrcbPGcFlMBkNLTMxLJsWU3EWAEF/5T8pkmCKcS4Bs+eI
 u2vPszt9dQZL/JhfhC/3KKQhA0YM4NFFR1/E4/rtWiBQdy8ZYz0usJzxAyYDAuuMvbkH
 YsBcJ4eZYlZSi6U+0oPm70LAfOt5zioq2npIHIJVP+cyOWVBPITMNDXspD8kuBe5qR5J
 G2eA==
X-Received: by 10.68.197.129 with SMTP id iu1mr5584794pbc.139.1384825051342;
 Mon, 18 Nov 2013 17:37:31 -0800 (PST)
MIME-Version: 1.0
Received: by 10.68.66.33 with HTTP; Mon, 18 Nov 2013 17:37:11 -0800 (PST)
In-Reply-To: <528A4271.80806@riosoft.com.br>
References: <528A4271.80806@riosoft.com.br>
From: Sergey Konoplev <gray.ru@gmail.com>
Date: Mon, 18 Nov 2013 17:37:11 -0800
Message-ID: 
 <CAL_0b1t40UkK2JFBiR00oU1iXqbmvCe4dK+m1JpMWqDEHubaag@mail.gmail.com>
Subject: Re: Query in cache
To: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

2013/11/18 Rogerio Pereira <rogerio.pereira@riosoft.com.br>
> I am need help, about subject "Query cache in  Postgres".
> how is it possible to put sql statements cached in postgres ?
> I did some tests and I can not get even with improved tuning
> parameters in the postgresql.conf.

Are you talking about prepared statements or about query result caching?

If former then you need to look at the PREPARE for execute statement
[1], though it is probably implemented in your data adapter, for
example like it is in DBD::Pg [2]. Also take a look at the pre_prepare
module [3], that can conveniently be used with pgbouncer.

If later then there is an extension named pgmemcache [4] that will
allow you to interact with memcached directly from postgres, so you
could implement cashing in stored functions, for example. However my
advice is to use application level caching with memcached in this
case, not the database level one.

[1] http://www.postgresql.org/docs/9.3/static/sql-prepare.html
[2] http://search.cpan.org/dist/DBD-Pg/Pg.pm#prepare
[3] https://github.com/dimitri/preprepare
[4] https://github.com/ohmu/pgmemcache/

-- 
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray.ru@gmail.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



From ktm@rice.edu Tue Nov  19 14:00:51 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50797=pgsql-performance-ar@postgresql.org>)
 id 1VilrH-0006kU-GP
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 14:00:51 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50797=pgsql-performance-ar@postgresql.org>)
 id 1VilrH-0002My-0G
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 14:00:51 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <ktm@aart.rice.edu>) id 1VilrG-0002Ms-1u
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 14:00:50 +0000
Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu)
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <ktm@aart.rice.edu>) id 1VilrC-0005mq-Q6
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 14:00:48 +0000
Received: from pps.filterd (pp1.rice.edu [127.0.0.1])
 by pp1.rice.edu (8.14.5/8.14.5) with SMTP id rAJDufIG011537;
 Tue, 19 Nov 2013 08:00:45 -0600
Received: from mh1.mail.rice.edu (mh1.mail.rice.edu [128.42.201.20])
 by pp1.rice.edu with ESMTP id 1g53xa1y1m-1;
 Tue, 19 Nov 2013 08:00:44 -0600
X-Virus-Scanned: by amavis-2.7.0 at mh1.mail.rice.edu, auth channel
X-SMTP-Auth: no
X-SMTP-Auth: no
X-SMTP-Auth: no
Received: from aart.rice.edu (aart.rice.edu [168.7.56.48])
 by mh1.mail.rice.edu (Postfix) with ESMTP id 9DE95460200;
 Tue, 19 Nov 2013 08:00:44 -0600 (CST)
Received: by aart.rice.edu (Postfix, from userid 18612)
 id 93DDD1002D0; Tue, 19 Nov 2013 08:00:44 -0600 (CST)
Date: Tue, 19 Nov 2013 08:00:44 -0600
From: "ktm@rice.edu" <ktm@rice.edu>
To: salah jubeh <s_jubeh@yahoo.com>
Cc: Andreas Kretschmer <akretschmer@spamfence.net>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Query in cache
Message-ID: <20131119140044.GN28440@aart.rice.edu>
References: <528A4271.80806@riosoft.com.br> <20131118164355.GA27277@tux>
 <1384821380.63647.YahooMailNeo@web122202.mail.ne1.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1384821380.63647.YahooMailNeo@web122202.mail.ne1.yahoo.com>
User-Agent: Mutt/1.5.20 (2009-12-10)
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0
 kscore.is_bulkscore=0
 kscore.compositescore=0 circleOfTrustscore=0
 compositescore=0.995372078356457 urlsuspect_oldscore=0.995372078356457
 suspectscore=0 recipient_domain_to_sender_totalscore=0 phishscore=0
 bulkscore=0 kscore.is_spamscore=0 recipient_to_sender_totalscore=0
 recipient_domain_to_sender_domain_totalscore=196
 rbsscore=0.995372078356457 spamscore=0
 recipient_to_sender_domain_totalscore=0 urlsuspectscore=0.9 adultscore=0
 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1305240000
 definitions=main-1311190060
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Mon, Nov 18, 2013 at 04:36:20PM -0800, salah jubeh wrote:
> Hello,
> 
> pgpool supports memcache.
> Regards
> 
Very cool. I had missed that in the release announcement.

Regards,
Ken


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



From rogerio.pereira@riosoft.com.br Tue Nov  19 15:50:46 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50798=pgsql-performance-ar@postgresql.org>)
 id 1VinZd-0002Ya-Su
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 15:50:46 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50798=pgsql-performance-ar@postgresql.org>)
 id 1VinZd-0007JZ-E5
 for pgsql-performance@arkaria.postgresql.org; Tue, 19 Nov 2013 15:50:45 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1VinZc-0007JT-Bm
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 15:50:44 +0000
Received: from riosoftweb1.riosoft.com.br ([186.237.128.40]
 helo=emailserver.riosoft.com.br)
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1VinZO-0002b8-7o
 for pgsql-performance@postgresql.org; Tue, 19 Nov 2013 15:50:44 +0000
Received: from [171.171.0.203] ([201.91.189.254]) by riosoft.com.br with
 MailEnable ESMTP; Tue, 19 Nov 2013 13:50:24 -0200
Message-ID: <528B88C0.402@riosoft.com.br>
Date: Tue, 19 Nov 2013 13:50:24 -0200
From: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: "ktm@rice.edu" <ktm@rice.edu>, salah jubeh <s_jubeh@yahoo.com>
CC: Andreas Kretschmer <akretschmer@spamfence.net>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Query in cache
References: <528A4271.80806@riosoft.com.br> <20131118164355.GA27277@tux>
 <1384821380.63647.YahooMailNeo@web122202.mail.ne1.yahoo.com>
 <20131119140044.GN28440@aart.rice.edu>
In-Reply-To: <20131119140044.GN28440@aart.rice.edu>
Content-Type: multipart/alternative;
 boundary="------------040407040301080503060001"
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

This is a multi-part message in MIME format.
--------------040407040301080503060001
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

Is possible send howto to active 'feature' ?

Regards,

Rogerio

Em 19/11/2013 12:00, ktm@rice.edu escreveu:
> On Mon, Nov 18, 2013 at 04:36:20PM -0800, salah jubeh wrote:
>> Hello,
>>
>> pgpool supports memcache.
>> Regards
>>
> Very cool. I had missed that in the release announcement.
>
> Regards,
> Ken
>
>


-- 
Assinatura de E-mail padrão Riosoft 20 anos

*Rogerio Pereira *
Dba | Tel. 55 (17) 3215-9199 | rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br>


Respeite o meio-ambiente, não desperdice papel, imprima somente o 
necessário.
Esta mensagem, incluindo os seus anexos, contém informações 
confidenciais destinadas a indivíduo e propósito específicos e é 
protegida por lei. Caso você não seja o destinatário desta mensagem, 
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não 
autorizada das informações presentes neste e-mail. As informações 
contidas nesta mensagem e em seus anexos são de responsabilidade de seu 
autor, não representando idéias, opiniões, pensamentos da Riosoft.


--------------040407040301080503060001
Content-Type: multipart/related;
 boundary="------------040609040906060602020400"


--------------040609040906060602020400
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hi,<br>
      <br>
      Is possible send howto to active 'feature' ?<br>
      <br>
      Regards,<br>
      <br>
      Rogerio<br>
      <br>
      Em 19/11/2013 12:00, <a class="moz-txt-link-abbreviated" href="mailto:ktm@rice.edu">ktm@rice.edu</a> escreveu:<br>
    </div>
    <blockquote cite="mid:20131119140044.GN28440@aart.rice.edu"
      type="cite">
      <pre wrap="">On Mon, Nov 18, 2013 at 04:36:20PM -0800, salah jubeh wrote:
</pre>
      <blockquote type="cite">
        <pre wrap="">Hello,

pgpool supports memcache.
Regards

</pre>
      </blockquote>
      <pre wrap="">Very cool. I had missed that in the release announcement.

Regards,
Ken


</pre>
    </blockquote>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="author" content="Rafael F. Borges - Marketing Riosoft">
      <meta name="language" content="pt-br">
      <title>Assinatura de E-mail padr&atilde;o Riosoft 20 anos</title>
      <table width="100%" cellpadding="0" cellspacing="0" border="0">
        <tbody>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000"><font style="font-size:13px"
                color="#000000" face="Tahoma"><span id="_AthCaret"></span></font><br>
            </td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td>
              <table width="100%" cellpadding="0" cellspacing="0"
                border="0">
                <tbody>
                  <tr>
                    <td><font style="font-size:20px" color="#000000"
                        face="Tahoma"><b>Rogerio Pereira </b></font></td>
                  </tr>
                  <tr>
                    <td height="20"><font style="font-size:11px"
                        color="#000000" face="Tahoma">Dba | Tel. 55 (17)
                        3215-9199 | <a class="moz-txt-link-abbreviated" href="mailto:rogerio.pereira@riosoft.com.br">rogerio.pereira@riosoft.com.br</a></font></td>
                  </tr>
                  <tr>
                    <td><a href="http://www.riosoft.com.br"
                        target="_blank"><img
                          src="cid:part1.09040701.01060709@riosoft.com.br"
                          alt="Riosoft - Sistemas para Gest&atilde;o
                          Empresarial" width="522" border="0"
                          height="56"></a></td>
                  </tr>
                  <tr>
                    <td height="10"><br>
                    </td>
                  </tr>
                  <tr>
                    <td bgcolor="#0057a6" height="20"><br>
                    </td>
                  </tr>
                  <tr>
                    <td height="25"><font style="font-size:12px"
                        color="#777777" face="Tahoma">Respeite o
                        meio-ambiente, n&atilde;o desperdice papel, imprima
                        somente o necess&aacute;rio.</font></td>
                  </tr>
                  <tr>
                    <td><font style="font-size:10px" color="#777777"
                        face="Tahoma">Esta mensagem, incluindo os seus
                        anexos, cont&eacute;m informa&ccedil;&otilde;es confidenciais
                        destinadas a indiv&iacute;duo e prop&oacute;sito espec&iacute;ficos e
                        &eacute; protegida por lei. Caso voc&ecirc; n&atilde;o seja o
                        destinat&aacute;rio desta mensagem, deve apag&aacute;-la. &Eacute;
                        proibida a utiliza&ccedil;&atilde;o, acesso, c&oacute;pia ou
                        divulga&ccedil;&atilde;o n&atilde;o autorizada das informa&ccedil;&otilde;es
                        presentes neste e-mail. As informa&ccedil;&otilde;es contidas
                        nesta mensagem e em seus anexos s&atilde;o de
                        responsabilidade de seu autor, n&atilde;o representando
                        id&eacute;ias, opini&otilde;es, pensamentos da Riosoft.</font></td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>

--------------040609040906060602020400
Content-Type: image/jpeg;
 name="imgAssinaPadrao.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.09040701.01060709@riosoft.com.br>
Content-Disposition: inline;
 filename="imgAssinaPadrao.jpg"

/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QMpaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjAtYzA2MCA2MS4xMzQ3NzcsIDIw
MTAvMDIvMTItMTc6MzI6MDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4w
LyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5z
OnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYj
IiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzUgV2luZG93cyIgeG1wTU06
SW5zdGFuY2VJRD0ieG1wLmlpZDpCOTMyNzM3NzIzMzcxMUUwQjY1NUYwRjA2MEJEMjVENSIg
eG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpCOTMyNzM3ODIzMzcxMUUwQjY1NUYwRjA2MEJE
MjVENSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOkI5
MzI3Mzc1MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1IiBzdFJlZjpkb2N1bWVudElEPSJ4bXAu
ZGlkOkI5MzI3Mzc2MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1Ii8+IDwvcmRmOkRlc2NyaXB0
aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFk
b2JlAGTAAAAAAf/bAIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4P
EA8ODBMTFBQTExwbGxscHx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAOAIKAwERAAIRAQMR
Af/EAKcAAQABBQEBAAAAAAAAAAAAAAAFAQIDBAYHCAEBAAIDAQAAAAAAAAAAAAAAAAMEAQIF
BhAAAQMDAgQDBAcGBAcAAAAAAgEDBAARBRIGITETB0EiFFFhcTKBkUJSIxUIoWI1dbUWcjMk
NLHR4ZKiY5MRAQACAQIEAgUKBgMBAAAAAAABAgMRBCExEgVBMmFxkYKy8FGBobHB0SITBkJS
YnIjFeEUJKL/2gAMAwEAAhEDEQA/APqmgUCgUCgUCgUCgUCgUCgxuuNtNk44SA2CKpmSoiIi
c1VVrMRqTOjG3NhuGINvtmZipgIkKqopzVEReXGsTWY8GItDYoyjs7lPyyI3J6XV1yokXTq0
29XKajar2X5Orqt48q3x06509Ez7ImfuR5b9Ma+mI9sxCRHlWkJCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHj3fvf+f2weJjYOUsR+Qj
rr5IIlqAdIinmRfG9dftW0pl6pvGujk9z3N8fTFZ0cqxlf1DPwW5zMpXWHW0dbRPTalEk1J5
bc7eFWZ/6UW6Zj7UEf8AcmNYn7Ez2p71Z3J7ib25uYQJ+QpNx5Qh0zR0EVem4KeXjZePDjUW
/wC20rTrx8kmx397X6L821uHKd4R7guMwicY256tsQREYVPTppQ143PjxWo8cbWMPHz6enm3
yTuZy8PJr6OT2RXQBrqOkjYoiKSktkT6VrkRDrTKjMhh4VJpwXBTxBUJP2UmJjmxExPJloyw
tyorpKDbwGacxEkVfqRaTWYYi0SzUZYDlxGz6bjwCf3CJEX6lWnTMsTaGejLxrvT3XzWAyUf
bu3VRvIOgLkmTpQzHqLZttsVumpeaqtdjtuwrkrN7+VyN/vLUtFKc0TAyvd3a0J/c24sh67H
MMEqwHCUkV5ywNISiCIliL7JVJaNtmtGPHXSZnm1idxhib3nWNOTtO3W8ct3A2zkXpzDUI0c
6UZWUIg8qIVy1qt/NzSqe8wV2+SIidVra57Z8czMaJLbG1chjpjZvqINtErmkCI1Jwh0Gqko
N2FR5D5uPjUObPFoS4cE1l2tVVpAb3/g0f8AmmI/qkap9v5vdt8MoNz5fer8UJ9OVQJygUCg
UCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHy9+o
vIpJ7gNxVVVbgxWgVPeaq4X7CSvUdopph1+eXmu631y6fNDqI36kMJAw7MKHhpBux2kba6jg
C3cUsl7altVOezXm2s2ha/21YjSKy5btbtvOZzfA7rmsFHhg+5ON5RURMzVS/DRfspqverPc
NxSmL9Ks625IdjgvfL+raNI5sfbPKP5Lum9lpEk1iMHKnuqRKoIHm42VbcEKt9/SKbeKxHGd
IabG02zzaZ4RrK6Tmdzd2t6FBbkuRMOCkTUcFXS2yi2RVFLITh8Of/CsTTHs8Wumt/v/AAZi
193l010r9zHunC7i7Tbjx8nF5Fw2pIq6IkvlNGyRDbdBF0ki3Ss7fLXd0mL14w03GK20vE1n
m6/vjv8AzDm2sB+VOOQ8fnI6yZLjaqhLwH8FTTwTVxtzqr2va167dXGazp/ytdx3NuivTwi0
auT2t2+azmDj5TaWeINyR9JTIZuK24K38xCg+eyeC8b1Zz7y2O81y0/x+CDBtK5KROO35/F3
vcPuHuraOyMdjJT4HuqaJg5OAdOlkOCuiK/bW6De3O61Q2W1x5ss2iP8ceC5u9zfDjisz+ef
Fxu3+zGb3Jtw9wy8k6mRkAT8dHFUrpbUOsyXVcvdyq3l7nXHk6K1/LHBWx9utkx9drfmlKdm
d353Nw8rsebPcQ34jv5dMJVN1hbaDBFVUVUsVx48K07lgpjmuWI8eMfO27fnveLYpnw4S87X
a8yb3CXbnr3JEgZKxlnlcj/C5lxJV8un210Z3EVwfqaacOSjGCbZ+jXx5p/udsHNbSxMVybm
pE5uY90hjOEWnyDq1WUyThw8KrbDdxmtMRWK6LG+2k4qxrabauv7L9ucu2mH3QGRdSISk4UB
Lo35kULr5rLwW/y1T7lvYmbY+n6Vrt+zmIrk6voe+Vw3aaUrIsR5kaMSp1JJKgJ48EvVLLvI
pmpi/ivr9ERHP28ElcetZt8yN3t/Bo/80xH9UjV1Nv5vdt8Mqm58vvV+KE+nKoE6GyuZlM5S
Pi4TLRypDRvoch1Wm9LZCKiOkXCM/PyS1k40Fn9xhHN5vJCEZ5gGNTTJOSTVyQTgiAiDQkd+
ncbJdfYlBYW8MYmTahrrBt2OslJBtuiIoJ6FQ0IE0W8VK1vGgzhuvAkw+8UlWm4wgbvVadaL
QZaQMRMRIwJeCEN0oLWt24J2QjAvmLpOoxpNh8NLp/KB6gHRrumjVbV4cKC9N0YTW8DjxsKy
2bplIZeYFW2l85AToAhoN0+S9Bt4/KRJ7ROR+pYF0kjrTrJItr/K6IFy91BpNbswTrottyCJ
TVxALovIBk0iqYAehBIx0r5RVS91AHdeCVh+Qcgo7cbpddJDT0chR8tDZKLoAeky4IVrUFU3
VhFNoOq6iPEINvlHfRnUZaRFXVBG0VV8FKgy5jLHBWMywx6mbNd6MRjVoRVQVMiM7FpERG6q
ifRQYhzMmE2RZtluMuoQjrGJySrykirpBsWxcU0QflQVoKf3XglRkgfNzrIRIjTLzhCInoJX
AACVux+VdaJagj394dUZgQm1GRDlFGNHGJTyEIj8wiw2RKpHYbeCXLjyUNyNunHpj40mW8Kv
SVd0Mxm33V/CNRJNCB1fw+RqQJZeaJyoNjKZ1iJt2Rmo6DLYZjlJaQS0o4KDqSxWK31UGBjP
k1GflZRYceMwrY9SJJOXxdPQKEPRZ03JURLXoL4+7MFIeBht8+qbqsaSZeDS7ZVRtxTAUbJU
4ohWv4UFobw28aKaSlRlG3HUdVp0WyFkVJzQ4oIBqAiqqgqqpagqW7tvo0jySVcbXUV2mnXb
AFtTio2JKjfm+dfL76DMO4sQctYjTxOuJbUbbTptIpAjiIrwAraEoKhImq9BiTdWD6TzpyDj
hHETe9Qy8wqAZaENEdAFIVJbakulBa3urGuOPECq7HaBohNlt910uqbgW6INKVrs8FS9/dwV
Qq1uNiTOxzMP8SPNGRrcJDAwKPpuJAaCQrdeKEl6DckTjby0OEgooSW3zU15irWi1v8A6UCZ
mcbDV5JL6NenZ9S9qvwaVVHV/wByUFEzeKWakJJArKXk2iL9zq87W+TjQYR3LgzbYdGUJNyQ
Bxg0QlRRccFkVuicLuGg0GYc1iyc6YyBI/UrDsl1/wBQgK4TfLnoS9Br5LcmKgvOxXHw9a01
1vTlrTyqhKKqoiVhuHErLagLufDtm008/odcFsj0g4bbavIigjjiBoDVfhrtQVTc+EUn09Qq
BGRxXXibdFq7S6XEB1R6ZkK8LCqreg0crvSBHg9aJqdkFIajI080+2TZOrwNxtQ6iDpuo+Xz
ckoNnb+5GcqUlnQTcmI4rTqIDiASgg3ISMR+0VkTnQZj3JhgkuxyfVFY1o8703OgKtDrMSe0
q0hCKXVNV6DGG68CUd6QUlWm4/T6nVadaJEeLQ2SAYCZCZcBJEstAjbswUh9thp8+qbnQ0Ey
8Gl3mjZqQJoJU+VCtdOKUFMvuFrG5WBEeAiZmMyHFJsHHXNTCtWEG2hMlv1V8KDI3ufAuvxm
G5gm/LbByO2KEqkDhKAla3DzCqLfl40EqPJKCtAoFAoFAoFAoPlaWibk77ujbqtLkiFRLiih
F4Knw/Dr1E/4tn7v2vNR/k3fvfY9C7+7MxreywycGOLTsGQCuqCIl23Lgt7fvKNc7tGaYy9M
zzhf7phj9LWI5S1+2+6gb7I5h9VFJeIZkR9XjYxuzdfidq33e3/9cR4WmJa7bP8A+Wf6YmHG
9kNvycpE3UbA3fcxzkWOvtN0C4fWg1c7pmitsev82qp27HNq30/l0Xfp+zWIw265zGXfCE68
zoaN9UbFHGyXUCqVkRfj7Kd3xWvSs1jXQ7XlrS8xbhqs717mj7y3pBxmCVJjcMPTNOt8Rced
K56V8RGyJf41nt2GcGKbX4a8WN/ljNlitOOnB20vcnbpYUDtxuZh5tyK22ys54EbZac6dwcB
zVqRCv8ANa30Vz6YM/HPjnnx0Xr5cPDDeOXDV5VvvbjWx9yRiwWZGTqH1EZ+O4ius2KyIRAv
1e2uxtM056T110+9y91hjDeOi2v3J7vO5mMpiNo7hnNKJS8ejUlbWRJArqLh4a0LVaoO2dFb
XpXwt9SbuPVatLz41enMd0No4vtcxKYmsuS0hIwzBEk6yyNGjSQJ5ksvFV9lcqNjktn0mOGv
P0OlO9x1w6xPHTk8+/TzhpP57M3E8KhDiMuCjq8EIlTUdv8ACicfjXQ7xljSMcc5lR7VinWc
k8ohpdlGjzPdN3JuJfT15ZL7DdP/AJEtSd0nowRX1R7EfbY68829cp/9UEp1clg4nFGhZedv
4KREI/sQag7JX8tpTd4txrD1HtfmNvSdrY6BipzMl2LFb67LZIphw0+ceYrdPGuTvMV63mbR
prMuptMlJpEVnXSIdTNmsQ45PvlYE5J4qvgiVyt5u8e2xzkyTpWPlpC9ixWvbphxm3nH9w7n
cyp/7KCqhHVOIq4nAlH3D8vx1Vyuy4smW1t1ljS2Tyx/LTw9rbcWrrFK+Wn128fZy9qe3t/B
o/8ANMR/VI1en2/m923wypbny+9X4oT6cqgToTcMGTM0tLjIWUiKK3blkoEDn3h/DdS3wsqe
FBCxdn5GK051gayCqzDbAVkPMuAUYnyVQeEVMVHriIFe9kXlQJO1c/JiizJebkOSYEnHy3ic
NSbF9zW2QqoXe0D5V1adX0rQXJtWc9EkNlEjxpZA02MhZkiTrRt8HS4OD+GC9PgnHjw99Buy
ttznpU10TaQZOTgzm0VSujUQWENC8q+ZeiVrcOXGgjI2z8x1WnZrUeW60zKZkuPyXnFlk+iI
OpCbXpBw5De1/rCf27BycQJKTFUWnHEKLGV9ySrIIKIqdVxBJbldbeHKg5mJiNxZPARojSNY
9qM7LfjzNZq91bvi1+H0xRuxOatWpeXvoM47NybiyT6TEVHwx6I0Uh6SSrEmeodJxxwEXzBw
T30GxmdsZifkJDi9N1s5MWRGfdfdHoNMm2ZtCwIECkpNkupV46qCazuOmSThTISh67Huq620
6qi24JgrZtkQoWngV0Ky2VOVBzj+z8m9MXIqy01peBwMakp+yj03G3F6wiJAS9S6IiW4e+gz
v7Yygxw/LobOPmkhWmNTZBGyRnqJTuH+oS3HSXDV9dBfMwGfV6SDItnAenLOcbGQ5HN4DZQO
iZNtqoaXEQ7oq6kS3jQW4nbWcw7rUyO3FffT1gOROqYti3JkddtQdVpSuNtJXH/qG89tqWuy
X8CDrZSnozrauLcWuo7qJfAi0opLbhQWy8RlZuNdjFBgwHFfiPCUd4nEJI8kHi13js28oLp5
0FT25OJ6SetuzuXZyQcSujLbTQKK2T57tL7vfQQEbb+czm04UA2mIrDDElWHDcMjN11h6O2J
hoTQCdZSJUVV4JagmcvtiW9kWZzTIzBSIER2MUl6LbpkRCSE0i6r61RUJKDGm28szIaDGNs4
psQEXH2JLzgGIx+kIFHIEDUKoNnL6rDf3UGkOy8w5rJwWWTOK0w6ZSXpBuONyG3jcIjBNKEj
a2RKCRze3cvIycuZFcFWZHokdii84wbrcbr9RtXQG4oqvAqW52str0DB7YnwZkR9xGGwZenO
ky0ZmiJLUVARIxFV06bKtqCUmgS7kxZIKqIsS0JUTgl1Z50GDN7ecyWWx8oSEY7KG3ObW93G
9YPNIlvY6yl+PJV9tBEf2TkEwyRfUt/mHq+qkq5X9OjPo+drqfpefhqoNldmv6M42LrYtTWk
axSJqux5jfufwkO3S32USgrC2pNi5SNOF5o0bjm48BKXmyJoQq6nD5DF00X6OHOgzFg8q+WX
ekkwkjKY1iJZsjUBfbB5HPmG/T1PJa/1UGk9tfMpDn4troHEy3SWRKIzRxlRZaYd0hos5wZu
35ksq+ygpN2tmJLsgI6N4+IpE8rISHHmX3hfB9slZIEFm6guvQnFS8edBsO7fzM7JJlJQsRn
utCRGAdNwUahuOOKSnoC5GrqoiW5eNBtRoOehvZMIrcchlyklR3nXD5H0xcAwELoqCBWVC52
oNR3b2ZLGT8EIsehlnKdbnE4XUH1Bm8Im1o8yi4elV18R9/CgpkcBncq8cqUMeM8IxWmmgcN
wVRmYEl01NWwXijdgG31UGwe3JyuyDQ2tL2YZyQ3Uroy000Cj8vzXaWyezxoKzIO5CykDJix
EfdiBMZNkXXGkUH3GlaISVs/MgtedOCey9BTbW25mKnnIfcbNHIotmgKvB4pMiS7a6J5E9Qi
J8KDpUoFAoFAoFAoFAoODwnaHbOG3J+fQhNJWszubhn/AJi3L5l5rVvLvsmSnRM/lVMWyx0t
1RHF1eewkDOYiTisgHUiSg0Oiiqi87pZU5WVKr4sk0tFq84WMmOL1ms8pcfiuz22cfhcphm+
p6DLC2klvqucSaLUCot+HHn7atX7hltaLTprXlwVq7LHWs1jlb0pfZGwMPtBqS1jUVG5JIZ6
iIl1IluZKvsqLcbm+aYm3glwbamKNKobd/ZTaO4px5AmlizHV1PGyuhDL7ypZUv9FTYO45cU
aROselDm2GLJOsxpPoZtodoNs7af9THa6sm1us4qmdvYhL8qfBK03G+yZeFp4N8Gzx4uNY4t
7evbLbG7dDuRj6ZjQ6QlNqoHpTkKqnNK12+8yYvLPBnNtMeXzQ5rDfp/2lj5YSTEpKtrqBHi
UxRU/csIr9NWMvdM140109SDH23DWddNfW73LbYwuWwxYifGF+ESJ5CTkSciRfBfelUseW1L
dVZ0ldyY63jS0aw85H9Oe0Al9VCdNm90ZJwtPw4Jq/8AKuhPd82mnD2KEdqw668XoUHauHh4
RzDsMo1CeZKOYteSzZioqgqnFOC86505bTbqmdbL36VYr0xGkIXZfa7AbSnPS8YJCb4aD1ER
8EW6W1KvtqfcbzJmiItPJFg2mPFMzWObf3psLAbvhtR8qzqNglKO+KqJhq+ZEJPBbVrt91fD
OtZbZ9tTLGloQW1Nlbd7fFKejOmbksURWlNTMtN9Nkslk4rXO73+4aYqxOaePhWOcpe39s0m
eiOfOZRkzJ5TeGTKBAIhiNkoSpTfyNp9ppkvtOr9ovs/HhXltpss3cMsbjcx04o8lPx+XH1L
ufcVpE4sM8f4rfdHp+z1vR8NiouKgNQ4wI202KCgjwTgluFeyU61iI0hH73/AINH/mmI/qka
p9v5vdt8Modz5fer8UJ9OVQJygUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCg57eG4XMDBjTUDqNFJBp8fFQNC5L4Le1qq7
rLOOnVHHTn6lnaYa5L9EzpM8vW2IO68DNaRxqUI3S6g55ST4otV/9vttON4r6+DfLsM1J0mq
6RubDMp/uEcX7raKS1U3H7j2WOPP1f28WKbHLbw0cvuDuTHhN21jF18G0L8R81XwbbG6qtcP
J+4N1u56NpjmP6p+WkfWnvgwbeNc1vo+XGUFAwe5d1PdSWjuNxRrdxsitLeT/wBhov4Ir91P
N8Kv9t/bkUt+ruJ/Uy+nlH4qefe5M0dNY/Tx/wD1P4fa9LwuDx+IhtxYbQtNtigigpZERPBE
r1SCtYrGkckjRlAb3/g0f+aYj+qRqn2/m923wyg3Pl96vxQn05VAnKBQKBQKBQKBQKBQKBQK
BQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKCOzmEg
ZvFP4yeCnGkDpKyqhIqLcSEk4oQql0WtZjWNJYtGrzB/trvrGv6cXko8uMnyFKaXqW/eJvn9
VcTd/t7b5+eseqU/+x3kRpFq2j+qOP1NmJ263pMRByeY6Df2ghNCyqovNOofUJPoRKjwftjZ
4516er+6dUd91urxpbJp/bGn1uo2/wBt8Bh3OuLPVll/mSXFJx0v8TpqpfQlkru48VaRpWIi
EFMNazrzt888ZdY2222CA2KCKckTglSJV9AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAo
FAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoP/9k=
--------------040609040906060602020400--

--------------040407040301080503060001--





From rogerio.pereira@riosoft.com.br Fri Nov  22 12:06:39 2013
Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50809=pgsql-performance-ar@postgresql.org>)
 id 1VjpVO-0002U5-W7
 for pgsql-performance@arkaria.postgresql.org; Fri, 22 Nov 2013 12:06:39 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50809=pgsql-performance-ar@postgresql.org>)
 id 1VjpVO-0001v6-5J
 for pgsql-performance@arkaria.postgresql.org; Fri, 22 Nov 2013 12:06:38 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1VjpVM-0001uz-F9
 for pgsql-performance@postgresql.org; Fri, 22 Nov 2013 12:06:36 +0000
Received: from riosoftweb1.riosoft.com.br ([186.237.128.40]
 helo=emailserver.riosoft.com.br)
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <rogerio.pereira@riosoft.com.br>) id 1VjpVD-0000WF-GU
 for pgsql-performance@postgresql.org; Fri, 22 Nov 2013 12:06:35 +0000
Received: from [171.171.0.172] ([201.91.189.254]) by riosoft.com.br with
 MailEnable ESMTP; Fri, 22 Nov 2013 10:06:19 -0200
Message-ID: <528F48BB.8060505@riosoft.com.br>
Date: Fri, 22 Nov 2013 10:06:19 -0200
From: Rogerio Pereira <rogerio.pereira@riosoft.com.br>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.1
MIME-Version: 1.0
CC: pgsql-performance@postgresql.org
Subject: Re: Query in cache
References: <528A4271.80806@riosoft.com.br>
 <20131118165715.GM28440@aart.rice.edu>
In-Reply-To: <20131118165715.GM28440@aart.rice.edu>
Content-Type: multipart/alternative;
 boundary="------------000802050505050704050903"
X-Pg-Spam-Score: 1.3 (+)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

This is a multi-part message in MIME format.
--------------000802050505050704050903
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

What is the maximum amount of VM that can be created?
Version 9.3

Tks,
-- 
Assinatura de E-mail padrão Riosoft 20 anos

*Rogerio Pereira *
Dba | Tel. 55 (17) 3215-9199 | rogerio.pereira@riosoft.com.br
Riosoft - Sistemas para Gestão Empresarial <http://www.riosoft.com.br>


Respeite o meio-ambiente, não desperdice papel, imprima somente o 
necessário.
Esta mensagem, incluindo os seus anexos, contém informações 
confidenciais destinadas a indivíduo e propósito específicos e é 
protegida por lei. Caso você não seja o destinatário desta mensagem, 
deve apagá-la. É proibida a utilização, acesso, cópia ou divulgação não 
autorizada das informações presentes neste e-mail. As informações 
contidas nesta mensagem e em seus anexos são de responsabilidade de seu 
autor, não representando idéias, opiniões, pensamentos da Riosoft.


--------------000802050505050704050903
Content-Type: multipart/related;
 boundary="------------070702040205010205020308"


--------------070702040205010205020308
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Hi, <br>
    <br>
    <span id="result_box" class="" lang="en"><span class="hps">What is
        the</span> <span class="hps">maximum</span> <span class="hps">amount
        of</span> <span class="hps">VM</span> <span class="hps">that
        can be created</span><span class="">?</span></span><br>
    Version 9.3<br>
    <br>
    Tks,<br>
    <div class="moz-signature">-- <br>
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="author" content="Rafael F. Borges - Marketing Riosoft">
      <meta name="language" content="pt-br">
      <title>Assinatura de E-mail padr&atilde;o Riosoft 20 anos</title>
      <table width="100%" cellpadding="0" cellspacing="0" border="0">
        <tbody>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000"><font style="font-size:13px"
                color="#000000" face="Tahoma"><span id="_AthCaret"></span></font><br>
            </td>
          </tr>
          <tr>
            <td style="font-family:Tahoma; font-size:13px;
              color:#000000">&nbsp;</td>
          </tr>
          <tr>
            <td>
              <table width="100%" cellpadding="0" cellspacing="0"
                border="0">
                <tbody>
                  <tr>
                    <td><font style="font-size:20px" color="#000000"
                        face="Tahoma"><b>Rogerio Pereira </b></font></td>
                  </tr>
                  <tr>
                    <td height="20"><font style="font-size:11px"
                        color="#000000" face="Tahoma">Dba | Tel. 55 (17)
                        3215-9199 | <a class="moz-txt-link-abbreviated" href="mailto:rogerio.pereira@riosoft.com.br">rogerio.pereira@riosoft.com.br</a></font></td>
                  </tr>
                  <tr>
                    <td><a href="http://www.riosoft.com.br"
                        target="_blank"><img
                          src="cid:part1.09070503.04050200@riosoft.com.br"
                          alt="Riosoft - Sistemas para Gest&atilde;o
                          Empresarial" width="522" border="0"
                          height="56"></a></td>
                  </tr>
                  <tr>
                    <td height="10"><br>
                    </td>
                  </tr>
                  <tr>
                    <td bgcolor="#0057a6" height="20"><br>
                    </td>
                  </tr>
                  <tr>
                    <td height="25"><font style="font-size:12px"
                        color="#777777" face="Tahoma">Respeite o
                        meio-ambiente, n&atilde;o desperdice papel, imprima
                        somente o necess&aacute;rio.</font></td>
                  </tr>
                  <tr>
                    <td><font style="font-size:10px" color="#777777"
                        face="Tahoma">Esta mensagem, incluindo os seus
                        anexos, cont&eacute;m informa&ccedil;&otilde;es confidenciais
                        destinadas a indiv&iacute;duo e prop&oacute;sito espec&iacute;ficos e
                        &eacute; protegida por lei. Caso voc&ecirc; n&atilde;o seja o
                        destinat&aacute;rio desta mensagem, deve apag&aacute;-la. &Eacute;
                        proibida a utiliza&ccedil;&atilde;o, acesso, c&oacute;pia ou
                        divulga&ccedil;&atilde;o n&atilde;o autorizada das informa&ccedil;&otilde;es
                        presentes neste e-mail. As informa&ccedil;&otilde;es contidas
                        nesta mensagem e em seus anexos s&atilde;o de
                        responsabilidade de seu autor, n&atilde;o representando
                        id&eacute;ias, opini&otilde;es, pensamentos da Riosoft.</font></td>
                  </tr>
                </tbody>
              </table>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>

--------------070702040205010205020308
Content-Type: image/jpeg;
 name="imgAssinaPadrao.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.09070503.04050200@riosoft.com.br>
Content-Disposition: inline;
 filename="imgAssinaPadrao.jpg"

/9j/4QAYRXhpZgAASUkqAAgAAAAAAAAAAAAAAP/sABFEdWNreQABAAQAAAA8AAD/4QMpaHR0
cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLwA8P3hwYWNrZXQgYmVnaW49Iu+7vyIgaWQ9Ilc1
TTBNcENlaGlIenJlU3pOVGN6a2M5ZCI/PiA8eDp4bXBtZXRhIHhtbG5zOng9ImFkb2JlOm5z
Om1ldGEvIiB4OnhtcHRrPSJBZG9iZSBYTVAgQ29yZSA1LjAtYzA2MCA2MS4xMzQ3NzcsIDIw
MTAvMDIvMTItMTc6MzI6MDAgICAgICAgICI+IDxyZGY6UkRGIHhtbG5zOnJkZj0iaHR0cDov
L3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+IDxyZGY6RGVzY3JpcHRp
b24gcmRmOmFib3V0PSIiIHhtbG5zOnhtcD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4w
LyIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5z
OnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYj
IiB4bXA6Q3JlYXRvclRvb2w9IkFkb2JlIFBob3Rvc2hvcCBDUzUgV2luZG93cyIgeG1wTU06
SW5zdGFuY2VJRD0ieG1wLmlpZDpCOTMyNzM3NzIzMzcxMUUwQjY1NUYwRjA2MEJEMjVENSIg
eG1wTU06RG9jdW1lbnRJRD0ieG1wLmRpZDpCOTMyNzM3ODIzMzcxMUUwQjY1NUYwRjA2MEJE
MjVENSI+IDx4bXBNTTpEZXJpdmVkRnJvbSBzdFJlZjppbnN0YW5jZUlEPSJ4bXAuaWlkOkI5
MzI3Mzc1MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1IiBzdFJlZjpkb2N1bWVudElEPSJ4bXAu
ZGlkOkI5MzI3Mzc2MjMzNzExRTBCNjU1RjBGMDYwQkQyNUQ1Ii8+IDwvcmRmOkRlc2NyaXB0
aW9uPiA8L3JkZjpSREY+IDwveDp4bXBtZXRhPiA8P3hwYWNrZXQgZW5kPSJyIj8+/+4ADkFk
b2JlAGTAAAAAAf/bAIQABgQEBAUEBgUFBgkGBQYJCwgGBggLDAoKCwoKDBAMDAwMDAwQDA4P
EA8ODBMTFBQTExwbGxscHx8fHx8fHx8fHwEHBwcNDA0YEBAYGhURFRofHx8fHx8fHx8fHx8f
Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f/8AAEQgAOAIKAwERAAIRAQMR
Af/EAKcAAQABBQEBAAAAAAAAAAAAAAAFAQIDBAYHCAEBAAIDAQAAAAAAAAAAAAAAAAMEAQIF
BhAAAQMDAgQDBAcGBAcAAAAAAgEDBAARBRIGITETB0EiFFFhcTKBkUJSIxUIoWI1dbUWcjMk
NLHR4ZKiY5MRAQACAQIEAgUKBgMBAAAAAAABAgMRBCExEgVBMmFxkYKy8FGBobHB0SITBkJS
YnIjFeEUJKL/2gAMAwEAAhEDEQA/APqmgUCgUCgUCgUCgUCgUCgxuuNtNk44SA2CKpmSoiIi
c1VVrMRqTOjG3NhuGINvtmZipgIkKqopzVEReXGsTWY8GItDYoyjs7lPyyI3J6XV1yokXTq0
29XKajar2X5Orqt48q3x06509Ez7ImfuR5b9Ma+mI9sxCRHlWkJCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHj3fvf+f2weJjYOUsR+Qj
rr5IIlqAdIinmRfG9dftW0pl6pvGujk9z3N8fTFZ0cqxlf1DPwW5zMpXWHW0dbRPTalEk1J5
bc7eFWZ/6UW6Zj7UEf8AcmNYn7Ez2p71Z3J7ib25uYQJ+QpNx5Qh0zR0EVem4KeXjZePDjUW
/wC20rTrx8kmx397X6L821uHKd4R7guMwicY256tsQREYVPTppQ143PjxWo8cbWMPHz6enm3
yTuZy8PJr6OT2RXQBrqOkjYoiKSktkT6VrkRDrTKjMhh4VJpwXBTxBUJP2UmJjmxExPJloyw
tyorpKDbwGacxEkVfqRaTWYYi0SzUZYDlxGz6bjwCf3CJEX6lWnTMsTaGejLxrvT3XzWAyUf
bu3VRvIOgLkmTpQzHqLZttsVumpeaqtdjtuwrkrN7+VyN/vLUtFKc0TAyvd3a0J/c24sh67H
MMEqwHCUkV5ywNISiCIliL7JVJaNtmtGPHXSZnm1idxhib3nWNOTtO3W8ct3A2zkXpzDUI0c
6UZWUIg8qIVy1qt/NzSqe8wV2+SIidVra57Z8czMaJLbG1chjpjZvqINtErmkCI1Jwh0Gqko
N2FR5D5uPjUObPFoS4cE1l2tVVpAb3/g0f8AmmI/qkap9v5vdt8MoNz5fer8UJ9OVQJygUCg
UCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUHy9+o
vIpJ7gNxVVVbgxWgVPeaq4X7CSvUdopph1+eXmu631y6fNDqI36kMJAw7MKHhpBux2kba6jg
C3cUsl7altVOezXm2s2ha/21YjSKy5btbtvOZzfA7rmsFHhg+5ON5RURMzVS/DRfspqverPc
NxSmL9Ks625IdjgvfL+raNI5sfbPKP5Lum9lpEk1iMHKnuqRKoIHm42VbcEKt9/SKbeKxHGd
IabG02zzaZ4RrK6Tmdzd2t6FBbkuRMOCkTUcFXS2yi2RVFLITh8Of/CsTTHs8Wumt/v/AAZi
193l010r9zHunC7i7Tbjx8nF5Fw2pIq6IkvlNGyRDbdBF0ki3Ss7fLXd0mL14w03GK20vE1n
m6/vjv8AzDm2sB+VOOQ8fnI6yZLjaqhLwH8FTTwTVxtzqr2va167dXGazp/ytdx3NuivTwi0
auT2t2+azmDj5TaWeINyR9JTIZuK24K38xCg+eyeC8b1Zz7y2O81y0/x+CDBtK5KROO35/F3
vcPuHuraOyMdjJT4HuqaJg5OAdOlkOCuiK/bW6De3O61Q2W1x5ss2iP8ceC5u9zfDjisz+ef
Fxu3+zGb3Jtw9wy8k6mRkAT8dHFUrpbUOsyXVcvdyq3l7nXHk6K1/LHBWx9utkx9drfmlKdm
d353Nw8rsebPcQ34jv5dMJVN1hbaDBFVUVUsVx48K07lgpjmuWI8eMfO27fnveLYpnw4S87X
a8yb3CXbnr3JEgZKxlnlcj/C5lxJV8un210Z3EVwfqaacOSjGCbZ+jXx5p/udsHNbSxMVybm
pE5uY90hjOEWnyDq1WUyThw8KrbDdxmtMRWK6LG+2k4qxrabauv7L9ucu2mH3QGRdSISk4UB
Lo35kULr5rLwW/y1T7lvYmbY+n6Vrt+zmIrk6voe+Vw3aaUrIsR5kaMSp1JJKgJ48EvVLLvI
pmpi/ivr9ERHP28ElcetZt8yN3t/Bo/80xH9UjV1Nv5vdt8Mqm58vvV+KE+nKoE6GyuZlM5S
Pi4TLRypDRvoch1Wm9LZCKiOkXCM/PyS1k40Fn9xhHN5vJCEZ5gGNTTJOSTVyQTgiAiDQkd+
ncbJdfYlBYW8MYmTahrrBt2OslJBtuiIoJ6FQ0IE0W8VK1vGgzhuvAkw+8UlWm4wgbvVadaL
QZaQMRMRIwJeCEN0oLWt24J2QjAvmLpOoxpNh8NLp/KB6gHRrumjVbV4cKC9N0YTW8DjxsKy
2bplIZeYFW2l85AToAhoN0+S9Bt4/KRJ7ROR+pYF0kjrTrJItr/K6IFy91BpNbswTrottyCJ
TVxALovIBk0iqYAehBIx0r5RVS91AHdeCVh+Qcgo7cbpddJDT0chR8tDZKLoAeky4IVrUFU3
VhFNoOq6iPEINvlHfRnUZaRFXVBG0VV8FKgy5jLHBWMywx6mbNd6MRjVoRVQVMiM7FpERG6q
ifRQYhzMmE2RZtluMuoQjrGJySrykirpBsWxcU0QflQVoKf3XglRkgfNzrIRIjTLzhCInoJX
AACVux+VdaJagj394dUZgQm1GRDlFGNHGJTyEIj8wiw2RKpHYbeCXLjyUNyNunHpj40mW8Kv
SVd0Mxm33V/CNRJNCB1fw+RqQJZeaJyoNjKZ1iJt2Rmo6DLYZjlJaQS0o4KDqSxWK31UGBjP
k1GflZRYceMwrY9SJJOXxdPQKEPRZ03JURLXoL4+7MFIeBht8+qbqsaSZeDS7ZVRtxTAUbJU
4ohWv4UFobw28aKaSlRlG3HUdVp0WyFkVJzQ4oIBqAiqqgqqpagqW7tvo0jySVcbXUV2mnXb
AFtTio2JKjfm+dfL76DMO4sQctYjTxOuJbUbbTptIpAjiIrwAraEoKhImq9BiTdWD6TzpyDj
hHETe9Qy8wqAZaENEdAFIVJbakulBa3urGuOPECq7HaBohNlt910uqbgW6INKVrs8FS9/dwV
Qq1uNiTOxzMP8SPNGRrcJDAwKPpuJAaCQrdeKEl6DckTjby0OEgooSW3zU15irWi1v8A6UCZ
mcbDV5JL6NenZ9S9qvwaVVHV/wByUFEzeKWakJJArKXk2iL9zq87W+TjQYR3LgzbYdGUJNyQ
Bxg0QlRRccFkVuicLuGg0GYc1iyc6YyBI/UrDsl1/wBQgK4TfLnoS9Br5LcmKgvOxXHw9a01
1vTlrTyqhKKqoiVhuHErLagLufDtm008/odcFsj0g4bbavIigjjiBoDVfhrtQVTc+EUn09Qq
BGRxXXibdFq7S6XEB1R6ZkK8LCqreg0crvSBHg9aJqdkFIajI080+2TZOrwNxtQ6iDpuo+Xz
ckoNnb+5GcqUlnQTcmI4rTqIDiASgg3ISMR+0VkTnQZj3JhgkuxyfVFY1o8703OgKtDrMSe0
q0hCKXVNV6DGG68CUd6QUlWm4/T6nVadaJEeLQ2SAYCZCZcBJEstAjbswUh9thp8+qbnQ0Ey
8Gl3mjZqQJoJU+VCtdOKUFMvuFrG5WBEeAiZmMyHFJsHHXNTCtWEG2hMlv1V8KDI3ufAuvxm
G5gm/LbByO2KEqkDhKAla3DzCqLfl40EqPJKCtAoFAoFAoFAoPlaWibk77ujbqtLkiFRLiih
F4Knw/Dr1E/4tn7v2vNR/k3fvfY9C7+7MxreywycGOLTsGQCuqCIl23Lgt7fvKNc7tGaYy9M
zzhf7phj9LWI5S1+2+6gb7I5h9VFJeIZkR9XjYxuzdfidq33e3/9cR4WmJa7bP8A+Wf6YmHG
9kNvycpE3UbA3fcxzkWOvtN0C4fWg1c7pmitsev82qp27HNq30/l0Xfp+zWIw265zGXfCE68
zoaN9UbFHGyXUCqVkRfj7Kd3xWvSs1jXQ7XlrS8xbhqs717mj7y3pBxmCVJjcMPTNOt8Rced
K56V8RGyJf41nt2GcGKbX4a8WN/ljNlitOOnB20vcnbpYUDtxuZh5tyK22ys54EbZac6dwcB
zVqRCv8ANa30Vz6YM/HPjnnx0Xr5cPDDeOXDV5VvvbjWx9yRiwWZGTqH1EZ+O4ius2KyIRAv
1e2uxtM056T110+9y91hjDeOi2v3J7vO5mMpiNo7hnNKJS8ejUlbWRJArqLh4a0LVaoO2dFb
XpXwt9SbuPVatLz41enMd0No4vtcxKYmsuS0hIwzBEk6yyNGjSQJ5ksvFV9lcqNjktn0mOGv
P0OlO9x1w6xPHTk8+/TzhpP57M3E8KhDiMuCjq8EIlTUdv8ACicfjXQ7xljSMcc5lR7VinWc
k8ohpdlGjzPdN3JuJfT15ZL7DdP/AJEtSd0nowRX1R7EfbY68829cp/9UEp1clg4nFGhZedv
4KREI/sQag7JX8tpTd4txrD1HtfmNvSdrY6BipzMl2LFb67LZIphw0+ceYrdPGuTvMV63mbR
prMuptMlJpEVnXSIdTNmsQ45PvlYE5J4qvgiVyt5u8e2xzkyTpWPlpC9ixWvbphxm3nH9w7n
cyp/7KCqhHVOIq4nAlH3D8vx1Vyuy4smW1t1ljS2Tyx/LTw9rbcWrrFK+Wn128fZy9qe3t/B
o/8ANMR/VI1en2/m923wypbny+9X4oT6cqgToTcMGTM0tLjIWUiKK3blkoEDn3h/DdS3wsqe
FBCxdn5GK051gayCqzDbAVkPMuAUYnyVQeEVMVHriIFe9kXlQJO1c/JiizJebkOSYEnHy3ic
NSbF9zW2QqoXe0D5V1adX0rQXJtWc9EkNlEjxpZA02MhZkiTrRt8HS4OD+GC9PgnHjw99Buy
ttznpU10TaQZOTgzm0VSujUQWENC8q+ZeiVrcOXGgjI2z8x1WnZrUeW60zKZkuPyXnFlk+iI
OpCbXpBw5De1/rCf27BycQJKTFUWnHEKLGV9ySrIIKIqdVxBJbldbeHKg5mJiNxZPARojSNY
9qM7LfjzNZq91bvi1+H0xRuxOatWpeXvoM47NybiyT6TEVHwx6I0Uh6SSrEmeodJxxwEXzBw
T30GxmdsZifkJDi9N1s5MWRGfdfdHoNMm2ZtCwIECkpNkupV46qCazuOmSThTISh67Huq620
6qi24JgrZtkQoWngV0Ky2VOVBzj+z8m9MXIqy01peBwMakp+yj03G3F6wiJAS9S6IiW4e+gz
v7Yygxw/LobOPmkhWmNTZBGyRnqJTuH+oS3HSXDV9dBfMwGfV6SDItnAenLOcbGQ5HN4DZQO
iZNtqoaXEQ7oq6kS3jQW4nbWcw7rUyO3FffT1gOROqYti3JkddtQdVpSuNtJXH/qG89tqWuy
X8CDrZSnozrauLcWuo7qJfAi0opLbhQWy8RlZuNdjFBgwHFfiPCUd4nEJI8kHi13js28oLp5
0FT25OJ6SetuzuXZyQcSujLbTQKK2T57tL7vfQQEbb+czm04UA2mIrDDElWHDcMjN11h6O2J
hoTQCdZSJUVV4JagmcvtiW9kWZzTIzBSIER2MUl6LbpkRCSE0i6r61RUJKDGm28szIaDGNs4
psQEXH2JLzgGIx+kIFHIEDUKoNnL6rDf3UGkOy8w5rJwWWTOK0w6ZSXpBuONyG3jcIjBNKEj
a2RKCRze3cvIycuZFcFWZHokdii84wbrcbr9RtXQG4oqvAqW52str0DB7YnwZkR9xGGwZenO
ky0ZmiJLUVARIxFV06bKtqCUmgS7kxZIKqIsS0JUTgl1Z50GDN7ecyWWx8oSEY7KG3ObW93G
9YPNIlvY6yl+PJV9tBEf2TkEwyRfUt/mHq+qkq5X9OjPo+drqfpefhqoNldmv6M42LrYtTWk
axSJqux5jfufwkO3S32USgrC2pNi5SNOF5o0bjm48BKXmyJoQq6nD5DF00X6OHOgzFg8q+WX
ekkwkjKY1iJZsjUBfbB5HPmG/T1PJa/1UGk9tfMpDn4troHEy3SWRKIzRxlRZaYd0hos5wZu
35ksq+ygpN2tmJLsgI6N4+IpE8rISHHmX3hfB9slZIEFm6guvQnFS8edBsO7fzM7JJlJQsRn
utCRGAdNwUahuOOKSnoC5GrqoiW5eNBtRoOehvZMIrcchlyklR3nXD5H0xcAwELoqCBWVC52
oNR3b2ZLGT8EIsehlnKdbnE4XUH1Bm8Im1o8yi4elV18R9/CgpkcBncq8cqUMeM8IxWmmgcN
wVRmYEl01NWwXijdgG31UGwe3JyuyDQ2tL2YZyQ3Uroy000Cj8vzXaWyezxoKzIO5CykDJix
EfdiBMZNkXXGkUH3GlaISVs/MgtedOCey9BTbW25mKnnIfcbNHIotmgKvB4pMiS7a6J5E9Qi
J8KDpUoFAoFAoFAoFAoODwnaHbOG3J+fQhNJWszubhn/AJi3L5l5rVvLvsmSnRM/lVMWyx0t
1RHF1eewkDOYiTisgHUiSg0Oiiqi87pZU5WVKr4sk0tFq84WMmOL1ms8pcfiuz22cfhcphm+
p6DLC2klvqucSaLUCot+HHn7atX7hltaLTprXlwVq7LHWs1jlb0pfZGwMPtBqS1jUVG5JIZ6
iIl1IluZKvsqLcbm+aYm3glwbamKNKobd/ZTaO4px5AmlizHV1PGyuhDL7ypZUv9FTYO45cU
aROselDm2GLJOsxpPoZtodoNs7af9THa6sm1us4qmdvYhL8qfBK03G+yZeFp4N8Gzx4uNY4t
7evbLbG7dDuRj6ZjQ6QlNqoHpTkKqnNK12+8yYvLPBnNtMeXzQ5rDfp/2lj5YSTEpKtrqBHi
UxRU/csIr9NWMvdM140109SDH23DWddNfW73LbYwuWwxYifGF+ESJ5CTkSciRfBfelUseW1L
dVZ0ldyY63jS0aw85H9Oe0Al9VCdNm90ZJwtPw4Jq/8AKuhPd82mnD2KEdqw668XoUHauHh4
RzDsMo1CeZKOYteSzZioqgqnFOC86505bTbqmdbL36VYr0xGkIXZfa7AbSnPS8YJCb4aD1ER
8EW6W1KvtqfcbzJmiItPJFg2mPFMzWObf3psLAbvhtR8qzqNglKO+KqJhq+ZEJPBbVrt91fD
OtZbZ9tTLGloQW1Nlbd7fFKejOmbksURWlNTMtN9Nkslk4rXO73+4aYqxOaePhWOcpe39s0m
eiOfOZRkzJ5TeGTKBAIhiNkoSpTfyNp9ppkvtOr9ovs/HhXltpss3cMsbjcx04o8lPx+XH1L
ufcVpE4sM8f4rfdHp+z1vR8NiouKgNQ4wI202KCgjwTgluFeyU61iI0hH73/AINH/mmI/qka
p9v5vdt8Modz5fer8UJ9OVQJygUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgU
CgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCgUCg57eG4XMDBjTUDqNFJBp8fFQNC5L4Le1qq7
rLOOnVHHTn6lnaYa5L9EzpM8vW2IO68DNaRxqUI3S6g55ST4otV/9vttON4r6+DfLsM1J0mq
6RubDMp/uEcX7raKS1U3H7j2WOPP1f28WKbHLbw0cvuDuTHhN21jF18G0L8R81XwbbG6qtcP
J+4N1u56NpjmP6p+WkfWnvgwbeNc1vo+XGUFAwe5d1PdSWjuNxRrdxsitLeT/wBhov4Ir91P
N8Kv9t/bkUt+ruJ/Uy+nlH4qefe5M0dNY/Tx/wD1P4fa9LwuDx+IhtxYbQtNtigigpZERPBE
r1SCtYrGkckjRlAb3/g0f+aYj+qRqn2/m923wyg3Pl96vxQn05VAnKBQKBQKBQKBQKBQKBQK
BQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKBQKCOzmEg
ZvFP4yeCnGkDpKyqhIqLcSEk4oQql0WtZjWNJYtGrzB/trvrGv6cXko8uMnyFKaXqW/eJvn9
VcTd/t7b5+eseqU/+x3kRpFq2j+qOP1NmJ263pMRByeY6Df2ghNCyqovNOofUJPoRKjwftjZ
4516er+6dUd91urxpbJp/bGn1uo2/wBt8Bh3OuLPVll/mSXFJx0v8TpqpfQlkru48VaRpWIi
EFMNazrzt888ZdY2222CA2KCKckTglSJV9AoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAo
FAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoFAoP/9k=
--------------070702040205010205020308--

--------------000802050505050704050903--