Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D0AA9632D1B for ; Tue, 9 Feb 2010 13:37:52 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 32135-02 for ; Tue, 9 Feb 2010 17:37:40 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.26]) by mail.postgresql.org (Postfix) with ESMTP id D736E633AC9 for ; Tue, 9 Feb 2010 13:37:41 -0400 (AST) Received: by qw-out-2122.google.com with SMTP id 5so893997qwd.61 for ; Tue, 09 Feb 2010 09:37:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :from:date:message-id:subject:to:cc:content-type; bh=iw+jTjYtgtP8G0NJ8uSWPiQ2sR3nGE63trCxxbImETE=; b=H7yvFhn0keuz4yzLW3+q5gcI8RCMoVDztpvYvvnWAdUCjLafs0Svf0xPdgOLWk2xM+ dzuVwknlm7r9ueHA1QdIkyRXrzRSEYreacC1z/gQLj+ekx8pGuEVjgrua84cGxoOCfmO wxQTPV55WJOYLeDnbv0qT8Iumk32ASN1vYQnk= 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; b=KyjxvKAurx3pxSuytomYWD4ie92R2RNLgjAgcaIBFewDGuNmgSYMYgRrzjgFmH5uYa bPe3a9Dp070LOcasf+m3yuOaPPtBK8lP6jFP9ZEMuiYA4VpWmjGAoT1PqUYvmScjB2II ENMtLhp+BKTtb6HEmM84Fy6F1hzm6RKsVuiCg= MIME-Version: 1.0 Received: by 10.229.69.98 with SMTP id y34mr1261000qci.55.1265737061179; Tue, 09 Feb 2010 09:37:41 -0800 (PST) In-Reply-To: <4B7139DD020000250002F0E9@gw.wicourts.gov> References: <4B71358E020000250002F0E4@gw.wicourts.gov> <4B718BDB.8080807@krogh.cc> <4B7139DD020000250002F0E9@gw.wicourts.gov> From: Amitabh Kant Date: Tue, 9 Feb 2010 23:07:21 +0530 Message-ID: <84b68b3d1002090937r774bb46ds7ab110c6f66cef70@mail.gmail.com> Subject: Re: moving pg_xlog -- yeah, it's worth it! To: Kevin Grittner Cc: Jesper Krogh , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=0021cc0233d2e9223d047f2e5fc3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.971 tagged_above=-10 required=5 tests=AWL=0.627, BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201002/139 X-Sequence-Number: 37560 --0021cc0233d2e9223d047f2e5fc3 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Feb 9, 2010 at 10:03 PM, Kevin Grittner wrote: > Jesper Krogh wrote: > File system is xfs noatime,nobarrier for all data; OS is on ext3. I > *think* the pg_xlog mirrored pair is hanging off the same > BBU-writeback controller as the big RAID, but I'd have to track down > the hardware tech to confirm, and he's out today. System has 16 > Xeon CPUs and 64 GB RAM. > > -Kevin > > Hi Kevin Just curious if you have a 16 physical CPU's or 16 cores on 4 CPU/8 cores over 2 CPU with HT. With regards Amitabh Kant --0021cc0233d2e9223d047f2e5fc3 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Tue, Feb 9, 2010 at 10:03 PM, Kevin Grittner = <Kevin.= Grittner@wicourts.gov> wrote:
Jesper Krogh <jesper@krogh.cc> wrote:
File system is xfs noatime,nobarrier for all data; OS is on ext3. =A0I
<= /div> *think* the pg_xlog mirrored pair is hanging off the same
BBU-writeback controller as the big RAID, but I'd have to track down the hardware tech to confirm, and he's out today. =A0System has 16
Xeon CPUs and 64 GB RAM.

-Kevin


Hi Kevin

Just curious if you have a 16 physical CPU's or 16= cores on 4 CPU/8 cores over 2 CPU with HT.

With regards

Amitabh Kant
--0021cc0233d2e9223d047f2e5fc3--