Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D44931337B4E for ; Mon, 9 May 2011 20:52:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 79663-07 for ; Mon, 9 May 2011 23:52:21 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qw0-f46.google.com (mail-qw0-f46.google.com [209.85.216.46]) by mail.postgresql.org (Postfix) with ESMTP id 52E911337B69 for ; Mon, 9 May 2011 20:52:21 -0300 (ADT) Received: by qwk3 with SMTP id 3so3435412qwk.19 for ; Mon, 09 May 2011 16:52:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type:content-transfer-encoding; bh=kE30wFYNmmkXMlcjFxN6UnHbiBcTeGD/7C+Idk+e35M=; b=i69iOf761Jbu3sKTos3GxNdUxGlSQrWnKXCnVt/UhYKoiLmFqxoI8W5728pPoLyGzA 6/SqUoRlFZFxcPt9V7SI9rTaGsv3cd4iF7gatoWqXyO2d+5NQOerQYLfmzR2qUGu5aOR CZ7C+rXGaXxjyk+ekmGxwQzaHPcypxOoIBvdI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=ThlPH+vlJlRfg+4cxgOzvFYfg1i8Z6XLJ/8pGTShrg/fNCouWsaNzIGcivXxluc8TO +XJDP/+je+c3Uc84c3danLw+12q6o/yHKbzB34wGrlKXViA6SsrjAq0EsHg2kpj9j3XI GwHjPt247KP0eUYarFYZhTF5C/EQTZmnIbhAQ= Received: by 10.229.67.66 with SMTP id q2mr5446519qci.282.1304985141143; Mon, 09 May 2011 16:52:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.84.16 with HTTP; Mon, 9 May 2011 16:52:01 -0700 (PDT) In-Reply-To: References: From: =?ISO-8859-1?Q?C=E9dric_Villemain?= Date: Tue, 10 May 2011 01:52:01 +0200 Message-ID: Subject: Re: Benchmarking a large server To: Chris Hoover Cc: PGSQL Performance Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201105/103 X-Sequence-Number: 43612 2011/5/9 Chris Hoover : > I've got a fun problem. > My employer just purchased some new db servers that are very large. =A0Th= e > specs on them are: > 4 Intel X7550 CPU's (32 physical cores, HT turned off) > 1 TB Ram > 1.3 TB Fusion IO (2 1.3 TB Fusion IO Duo cards in a raid 10) > 3TB Sas Array (48 15K 146GB spindles) > The issue we are running into is how do we benchmark this server, > specifically, how do we get valid benchmarks for the Fusion IO card? > =A0Normally to eliminate the cache effect, you run iozone and other bench= mark > suites at 2x the ram. =A0However, we can't do that due to 2TB > 1.3TB. > So, does anyone have any suggestions/experiences in benchmarking storage > when the storage is smaller then 2x memory? You can reduce the memory size on server boot. If you use linux, you can add a 'mem=3D512G' to your boot time parameters. (maybe it supports only K or M, so 512*1024...) > Thanks, > Chris --=20 C=E9dric Villemain=A0 =A0 =A0 =A0 =A0 =A0 =A0=A0 2ndQuadrant http://2ndQuadrant.fr/=A0 =A0=A0 PostgreSQL : Expertise, Formation et Suppo= rt