Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 35F7B632CEA for ; Mon, 30 Aug 2010 04:55:44 -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 93323-04 for ; Mon, 30 Aug 2010 07:55:36 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f46.google.com (mail-ew0-f46.google.com [209.85.215.46]) by mail.postgresql.org (Postfix) with ESMTP id 3DFA0632BCA for ; Mon, 30 Aug 2010 04:55:35 -0300 (ADT) Received: by ewy23 with SMTP id 23so2959194ewy.19 for ; Mon, 30 Aug 2010 00:55:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=gFfFsvF+AEV4FfMjlMDijK6MYcisQQwZOIy0cbCC0es=; b=RBTQ9mlO9bpDp0c8Tqf26wbIbyzVPPrqz5z3D2GpiH7WfcEAP/eqvV6tpJjTIfHXDe i6jqg8eF/oJOXoDy4qlsikKvMW37LPQvMDSFNgitecqLT8unM1p7T/XTPU7ZyB3Qeu9u O0r/zuqDpxWT8LKPqpwlrUb1UfieHiDu3Bt9k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=H0+HaUS3TPfO2mS955nou34mpamdevwxZp0f0H0Ta97H1gc9voNgKOZD+IERfZawL4 82ln5Ue5l4oqi7PxqANLnzLHKnVQGk4Gt1jXV+8Kl5M6frLvlrjcYlOy7Ve/upcisspR l/eJKRUoZrPcKPG5G8y9IUAY0fYgfeUOtw8Cs= Received: by 10.227.156.12 with SMTP id u12mr4245374wbw.213.1283154933970; Mon, 30 Aug 2010 00:55:33 -0700 (PDT) Received: from [0.0.0.0] (5357DA75.cable.casema.nl [83.87.218.117]) by mx.google.com with ESMTPS id a1sm6136057wbb.20.2010.08.30.00.55.32 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 30 Aug 2010 00:55:32 -0700 (PDT) Message-ID: <4C7B6498.5040800@gmail.com> Date: Mon, 30 Aug 2010 09:58:16 +0200 From: Yeb Havinga User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Jose Ildefonso Camargo Tolosa CC: "pgsql-performance@postgresql.org" Subject: Re: Performance on new 64bit server compared to my 32bit desktop References: <4C6CE64D.6070104@edd.fr> <4C6D76FE.9010407@2ndquadrant.com> <4C77F4F4.4020900@2ndquadrant.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/315 X-Sequence-Number: 40158 Jose Ildefonso Camargo Tolosa wrote: > Also, nowadays, Intel has better performance than AMD, at least when > comparing Athlon 64 vs Core2, I'm still saving to get a Phenom II > system in order to benchmark them and see how it goes (does anyone > have one of these for testing?). root@p:~/ff/www.cs.virginia.edu/stream/FTP/Code# cat /proc/cpuinfo processor : 0 vendor_id : AuthenticAMD cpu family : 16 model : 4 model name : AMD Phenom(tm) II X4 940 Processor stepping : 2 cpu MHz : 3000.000 cache size : 512 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 initial apicid : 0 fpu : yes fpu_exception : yes cpuid level : 5 wp : yes 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 fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good nonstop_tsc extd_apicid pni monitor cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs skinit wdt bogomips : 6020.46 TLB size : 1024 4K pages clflush size : 64 cache_alignment : 64 address sizes : 48 bits physical, 48 bits virtual power management: ts ttp tm stc 100mhzsteps hwpstate stream compiled with -O3 root@p:~/ff/www.cs.virginia.edu/stream/FTP/Code# ./a.out ------------------------------------------------------------- STREAM version $Revision: 5.9 $ ------------------------------------------------------------- This system uses 8 bytes per DOUBLE PRECISION word. ------------------------------------------------------------- Array size = 2000000, Offset = 0 Total memory required = 45.8 MB. Each test is run 10 times, but only the *best* time for each is used. ------------------------------------------------------------- Printing one line per active thread.... ------------------------------------------------------------- Your clock granularity/precision appears to be 1 microseconds. Each test below will take on the order of 5031 microseconds. (= 5031 clock ticks) Increase the size of the arrays if this shows that you are not getting at least 20 clock ticks per test. ------------------------------------------------------------- WARNING -- The above is only a rough guideline. For best results, please be sure you know the precision of your system timer. ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 5056.0434 0.0064 0.0063 0.0064 Scale: 4950.4916 0.0065 0.0065 0.0065 Add: 5322.0173 0.0091 0.0090 0.0091 Triad: 5395.1815 0.0089 0.0089 0.0089 ------------------------------------------------------------- Solution Validates ------------------------------------------------------------- two parallel root@p:~/ff/www.cs.virginia.edu/stream/FTP/Code# ./a.out & ./a.out ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 2984.2741 0.0108 0.0107 0.0108 Scale: 2945.8261 0.0109 0.0109 0.0110 Add: 3282.4631 0.0147 0.0146 0.0149 Triad: 3321.2893 0.0146 0.0145 0.0148 ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 2981.4898 0.0108 0.0107 0.0108 Scale: 2943.3067 0.0109 0.0109 0.0109 Add: 3283.8552 0.0147 0.0146 0.0149 Triad: 3313.9634 0.0147 0.0145 0.0148 four parallel root@p:~/ff/www.cs.virginia.edu/stream/FTP/Code# ./a.out & ./a.out & ./a.out & ./a.out ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 1567.4880 0.0208 0.0204 0.0210 Scale: 1525.3401 0.0211 0.0210 0.0213 Add: 1739.7735 0.0279 0.0276 0.0282 Triad: 1763.4858 0.0274 0.0272 0.0276 ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 1559.0759 0.0208 0.0205 0.0210 Scale: 1536.2520 0.0211 0.0208 0.0212 Add: 1740.4503 0.0279 0.0276 0.0283 Triad: 1758.4951 0.0276 0.0273 0.0279 ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 1552.7271 0.0208 0.0206 0.0210 Scale: 1527.5275 0.0211 0.0209 0.0212 Add: 1737.9263 0.0279 0.0276 0.0282 Triad: 1757.3439 0.0276 0.0273 0.0278 ------------------------------------------------------------- Function Rate (MB/s) Avg time Min time Max time Copy: 1515.5912 0.0213 0.0211 0.0214 Scale: 1544.7033 0.0210 0.0207 0.0212 Add: 1754.4495 0.0278 0.0274 0.0281 Triad: 1856.3659 0.0279 0.0259 0.0284