Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id AE9BF632327 for ; Thu, 19 Aug 2010 15:31:50 -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 51329-05 for ; Thu, 19 Aug 2010 18:31:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id 40F3C63232E for ; Thu, 19 Aug 2010 15:31:43 -0300 (ADT) Received: from [192.168.1.151] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap0) with ESMTP (Nemesis) id 0MIh7g-1OjwyS4BKa-002PAh; Thu, 19 Aug 2010 20:31:41 +0200 Message-ID: <4C6D788B.2090308@2ndquadrant.com> Date: Thu, 19 Aug 2010 14:31:39 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Philippe Rimbault 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> In-Reply-To: <4C6D76FE.9010407@2ndquadrant.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:erl1Wq9GcV0moxU0HKU37212TK45BrTne8AjMQBqO8t /GmbMGq7P1fmblV+acMBow0mHFZzpJIdI0l3BH3p17U3RneVJe s30pIJ8cik9tQxL6V8DEgivP/rmdmO1xHkuKxuWwRgtmnZ33jd VZP6OWdi2qkTC5QL0rODS0I1kQtKcdL6+9+UVSDFtsMEz7rC23 mIsnf/bWlsl/f+hBj2UBWgqZTqrJC85l5q1bznC5mo= 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/236 X-Sequence-Number: 40079 Greg Smith wrote: > Since your smaller system has 2GB of RAM and the larger one 32GB, try > this instead: > > pgbench -i -s 2000 > pgbench -c 24 -T 60 -S > pgbench -c 24 -T 300 Oh, and to at least give a somewhat more normal postgresql.conf I'd recommend you at least make the following two changes before doing the above: shared_buffers=256MB checkpoint_segments=32 Those are the two parameters the pgbench test is most sensitive to, so setting to higher values will give more realistic results. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us