Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id F2FEDB5DBFD
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat,  8 Oct 2011 12:05:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 16689-09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat,  8 Oct 2011 15:04:58 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from smtp.babel.it (ns1.babel.it [89.97.242.210])
	by mail.postgresql.org (Postfix) with ESMTP id 84594B5DBF9
	for <pgsql-performance@postgresql.org>;
	Sat,  8 Oct 2011 12:04:57 -0300 (ADT)
Received: from smtp.babel.it (catfish.babel.it [10.0.0.10])
	by smtp.babel.it (Postfix) with SMTP id 6FEC44D713;
	Sat,  8 Oct 2011 17:04:53 +0200 (CEST)
X-DKIM: OpenDKIM Filter v2.1.3 smtp.babel.it 6FEC44D713
Authentication-Results: smtp.babel.it; dkim=permerror
	(verification error: empty key record; insecure key)
	header.i=@babel.it header.b=qk+aFKvU;
	dkim-adsp=none (insecure policy)
Received: from [0.0.0.0] (unknown [151.1.155.96])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	(Authenticated sender: gmancuso@babel.it)
	by smtp.babel.it (Postfix) with ESMTPSA id 65D914D70F;
	Sat,  8 Oct 2011 17:04:47 +0200 (CEST)
X-DKIM: OpenDKIM Filter v2.1.3 smtp.babel.it 65D914D70F
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=babel.it;
	s=babeldkim; t=1318086288;
	bh=kC9dtyNfo0mgHhy0nfqLoVDQyC5G/XGmMfbHHs+7LsE=;
	h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References:
	In-Reply-To:Content-Type;
	b=qk+aFKvUDwXAD3wlN+UMdBoBu8/c/Rk9FTAP4AH64sa4X+zcCIa0iBYWBlKJRqfox
	gTIwU7Bw9pT3SFTGKQROLyBuaFXVrCWrYH1IQeGWNv2rh8KTtxjhG2iLGEn7LUW/ZY
	7IlyUt19zICiT4p2dcDjnJrXv6SVb6tu7tJc8t2k=
Message-ID: <4E90668E.9010602@babel.it>
Date: Sat, 08 Oct 2011 17:04:46 +0200
From: Giovanni Mancuso <gmancuso@babel.it>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:7.0) Gecko/20110917 Thunderbird/7.0
MIME-Version: 1.0
To: Guillaume Cottenceau <gc@mnc.ch>
CC: pgsql-performance@postgresql.org
Subject: Re: Performance problem with a table  with 38928077 record
References: <4E8ECEB7.4080800@babel.it> <m34nzlyu9a.fsf@mnc.ch>
	<4E8F16C6.7070606@babel.it>
In-Reply-To: <4E8F16C6.7070606@babel.it>
X-Enigmail-Version: 1.3.2
Content-Type: multipart/mixed; boundary="------------060300010003060004010902"
X-PMX-Version: 5.6.0.2009776
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.403 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RP_MATCHES_RCVD=-0.504
X-Spam-Level: 
X-Archive-Number: 201110/75
X-Sequence-Number: 45297

This is a multi-part message in MIME format.
--------------060300010003060004010902
Content-Type: multipart/alternative;
	boundary="------------040507060107060604070106"


--------------040507060107060604070106
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

I clean all unused data, run VACUUM FULL and run REINDEX d,_object_perm.

Un my table, now i have:
----------
 24089952

But the problem is the same.

Thanks

Il 07/10/2011 17:12, Giovanni Mancuso ha scritto:
> Il 07/10/2011 12:24, Guillaume Cottenceau ha scritto:
>> Giovanni Mancuso <gmancuso 'at' babel.it> writes:
>>
>>> select count(*) from dm_object_perm;
>>>   count  
>>> ----------
>>>  38'928'077
>>> (1 row)
>> [...]
>>
>>> If i run "explain analyze select * from dm_object_perm;" it goes on for many
>>> hours.
>> Almost 39 million records is not small, especially if you run on
>> poor hardware[1], poor configuration[2], poor database optimization[3],
>> bloat[4], or a combination of these.
>>
>> [1] you could tell what hardware you use
> My Memory:
> # cat /proc/meminfo
>         total:    used:    free:  shared: buffers:  cached:
> Mem:  4022861824 2201972736 1820889088        0  8044544 1983741952
> Swap: 8589926400 199303168 8390623232
> MemTotal:      3928576 kB
> MemFree:       1778212 kB
> MemShared:           0 kB
> Buffers:          7856 kB
> Cached:        1897356 kB
> SwapCached:      39892 kB
> Active:        1330076 kB
> ActiveAnon:     554472 kB
> ActiveCache:    775604 kB
> Inact_dirty:    539124 kB
> Inact_laundry:   55348 kB
> Inact_clean:     36504 kB
> Inact_target:   392208 kB
> HighTotal:           0 kB
> HighFree:            0 kB
> LowTotal:      3928576 kB
> LowFree:       1778212 kB
> SwapTotal:     8388600 kB
> SwapFree:      8193968 kB
> CommitLimit:  10352888 kB
> Committed_AS:  1713308 kB
> HugePages_Total:     0
> HugePages_Free:      0
> Hugepagesize:     2048 kB
>
> My CPU:
> # egrep 'processor|model name|cpu MHz|cache size|flags' /proc/cpuinfo
> processor       : 0
> model name      : Dual Core AMD Opteron(tm) Processor 275
> cpu MHz         : 2193.798
> cache size      : 1024 KB
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm
> 3dnowext 3dnow
> processor       : 1
> model name      : Dual Core AMD Opteron(tm) Processor 275
> cpu MHz         : 2193.798
> cache size      : 1024 KB
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm
> 3dnowext 3dnow
> processor       : 2
> model name      : Dual Core AMD Opteron(tm) Processor 275
> cpu MHz         : 2193.798
> cache size      : 1024 KB
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm
> 3dnowext 3dnow
> processor       : 3
> model name      : Dual Core AMD Opteron(tm) Processor 275
> cpu MHz         : 2193.798
> cache size      : 1024 KB
> flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
> mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm
> 3dnowext 3dnow
>
>
>> [2] you could report if your DB configuration is tuned/good
> max_connections = 50
> shared_buffers = 512MB
> temp_buffers = 128MB
> max_prepared_transactions = 55
> max_fsm_pages = 153600
> vacuum_cost_delay = 0
> vacuum_cost_page_hit = 1
> vacuum_cost_page_miss = 10
> vacuum_cost_page_dirty = 20
> vacuum_cost_limit = 200
> effective_cache_size = 256MB
> autovacuum = on
> autovacuum_naptime = 1min
> autovacuum_vacuum_threshold = 500
> autovacuum_analyze_threshold = 250
> autovacuum_vacuum_scale_factor = 0.2
> autovacuum_analyze_scale_factor = 0.1
> autovacuum_freeze_max_age = 200000000
> autovacuum_vacuum_cost_delay = -1
> autovacuum_vacuum_cost_limit = -1
> vacuum_freeze_min_age = 100000000
>
>> [3] you could report if the DB is regularly analyzed/vacuumed
>> [4] you could try a VACUUM FULL or CLUSTER and/or REINDEX on your
>>     large table(s) if you suspect answer to [3] is "no" -
>>     warning, these block some/all DB operations while running,
>>     and they will probably run for long in your situation
> I run VACUUM yesterday.
>>> If i try to execute a left join: "SELECT dm_object.id FROM dm_object LEFT JOIN
>>> dm_object_perm ON dm_object.id = dm_object_perm.object_id;" my db is unusable.
>> EXPLAIN on this query would probably tell you PG has quite some
>> work to do to produce the result.
>>
>>
>>> how can I fix this?
>> I'm wondering if your DB design (storing almost all "object x
>> account" combinations in object_perm) is optimal.
>>
>
>
> -- 
>
> *Giovanni Mancuso*
> System Architect
> Babel S.r.l. - http://www.babel.it <http://www.babel.it/>
> *T:* 06.9826.9600 *M:* 3406580739 *F:* 06.9826.9680
> P.zza S.Benedetto da Norcia, 33 - 00040 Pomezia (Roma)
> ------------------------------------------------------------------------
> CONFIDENZIALE: Questo messaggio ed i suoi allegati sono di carattere
> confidenziale per i destinatari in indirizzo.
> E' vietato l'inoltro non autorizzato a destinatari diversi da quelli
> indicati nel messaggio originale.
> Se ricevuto per errore, l'uso del contenuto e' proibito; si prega di
> comunicarlo al mittente e cancellarlo immediatamente.


-- 

*Giovanni Mancuso*
System Architect
Babel S.r.l. - http://www.babel.it <http://www.babel.it/>
*T:* 06.9826.9600 *M:* 3406580739 *F:* 06.9826.9680
P.zza S.Benedetto da Norcia, 33 - 00040 Pomezia (Roma)
------------------------------------------------------------------------
CONFIDENZIALE: Questo messaggio ed i suoi allegati sono di carattere
confidenziale per i destinatari in indirizzo.
E' vietato l'inoltro non autorizzato a destinatari diversi da quelli
indicati nel messaggio originale.
Se ricevuto per errore, l'uso del contenuto e' proibito; si prega di
comunicarlo al mittente e cancellarlo immediatamente.

--------------040507060107060604070106
Content-Type: multipart/related;
	boundary="------------050003090804080609010800"


--------------050003090804080609010800
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    I clean all unused data, run VACUUM FULL and run REINDEX
    d,_object_perm.<br>
    <br>
    Un my table, now i have:<br>
    ----------<br>
     24089952<br>
    <br>
    But the problem is the same.<br>
    <br>
    Thanks<br>
    <br>
    Il 07/10/2011 17:12, Giovanni Mancuso ha scritto:
    <blockquote cite="mid:4E8F16C6.7070606@babel.it" type="cite">
      <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
      Il 07/10/2011 12:24, Guillaume Cottenceau ha scritto:
      <blockquote cite="mid:m34nzlyu9a.fsf@mnc.ch" type="cite">
        <pre wrap="">Giovanni Mancuso &lt;gmancuso 'at' babel.it&gt; writes:

</pre>
        <blockquote type="cite">
          <pre wrap="">select count(*) from dm_object_perm;
  count  
----------
 38'928'077
(1 row)
</pre>
        </blockquote>
        <pre wrap="">[...]

</pre>
        <blockquote type="cite">
          <pre wrap="">If i run "explain analyze select * from dm_object_perm;" it goes on for many
hours.
</pre>
        </blockquote>
        <pre wrap="">Almost 39 million records is not small, especially if you run on
poor hardware[1], poor configuration[2], poor database optimization[3],
bloat[4], or a combination of these.

[1] you could tell what hardware you use</pre>
      </blockquote>
      My Memory:<br>
      # cat /proc/meminfo <br>
              total:    used:    free:  shared: buffers:  cached:<br>
      Mem:  4022861824 2201972736 1820889088        0  8044544
      1983741952<br>
      Swap: 8589926400 199303168 8390623232<br>
      MemTotal:      3928576 kB<br>
      MemFree:       1778212 kB<br>
      MemShared:           0 kB<br>
      Buffers:          7856 kB<br>
      Cached:        1897356 kB<br>
      SwapCached:      39892 kB<br>
      Active:        1330076 kB<br>
      ActiveAnon:     554472 kB<br>
      ActiveCache:    775604 kB<br>
      Inact_dirty:    539124 kB<br>
      Inact_laundry:   55348 kB<br>
      Inact_clean:     36504 kB<br>
      Inact_target:   392208 kB<br>
      HighTotal:           0 kB<br>
      HighFree:            0 kB<br>
      LowTotal:      3928576 kB<br>
      LowFree:       1778212 kB<br>
      SwapTotal:     8388600 kB<br>
      SwapFree:      8193968 kB<br>
      CommitLimit:  10352888 kB<br>
      Committed_AS:  1713308 kB<br>
      HugePages_Total:     0<br>
      HugePages_Free:      0<br>
      Hugepagesize:     2048 kB<br>
      <br>
      My CPU:<br>
      # egrep 'processor|model name|cpu MHz|cache size|flags'
      /proc/cpuinfo<br>
      processor       : 0<br>
      model name      : Dual Core AMD Opteron(tm) Processor 275<br>
      cpu MHz         : 2193.798<br>
      cache size      : 1024 KB<br>
      flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr
      pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx
      mmxext lm 3dnowext 3dnow<br>
      processor       : 1<br>
      model name      : Dual Core AMD Opteron(tm) Processor 275<br>
      cpu MHz         : 2193.798<br>
      cache size      : 1024 KB<br>
      flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr
      pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx
      mmxext lm 3dnowext 3dnow<br>
      processor       : 2<br>
      model name      : Dual Core AMD Opteron(tm) Processor 275<br>
      cpu MHz         : 2193.798<br>
      cache size      : 1024 KB<br>
      flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr
      pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx
      mmxext lm 3dnowext 3dnow<br>
      processor       : 3<br>
      model name      : Dual Core AMD Opteron(tm) Processor 275<br>
      cpu MHz         : 2193.798<br>
      cache size      : 1024 KB<br>
      flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr
      pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx
      mmxext lm 3dnowext 3dnow<br>
      <br>
      <br>
      <blockquote cite="mid:m34nzlyu9a.fsf@mnc.ch" type="cite">
        <pre wrap="">[2] you could report if your DB configuration is tuned/good</pre>
      </blockquote>
      max_connections = 50<br>
      shared_buffers = 512MB<br>
      temp_buffers = 128MB<br>
      max_prepared_transactions = 55<br>
      max_fsm_pages = 153600<br>
      vacuum_cost_delay = 0<br>
      vacuum_cost_page_hit = 1<br>
      vacuum_cost_page_miss = 10<br>
      vacuum_cost_page_dirty = 20<br>
      vacuum_cost_limit = 200<br>
      effective_cache_size = 256MB<br>
      autovacuum = on<br>
      autovacuum_naptime = 1min<br>
      autovacuum_vacuum_threshold = 500<br>
      autovacuum_analyze_threshold = 250<br>
      autovacuum_vacuum_scale_factor = 0.2<br>
      autovacuum_analyze_scale_factor = 0.1<br>
      autovacuum_freeze_max_age = 200000000<br>
      autovacuum_vacuum_cost_delay = -1<br>
      autovacuum_vacuum_cost_limit = -1<br>
      vacuum_freeze_min_age = 100000000<br>
      <br>
      <blockquote cite="mid:m34nzlyu9a.fsf@mnc.ch" type="cite">
        <pre wrap="">[3] you could report if the DB is regularly analyzed/vacuumed
[4] you could try a VACUUM FULL or CLUSTER and/or REINDEX on your
    large table(s) if you suspect answer to [3] is "no" -
    warning, these block some/all DB operations while running,
    and they will probably run for long in your situation</pre>
      </blockquote>
      I run VACUUM <span id="result_box" class="short_text" lang="en"><span
          class="hps">yesterday.</span></span>
      <blockquote cite="mid:m34nzlyu9a.fsf@mnc.ch" type="cite">
        <pre wrap="">
</pre>
        <blockquote type="cite">
          <pre wrap="">If i try to execute a left join: "SELECT dm_object.id FROM dm_object LEFT JOIN
dm_object_perm ON dm_object.id = dm_object_perm.object_id;" my db is unusable.
</pre>
        </blockquote>
        <pre wrap="">EXPLAIN on this query would probably tell you PG has quite some
work to do to produce the result.


</pre>
        <blockquote type="cite">
          <pre wrap="">how can I fix this?
</pre>
        </blockquote>
        <pre wrap="">I'm wondering if your DB design (storing almost all "object x
account" combinations in object_perm) is optimal.

</pre>
      </blockquote>
      <br>
      <br>
      <div class="moz-signature">-- <br>
        <meta http-equiv="Content-Type" content="text/html;
          charset=UTF-8">
        <title>Documento senza titolo</title>
        <img src="cid:part1.00010309.02040300@babel.it"><br>
        <div style="font-family:Arial, Helvetica, sans-serif;
          font-size:12px; color:#000; margin-left:32px"> <strong>Giovanni
            Mancuso</strong><br>
          System Architect<br>
          Babel S.r.l. - <a moz-do-not-send="true"
            href="http://www.babel.it/" target="_blank" title="Vai al
            sito della Babel" style="color:#000 !important;">http://www.babel.it</a><br>
          <strong>T:</strong> 06.9826.9600 <strong>M:</strong>
          3406580739 <strong>F:</strong> 06.9826.9680 <br>
          P.zza S.Benedetto da Norcia, 33 - 00040 Pomezia (Roma)<br>
          <hr>
          <div style="font-size:11px; color:#999"> CONFIDENZIALE: Questo
            messaggio ed i suoi allegati sono di carattere confidenziale
            per i destinatari in indirizzo.<br>
            E' vietato l'inoltro non autorizzato a destinatari diversi
            da quelli indicati nel messaggio originale.<br>
            Se ricevuto per errore, l'uso del contenuto e' proibito; si
            prega di comunicarlo al mittente e cancellarlo
            immediatamente.<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <br>
    <div class="moz-signature">-- <br>
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <title>Documento senza titolo</title>
      <img src="cid:part2.00000505.05090706@babel.it"><br>
      <div style="font-family:Arial, Helvetica, sans-serif;
        font-size:12px; color:#000; margin-left:32px">
        <strong>Giovanni Mancuso</strong><br>
        System Architect<br>
        Babel S.r.l. - <a href="http://www.babel.it/" target="_blank"
          title="Vai al sito della Babel" style="color:#000 !important;">http://www.babel.it</a><br>
        <strong>T:</strong> 06.9826.9600 <strong>M:</strong> 3406580739
        <strong>F:</strong> 06.9826.9680 <br>
        P.zza S.Benedetto da Norcia, 33 - 00040 Pomezia (Roma)<br>
        <hr>
        <div style="font-size:11px; color:#999">
          CONFIDENZIALE: Questo messaggio ed i suoi allegati sono di
          carattere confidenziale per i destinatari in indirizzo.<br>
          E' vietato l'inoltro non autorizzato a destinatari diversi da
          quelli indicati nel messaggio originale.<br>
          Se ricevuto per errore, l'uso del contenuto e' proibito; si
          prega di comunicarlo al mittente e cancellarlo immediatamente.<br>
        </div>
      </div>
    </div>
  </body>
</html>

--------------050003090804080609010800
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-ID: <part1.00010309.02040300@babel.it>

R0lGODlhdwAqANUgAFNRVMbFxvObEIyLjfrXn/jJf/zkv/WvQPnQj/3rz/7473Bucf3y3/a2
UPvdr/jDcCgmKfHw8Tc0OKmoqX99f+Li4vShIPe8YPSoMEVDRpqZm2JgY9TT1Le2txoXG/KU
AP///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C1hNUCBEYXRh
WE1QPD94cGFja2V0IGJlZ2luPSLvu78iIGlkPSJXNU0wTXBDZWhpSHpyZVN6TlRjemtjOWQi
Pz4gPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iQWRvYmUg
WE1QIENvcmUgNS4wLWMwNjAgNjEuMTM0Nzc3LCAyMDEwLzAyLzEyLTE3OjMyOjAwICAgICAg
ICAiPiA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjIt
cmRmLXN5bnRheC1ucyMiPiA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIiB4bWxuczp4
bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtbG5zOnhtcE1NPSJodHRwOi8v
bnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2Jl
LmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1wOkNyZWF0b3JUb29sPSJBZG9i
ZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDk1
QTA4OUZDQkE3MTFERkJCQ0RCNkY0NzdEMjZCRkUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5k
aWQ6RDk1QTA4QTBDQkE3MTFERkJCQ0RCNkY0NzdEMjZCRkUiPiA8eG1wTU06RGVyaXZlZEZy
b20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpEOTVBMDg5RENCQTcxMURGQkJDREI2RjQ3
N0QyNkJGRSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpEOTVBMDg5RUNCQTcxMURGQkJD
REI2RjQ3N0QyNkJGRSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1w
bWV0YT4gPD94cGFja2V0IGVuZD0iciI/PgH//v38+/r5+Pf29fTz8vHw7+7t7Ovq6ejn5uXk
4+Lh4N/e3dzb2tnY19bV1NPS0dDPzs3My8rJyMfGxcTDwsHAv769vLu6ubi3trW0s7KxsK+u
rayrqqmop6alpKOioaCfnp2cm5qZmJeWlZSTkpGQj46NjIuKiYiHhoWEg4KBgH9+fXx7enl4
d3Z1dHNycXBvbm1sa2ppaGdmZWRjYmFgX15dXFtaWVhXVlVUU1JRUE9OTUxLSklIR0ZFRENC
QUA/Pj08Ozo5ODc2NTQzMjEwLy4tLCsqKSgnJiUkIyIhIB8eHRwbGhkYFxYVFBMSERAPDg0M
CwoJCAcGBQQDAgEAACH5BAEAACAALAAAAAB3ACoAAAb/wINw+HCAjsikcslsOp/QqHS6TDQ+
2KygoKB6v+CwWGkQZLWGsXrNFjMw5yyhTa/bkwpz/DO/+/9gBHtYAgyAh4hNgoNYB4mPiApX
jFlpkJd1D3qUWBcHZwIHBQmYpVQFqKgPn4NbjBh9prJTCgQWe4uMB4azvU4EWwVxCHFbkx8C
Rr7LSLmwmwZxDyAKcaTMvgnFwFi5WBYOD2fT2L6soIvee8nlvtGDDQ0CxK1c7b4XlATxxQ0E
Xfd83dpj4YEBBQYSJuQVkNmeA5YaSgTxjpCyiRMrYriGcaI2ZAzDeBhJMsOACFMqjNQwBQDJ
kRIWoHzi8uVIAE8GeMDpBEtE/zE2SW6YotODhJZBjc5sUtMmzyY6nzLBcIHNyABHKiwYOQUC
yQlSXA44EkHDVZoexlKJ+uRBSKAesB4JwDXKBKNbpToRm+Ts3rRe2Dq58BOuhgCIN3jIkCTB
qCUZ0qr0wEGJAgSxQLhcgDiATggVkCgocFGzB86d5SJBgCCJ4CYWHK1JCqEyEjMClND1gHKz
EnoRm77skGQSR+EkkyxqfeQ1EyzMx4zMAKC619pIbuVOonjBkQ4jl4IAjsSlhOoAvHoAe2QS
Q/PoqyuHjsQ5mSwcRcZFEsHl0CMMFBDSZEGptVpmfCFBgVGiIfBTgopkZl8SFbEDl2ogLKiX
EgvSBsIFhCCA5wFaBkoxIRIVYWEPGCsh1kGH3jURgVfskTVSjUxs1tkAXjH2F2qd2QaVUQMU
WSSGBCEAEBVJGRVaE3dBsMRWPjJFG4ZLIHdTTkmVCMcgBzyQSiqZJRFfdQtMIN4SFADAkhIc
VPckE23Gt4EGczZR55kUPDHBmdXhKA4nhFyQX0emMEDoBw28hags+VAS3aO+MLBJHGVS2osD
rRyqaS/qEOLpp7IkMBAopZE6y2iXNlKYqrKEM8QQF6QKax1BAAA7
--------------050003090804080609010800
Content-Type: image/gif;
 name="logo.gif"
Content-Transfer-Encoding: base64
Content-ID: <part2.00000505.05090706@babel.it>
Content-Disposition: inline;
 filename="logo.gif"

R0lGODlhdwAqANUgAFNRVMbFxvObEIyLjfrXn/jJf/zkv/WvQPnQj/3rz/7473Bucf3y3/a2
UPvdr/jDcCgmKfHw8Tc0OKmoqX99f+Li4vShIPe8YPSoMEVDRpqZm2JgY9TT1Le2txoXG/KU
AP///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH/C1hNUCBEYXRh
WE1QPD94cGFja2V0IGJlZ2luPSLvu78iIGlkPSJXNU0wTXBDZWhpSHpyZVN6TlRjemtjOWQi
Pz4gPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iQWRvYmUg
WE1QIENvcmUgNS4wLWMwNjAgNjEuMTM0Nzc3LCAyMDEwLzAyLzEyLTE3OjMyOjAwICAgICAg
ICAiPiA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjIt
cmRmLXN5bnRheC1ucyMiPiA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIiB4bWxuczp4
bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtbG5zOnhtcE1NPSJodHRwOi8v
bnMuYWRvYmUuY29tL3hhcC8xLjAvbW0vIiB4bWxuczpzdFJlZj0iaHR0cDovL25zLmFkb2Jl
LmNvbS94YXAvMS4wL3NUeXBlL1Jlc291cmNlUmVmIyIgeG1wOkNyZWF0b3JUb29sPSJBZG9i
ZSBQaG90b3Nob3AgQ1M1IFdpbmRvd3MiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6RDk1
QTA4OUZDQkE3MTFERkJCQ0RCNkY0NzdEMjZCRkUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5k
aWQ6RDk1QTA4QTBDQkE3MTFERkJCQ0RCNkY0NzdEMjZCRkUiPiA8eG1wTU06RGVyaXZlZEZy
b20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDpEOTVBMDg5RENCQTcxMURGQkJDREI2RjQ3
N0QyNkJGRSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDpEOTVBMDg5RUNCQTcxMURGQkJD
REI2RjQ3N0QyNkJGRSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1w
bWV0YT4gPD94cGFja2V0IGVuZD0iciI/PgH//v38+/r5+Pf29fTz8vHw7+7t7Ovq6ejn5uXk
4+Lh4N/e3dzb2tnY19bV1NPS0dDPzs3My8rJyMfGxcTDwsHAv769vLu6ubi3trW0s7KxsK+u
rayrqqmop6alpKOioaCfnp2cm5qZmJeWlZSTkpGQj46NjIuKiYiHhoWEg4KBgH9+fXx7enl4
d3Z1dHNycXBvbm1sa2ppaGdmZWRjYmFgX15dXFtaWVhXVlVUU1JRUE9OTUxLSklIR0ZFRENC
QUA/Pj08Ozo5ODc2NTQzMjEwLy4tLCsqKSgnJiUkIyIhIB8eHRwbGhkYFxYVFBMSERAPDg0M
CwoJCAcGBQQDAgEAACH5BAEAACAALAAAAAB3ACoAAAb/wINw+HCAjsikcslsOp/QqHS6TDQ+
2KygoKB6v+CwWGkQZLWGsXrNFjMw5yyhTa/bkwpz/DO/+/9gBHtYAgyAh4hNgoNYB4mPiApX
jFlpkJd1D3qUWBcHZwIHBQmYpVQFqKgPn4NbjBh9prJTCgQWe4uMB4azvU4EWwVxCHFbkx8C
Rr7LSLmwmwZxDyAKcaTMvgnFwFi5WBYOD2fT2L6soIvee8nlvtGDDQ0CxK1c7b4XlATxxQ0E
Xfd83dpj4YEBBQYSJuQVkNmeA5YaSgTxjpCyiRMrYriGcaI2ZAzDeBhJMsOACFMqjNQwBQDJ
kRIWoHzi8uVIAE8GeMDpBEtE/zE2SW6YotODhJZBjc5sUtMmzyY6nzLBcIHNyABHKiwYOQUC
yQlSXA44EkHDVZoexlKJ+uRBSKAesB4JwDXKBKNbpToRm+Ts3rRe2Dq58BOuhgCIN3jIkCTB
qCUZ0qr0wEGJAgSxQLhcgDiATggVkCgocFGzB86d5SJBgCCJ4CYWHK1JCqEyEjMClND1gHKz
EnoRm77skGQSR+EkkyxqfeQ1EyzMx4zMAKC619pIbuVOonjBkQ4jl4IAjsSlhOoAvHoAe2QS
Q/PoqyuHjsQ5mSwcRcZFEsHl0CMMFBDSZEGptVpmfCFBgVGiIfBTgopkZl8SFbEDl2ogLKiX
EgvSBsIFhCCA5wFaBkoxIRIVYWEPGCsh1kGH3jURgVfskTVSjUxs1tkAXjH2F2qd2QaVUQMU
WSSGBCEAEBVJGRVaE3dBsMRWPjJFG4ZLIHdTTkmVCMcgBzyQSiqZJRFfdQtMIN4SFADAkhIc
VPckE23Gt4EGczZR55kUPDHBmdXhKA4nhFyQX0emMEDoBw28hags+VAS3aO+MLBJHGVS2osD
rRyqaS/qEOLpp7IkMBAopZE6y2iXNlKYqrKEM8QQF6QKax1BAAA7
--------------050003090804080609010800--

--------------040507060107060604070106--

--------------060300010003060004010902
Content-Type: text/x-vcard; charset=utf-8;
 name="gmancuso.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="gmancuso.vcf"

YmVnaW46dmNhcmQNCmZuOkdpb3Zhbm5pIE1hbmN1c28NCm46TWFuY3VzbztHaW92YW5uaQ0K
b3JnOkJhYmVsIFMuci5sDQphZHI6OztQLnp6YSBTLkJlbmVkZXR0byBkYSBOb3JjaWEsIDMz
O1BvbWV6aWE7Uk9NQTswMDA0MDtJdGFseQ0KZW1haWw7aW50ZXJuZXQ6Z21hbmN1c29AYmFi
ZWwuaXQNCnRpdGxlOlN5c3RlbSBBcmNoaXRlY3QNCnRlbDt3b3JrOiszOS4wNi45MTgwMTA3
NQ0KdGVsO2ZheDorMzkuMDYuOTE2MTI0NDYNCnRlbDtjZWxsOiszOTM0MDY1ODA3MzkNCnVy
bDpodHRwOi8vd3d3LmJhYmVsLml0DQp2ZXJzaW9uOjIuMQ0KZW5kOnZjYXJkDQoNCg==
--------------060300010003060004010902--