Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D17AF64FD8E for ; Fri, 24 Oct 2008 02:41:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 93493-07 for ; Fri, 24 Oct 2008 02:41:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.176]) by postgresql.org (Postfix) with ESMTP id 2B99964FD46 for ; Fri, 24 Oct 2008 02:41:50 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id j4so372227wah.19 for ; Thu, 23 Oct 2008 22:41:49 -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:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=/VwXuLwlq136CUXRGuP1/87wJPYP12mq/eX9WPqfcgk=; b=l/Tx8Ik6UCZ/EWzmo0Xals6HvbuRsn5qZjFIE4gn0Vlaoohc/+d+Yum7HEQRnacHVQ 7JmUcW8xtvRez53nrPyHds6/nmepcluFiMek+7/fLkIYMnMNB6ztywwB8aKLus/Ful+P tg2nGUEjRXcA1Sd1N5/EMJrstTWs9dOkwuJfM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=AYBBxxM99uLL45+j/s9FCpV7aOrc0nTrccfIM7G9eFnvQfUSMiblfI0UXncH7IF/vg J8tw2waMbHw6wVOo6l2RrG+3KklyMF0uAaGBOxqpbWRnOD590nC6DnmiwZ/PHGlmB9lD Br9fzs+hAR5sqJ/od1mVWzD8z8lLEn0yDhGlk= Received: by 10.114.195.19 with SMTP id s19mr1537101waf.59.1224826909222; Thu, 23 Oct 2008 22:41:49 -0700 (PDT) Received: by 10.114.39.11 with HTTP; Thu, 23 Oct 2008 22:41:49 -0700 (PDT) Message-ID: Date: Thu, 23 Oct 2008 23:41:49 -0600 From: "Scott Marlowe" To: "Scott Carey" Subject: Re: Hardware HD choice... Cc: Lionel , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/109 X-Sequence-Number: 31690 On Thu, Oct 23, 2008 at 8:48 PM, Scott Carey wrote: > If you are doing batch inserts of data, and want to have reporting queries > concurrently running, make sure you have the pg_xlogs on a different disk > than the data/indexes. 2 drives RAID 1 for OS + xlogs works great (and