X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB638568D9 for ; Tue, 15 Mar 2005 15:25:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74263-05 for ; Tue, 15 Mar 2005 15:25:11 +0000 (GMT) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5EA88568CF for ; Tue, 15 Mar 2005 15:23:54 +0000 (GMT) Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253]) by ucsns.ucs.co.za (Postfix) with ESMTP id 20D022BD57 for ; Tue, 15 Mar 2005 17:23:38 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 0BC1BD9F62 for ; Tue, 15 Mar 2005 17:23:46 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 0470F97AEF for ; Tue, 15 Mar 2005 17:23:46 +0200 (SAST) Date: Tue, 15 Mar 2005 17:23:45 +0200 From: Stef To: pgsql-performance@postgresql.org Subject: Slow loads when indexes added. Message-ID: <20050315172345.7e444432@svb.ucs.co.za> X-Mailer: Sylpheed-Claws 1.0.1 (GTK+ 1.2.10; i386-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.46 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_WHOIS, LONGWORDS X-Spam-Level: * X-Archive-Number: 200503/303 X-Sequence-Number: 11008 --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, I suspect this problem/bug has been dealt with already, but I couldn't find anything in the mail archives. I'm using postgres 7.3, and I managed to recreate the problem using the attached files. The database structure is in slow_structure.sql After creating the database, using this script, I ran run_before_load__fast.sql Then I created a load file using create_loadfile.sh (It creates a file called load.sql) I timed the loading of this file, and it loaded in 1 min 11.567 sec Then I recreated the database from slow_structure.sql, ran run_before_load__slow.sql, and then loaded the same load.sql and it took 3 min 51.293 sec which is about 6 times slower. I tried the same thing on postgres 8.0.0 to see if it does the same thing, but there it was consistently slow : 3 min 31.367 sec The only way I got the load.sql to load fast on postgres 8.0.0, was by not creating any of the foreign key constraints that point to the "main" table, and then enabling them afterwards. This gave me the fastest time overall : 1 min 4.911 sec My problem is that on the postgres 7.3.4 database I'm working with, a load process that used to take 40 minutes, now takes 4 hours, because of 3 rows data being loaded into a table (similar in setup to the "main" table in the example) before the indexes were created. (This happens automatically when you dump and re-import the database (7.3.4)) Is there a way to get it to load fast again on the 7.3 database without dropping the foreign key constraints (After running run_before_load_slow.sql) ? And, if someone knows off-hand, what's happening here? TIA Kind Regards Stefan --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm Content-Type: text/x-sh; name=create_loadfile.sh Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=create_loadfile.sh #!/bin/bash for x in one two three four five six seven eight nine ten do for y in eleven twelve thirteen fourteen fifteen sixteen seventeen eighteen nineteen twenty do for z in `seq 1 100` do echo "insert into main (c_text,d_text) values ('${x}','${y}');" >> load.sql echo "insert into a(id) values (currval('public.main_id_seq'::text));" >> load.sql echo "insert into b(id) values (currval('public.main_id_seq'::text));" >> load.sql echo "insert into e(id) values (currval('public.main_id_seq'::text));" >> load.sql echo "insert into f(id) values (currval('public.main_id_seq'::text));" >> load.sql echo "insert into g(id) values (currval('public.main_id_seq'::text));" >> load.sql echo "insert into h(id) values (currval('public.main_id_seq'::text));" >> load.sql done done done --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm Content-Type: application/octet-stream; name=run_before_load__fast.sql Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=run_before_load__fast.sql Q1JFQVRFIElOREVYIG1haW5fY19pZHggb24gbWFpbiAoY190ZXh0KTsKQ1JFQVRFIElOREVYIG1h aW5fZF9pZHggb24gbWFpbiAoZF90ZXh0KTsKCmNvcHkgbWFpbihpZCxjX3RleHQsZF90ZXh0KSBm cm9tIHN0ZGluOwoxCWVpZ2h0CWZvdXJ0ZWVuCjIJdGhyZWUJZWlnaHRlZW4KMwl0d28JdHdlbHZl ClwuCnNlbGVjdCBzZXR2YWwoJ3B1YmxpYy5tYWluX2lkX3NlcSc6OnRleHQsbWF4KGlkKSkgZnJv bSBtYWluOwo= --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm Content-Type: application/octet-stream; name=run_before_load__slow.sql Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=run_before_load__slow.sql Y29weSBtYWluKGlkLGNfdGV4dCxkX3RleHQpIGZyb20gc3RkaW47CjEJZWlnaHQJZm91cnRlZW4K Mgl0aHJlZQllaWdodGVlbgozCXR3bwl0d2VsdmUKXC4KCkNSRUFURSBJTkRFWCBtYWluX2NfaWR4 IG9uIG1haW4gKGNfdGV4dCk7CkNSRUFURSBJTkRFWCBtYWluX2RfaWR4IG9uIG1haW4gKGRfdGV4 dCk7CnNlbGVjdCBzZXR2YWwoJ3B1YmxpYy5tYWluX2lkX3NlcSc6OnRleHQsbWF4KGlkKSkgZnJv bSBtYWluOwo= --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm Content-Type: application/octet-stream; name=slow_structure.sql Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=slow_structure.sql LS0KLS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wCi0tCgpcY29ubmVjdCAtIHBvc3RncmVzCgpT RVQgc2VhcmNoX3BhdGggPSBwdWJsaWMsIHBnX2NhdGFsb2c7CgotLQotLSBUT0MgZW50cnkgMiAo T0lEIDIwODMxMjI3KQotLSBOYW1lOiBjOyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBwdWJsaWM7IE93 bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIFRBQkxFIGMgKAogICAgY190ZXh0IHRleHQgTk9UIE5V TEwsCiAgICBkZXNjciB0ZXh0Cik7CgoKLS0KLS0gVE9DIGVudHJ5IDMgKE9JRCAyMDgzMTIzNCkK LS0gTmFtZTogZDsgVHlwZTogVEFCTEU7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMK LS0KCkNSRUFURSBUQUJMRSBkICgKICAgIGRfdGV4dCB0ZXh0IE5PVCBOVUxMLAogICAgZGVzY3Ig dGV4dAopOwoKCi0tCi0tIFRPQyBlbnRyeSA0IChPSUQgMjA4MzEyNjMpCi0tIE5hbWU6IG1haW47 IFR5cGU6IFRBQkxFOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUg VEFCTEUgbWFpbiAoCiAgICBpZCBzZXJpYWwgTk9UIE5VTEwsCiAgICBjX3RleHQgdGV4dCwKICAg IGRfdGV4dCB0ZXh0Cik7CgoKLS0KLS0gVE9DIGVudHJ5IDUgKE9JRCAyMDgzMTI4MSkKLS0gTmFt ZTogYTsgVHlwZTogVEFCTEU7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNS RUFURSBUQUJMRSBhICgKICAgIGFfaWQgc2VyaWFsIE5PVCBOVUxMLAogICAgaWQgaW50ZWdlcgop OwoKCi0tCi0tIFRPQyBlbnRyeSA2IChPSUQgMjA4MzEyOTIpCi0tIE5hbWU6IGI7IFR5cGU6IFRB QkxFOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDUkVBVEUgVEFCTEUgYiAo CiAgICBiX2lkIHNlcmlhbCBOT1QgTlVMTCwKICAgIGlkIGludGVnZXIKKTsKCgotLQotLSBUT0Mg ZW50cnkgNyAoT0lEIDIwODMxMzAzKQotLSBOYW1lOiBlOyBUeXBlOiBUQUJMRTsgU2NoZW1hOiBw dWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQ1JFQVRFIFRBQkxFIGUgKAogICAgZV9pZCBzZXJp YWwgTk9UIE5VTEwsCiAgICBpZCBpbnRlZ2VyCik7CgoKLS0KLS0gVE9DIGVudHJ5IDggKE9JRCAy MDgzMTMxNCkKLS0gTmFtZTogZjsgVHlwZTogVEFCTEU7IFNjaGVtYTogcHVibGljOyBPd25lcjog cG9zdGdyZXMKLS0KCkNSRUFURSBUQUJMRSBmICgKICAgIGZfaWQgc2VyaWFsIE5PVCBOVUxMLAog ICAgaWQgaW50ZWdlcgopOwoKCi0tCi0tIFRPQyBlbnRyeSA5IChPSUQgMjA4MzEzMjUpCi0tIE5h bWU6IGc7IFR5cGU6IFRBQkxFOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpD UkVBVEUgVEFCTEUgZyAoCiAgICBnX2lkIHNlcmlhbCBOT1QgTlVMTCwKICAgIGlkIGludGVnZXIK KTsKCgotLQotLSBUT0MgZW50cnkgMTAgKE9JRCAyMDgzMTMzNikKLS0gTmFtZTogaDsgVHlwZTog VEFCTEU7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNSRUFURSBUQUJMRSBo ICgKICAgIGhfaWQgc2VyaWFsIE5PVCBOVUxMLAogICAgaWQgaW50ZWdlcgopOwoKCi0tCi0tIERh dGEgZm9yIFRPQyBlbnRyeSAyNyAoT0lEIDIwODMxMjI3KQotLSBOYW1lOiBjOyBUeXBlOiBUQUJM RSBEQVRBOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpDT1BZIGMgKGNfdGV4 dCwgZGVzY3IpIEZST00gc3RkaW47Cm9uZQlvbmUKdHdvCXR3bwp0aHJlZQl0aHJlZQpmb3VyCWZv dXIKZml2ZQlmaXZlCnNpeAlzaXgKc2V2ZW4Jc2V2ZW4KZWlnaHQJZWlnaHQKbmluZQluaW5lCnRl bgl0ZW4KXC4KCgotLQotLSBEYXRhIGZvciBUT0MgZW50cnkgMjggKE9JRCAyMDgzMTIzNCkKLS0g TmFtZTogZDsgVHlwZTogVEFCTEUgREFUQTsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3Jl cwotLQoKQ09QWSBkIChkX3RleHQsIGRlc2NyKSBGUk9NIHN0ZGluOwplbGV2ZW4JZWxldmVuCnR3 ZWx2ZQl0d2VsdmUKdGhpcnRlZW4JdGhpcnRlZW4KZm91cnRlZW4JZm91cnRlZW4KZmlmdGVlbglm aWZ0ZWVuCnNpeHRlZW4Jc2lzdGVlbgpzZXZlbnRlZW4Jc2V2ZW50ZWVuCmVpZ2h0ZWVuCWVpZ2h0 ZWVuCm5pbmV0ZWVuCW5pbmV0ZWVuCnR3ZW50eQl0d2VudHkKXC4KCgotLQotLSBEYXRhIGZvciBU T0MgZW50cnkgMjkgKE9JRCAyMDgzMTI2MykKLS0gTmFtZTogbWFpbjsgVHlwZTogVEFCTEUgREFU QTsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQ09QWSBtYWluIChpZCwgY190 ZXh0LCBkX3RleHQpIEZST00gc3RkaW47ClwuCgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVudHJ5IDMw IChPSUQgMjA4MzEyODEpCi0tIE5hbWU6IGE7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVi bGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNPUFkgYSAoYV9pZCwgaWQpIEZST00gc3RkaW47Clwu CgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVudHJ5IDMxIChPSUQgMjA4MzEyOTIpCi0tIE5hbWU6IGI7 IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNP UFkgYiAoYl9pZCwgaWQpIEZST00gc3RkaW47ClwuCgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVudHJ5 IDMyIChPSUQgMjA4MzEzMDMpCi0tIE5hbWU6IGU7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTog cHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNPUFkgZSAoZV9pZCwgaWQpIEZST00gc3RkaW47 ClwuCgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVudHJ5IDMzIChPSUQgMjA4MzEzMTQpCi0tIE5hbWU6 IGY7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0K CkNPUFkgZiAoZl9pZCwgaWQpIEZST00gc3RkaW47ClwuCgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVu dHJ5IDM0IChPSUQgMjA4MzEzMjUpCi0tIE5hbWU6IGc7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVt YTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkNPUFkgZyAoZ19pZCwgaWQpIEZST00gc3Rk aW47ClwuCgoKLS0KLS0gRGF0YSBmb3IgVE9DIGVudHJ5IDM1IChPSUQgMjA4MzEzMzYpCi0tIE5h bWU6IGg7IFR5cGU6IFRBQkxFIERBVEE7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMK LS0KCkNPUFkgaCAoaF9pZCwgaWQpIEZST00gc3RkaW47ClwuCgoKLS0KLS0gVE9DIGVudHJ5IDE4 IChPSUQgMjA4MzEyMzIpCi0tIE5hbWU6IGNfcGtleTsgVHlwZTogQ09OU1RSQUlOVDsgU2NoZW1h OiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBjCiAgICBBREQg Q09OU1RSQUlOVCBjX3BrZXkgUFJJTUFSWSBLRVkgKGNfdGV4dCk7CgoKLS0KLS0gVE9DIGVudHJ5 IDE5IChPSUQgMjA4MzEyMzkpCi0tIE5hbWU6IGRfcGtleTsgVHlwZTogQ09OU1RSQUlOVDsgU2No ZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBkCiAgICBB REQgQ09OU1RSQUlOVCBkX3BrZXkgUFJJTUFSWSBLRVkgKGRfdGV4dCk7CgoKLS0KLS0gVE9DIGVu dHJ5IDIwIChPSUQgMjA4MzEyNjkpCi0tIE5hbWU6IG1haW5fcGtleTsgVHlwZTogQ09OU1RSQUlO VDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoKQUxURVIgVEFCTEUgT05MWSBt YWluCiAgICBBREQgQ09OU1RSQUlOVCBtYWluX3BrZXkgUFJJTUFSWSBLRVkgKGlkKTsKCgotLQot LSBUT0MgZW50cnkgMzYgKE9JRCAyMDgzMTI3MSkKLS0gTmFtZTogJDE7IFR5cGU6IENPTlNUUkFJ TlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkg bWFpbgogICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoY190ZXh0KSBSRUZFUkVO Q0VTIGMoY190ZXh0KSBPTiBVUERBVEUgTk8gQUNUSU9OIE9OIERFTEVURSBOTyBBQ1RJT047CgoK LS0KLS0gVE9DIGVudHJ5IDM3IChPSUQgMjA4MzEyNzUpCi0tIE5hbWU6ICQyOyBUeXBlOiBDT05T VFJBSU5UOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpBTFRFUiBUQUJMRSBP TkxZIG1haW4KICAgIEFERCBDT05TVFJBSU5UICIkMiIgRk9SRUlHTiBLRVkgKGRfdGV4dCkgUkVG RVJFTkNFUyBkKGRfdGV4dCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9O OwoKCi0tCi0tIFRPQyBlbnRyeSAyMSAoT0lEIDIwODMxMjg0KQotLSBOYW1lOiBhX3BrZXk7IFR5 cGU6IENPTlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVS IFRBQkxFIE9OTFkgYQogICAgQUREIENPTlNUUkFJTlQgYV9wa2V5IFBSSU1BUlkgS0VZIChhX2lk KTsKCgotLQotLSBUT0MgZW50cnkgMzggKE9JRCAyMDgzMTI4NikKLS0gTmFtZTogJDE7IFR5cGU6 IENPTlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRB QkxFIE9OTFkgYQogICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVS RU5DRVMgbWFpbihpZCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoK Ci0tCi0tIFRPQyBlbnRyeSAyMiAoT0lEIDIwODMxMjk1KQotLSBOYW1lOiBiX3BrZXk7IFR5cGU6 IENPTlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRB QkxFIE9OTFkgYgogICAgQUREIENPTlNUUkFJTlQgYl9wa2V5IFBSSU1BUlkgS0VZIChiX2lkKTsK CgotLQotLSBUT0MgZW50cnkgMzkgKE9JRCAyMDgzMTI5NykKLS0gTmFtZTogJDE7IFR5cGU6IENP TlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxF IE9OTFkgYgogICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVSRU5D RVMgbWFpbihpZCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0t Ci0tIFRPQyBlbnRyeSAyMyAoT0lEIDIwODMxMzA2KQotLSBOYW1lOiBlX3BrZXk7IFR5cGU6IENP TlNUUkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxF IE9OTFkgZQogICAgQUREIENPTlNUUkFJTlQgZV9wa2V5IFBSSU1BUlkgS0VZIChlX2lkKTsKCgot LQotLSBUT0MgZW50cnkgNDAgKE9JRCAyMDgzMTMwOCkKLS0gTmFtZTogJDE7IFR5cGU6IENPTlNU UkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9O TFkgZQogICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVSRU5DRVMg bWFpbihpZCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0tCi0t IFRPQyBlbnRyeSAyNCAoT0lEIDIwODMxMzE3KQotLSBOYW1lOiBmX3BrZXk7IFR5cGU6IENPTlNU UkFJTlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9O TFkgZgogICAgQUREIENPTlNUUkFJTlQgZl9wa2V5IFBSSU1BUlkgS0VZIChmX2lkKTsKCgotLQot LSBUT0MgZW50cnkgNDEgKE9JRCAyMDgzMTMxOSkKLS0gTmFtZTogJDE7IFR5cGU6IENPTlNUUkFJ TlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkg ZgogICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVSRU5DRVMgbWFp bihpZCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0tCi0tIFRP QyBlbnRyeSAyNSAoT0lEIDIwODMxMzI4KQotLSBOYW1lOiBnX3BrZXk7IFR5cGU6IENPTlNUUkFJ TlQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkg ZwogICAgQUREIENPTlNUUkFJTlQgZ19wa2V5IFBSSU1BUlkgS0VZIChnX2lkKTsKCgotLQotLSBU T0MgZW50cnkgNDIgKE9JRCAyMDgzMTMzMCkKLS0gTmFtZTogJDE7IFR5cGU6IENPTlNUUkFJTlQ7 IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkgZwog ICAgQUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVSRU5DRVMgbWFpbihp ZCkgT04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0tCi0tIFRPQyBl bnRyeSAyNiAoT0lEIDIwODMxMzM5KQotLSBOYW1lOiBoX3BrZXk7IFR5cGU6IENPTlNUUkFJTlQ7 IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkgaAog ICAgQUREIENPTlNUUkFJTlQgaF9wa2V5IFBSSU1BUlkgS0VZIChoX2lkKTsKCgotLQotLSBUT0Mg ZW50cnkgNDMgKE9JRCAyMDgzMTM0MSkKLS0gTmFtZTogJDE7IFR5cGU6IENPTlNUUkFJTlQ7IFNj aGVtYTogcHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KCkFMVEVSIFRBQkxFIE9OTFkgaAogICAg QUREIENPTlNUUkFJTlQgIiQxIiBGT1JFSUdOIEtFWSAoaWQpIFJFRkVSRU5DRVMgbWFpbihpZCkg T04gVVBEQVRFIE5PIEFDVElPTiBPTiBERUxFVEUgTk8gQUNUSU9OOwoKCi0tCi0tIFRPQyBlbnRy eSAxMSAoT0lEIDIwODMxMjYxKQotLSBOYW1lOiBtYWluX2lkX3NlcTsgVHlwZTogU0VRVUVOQ0Ug U0VUOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpTRUxFQ1QgcGdfY2F0YWxv Zy5zZXR2YWwgKCdtYWluX2lkX3NlcScsIDEsIGZhbHNlKTsKCgotLQotLSBUT0MgZW50cnkgMTIg KE9JRCAyMDgzMTI3OSkKLS0gTmFtZTogYV9hX2lkX3NlcTsgVHlwZTogU0VRVUVOQ0UgU0VUOyBT Y2hlbWE6IHB1YmxpYzsgT3duZXI6IHBvc3RncmVzCi0tCgpTRUxFQ1QgcGdfY2F0YWxvZy5zZXR2 YWwgKCdhX2FfaWRfc2VxJywgMSwgZmFsc2UpOwoKCi0tCi0tIFRPQyBlbnRyeSAxMyAoT0lEIDIw ODMxMjkwKQotLSBOYW1lOiBiX2JfaWRfc2VxOyBUeXBlOiBTRVFVRU5DRSBTRVQ7IFNjaGVtYTog cHVibGljOyBPd25lcjogcG9zdGdyZXMKLS0KClNFTEVDVCBwZ19jYXRhbG9nLnNldHZhbCAoJ2Jf Yl9pZF9zZXEnLCAxLCBmYWxzZSk7CgoKLS0KLS0gVE9DIGVudHJ5IDE0IChPSUQgMjA4MzEzMDEp Ci0tIE5hbWU6IGVfZV9pZF9zZXE7IFR5cGU6IFNFUVVFTkNFIFNFVDsgU2NoZW1hOiBwdWJsaWM7 IE93bmVyOiBwb3N0Z3JlcwotLQoKU0VMRUNUIHBnX2NhdGFsb2cuc2V0dmFsICgnZV9lX2lkX3Nl cScsIDEsIGZhbHNlKTsKCgotLQotLSBUT0MgZW50cnkgMTUgKE9JRCAyMDgzMTMxMikKLS0gTmFt ZTogZl9mX2lkX3NlcTsgVHlwZTogU0VRVUVOQ0UgU0VUOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6 IHBvc3RncmVzCi0tCgpTRUxFQ1QgcGdfY2F0YWxvZy5zZXR2YWwgKCdmX2ZfaWRfc2VxJywgMSwg ZmFsc2UpOwoKCi0tCi0tIFRPQyBlbnRyeSAxNiAoT0lEIDIwODMxMzIzKQotLSBOYW1lOiBnX2df aWRfc2VxOyBUeXBlOiBTRVFVRU5DRSBTRVQ7IFNjaGVtYTogcHVibGljOyBPd25lcjogcG9zdGdy ZXMKLS0KClNFTEVDVCBwZ19jYXRhbG9nLnNldHZhbCAoJ2dfZ19pZF9zZXEnLCAxLCBmYWxzZSk7 CgoKLS0KLS0gVE9DIGVudHJ5IDE3IChPSUQgMjA4MzEzMzQpCi0tIE5hbWU6IGhfaF9pZF9zZXE7 IFR5cGU6IFNFUVVFTkNFIFNFVDsgU2NoZW1hOiBwdWJsaWM7IE93bmVyOiBwb3N0Z3JlcwotLQoK U0VMRUNUIHBnX2NhdGFsb2cuc2V0dmFsICgnaF9oX2lkX3NlcScsIDEsIGZhbHNlKTsKCgo= --Multipart_Tue__15_Mar_2005_17_23_45_+0200_iq9C8up/zs86qPmm--