Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 52654633D39 for ; Wed, 28 Jul 2010 10:24:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 61167-05-4 for ; Wed, 28 Jul 2010 13:24:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms173005pub.verizon.net (vms173005pub.verizon.net [206.46.173.5]) by mail.postgresql.org (Postfix) with ESMTP id 6B41E633045 for ; Wed, 28 Jul 2010 10:24:19 -0300 (ADT) Received: from osgiliath.mathom.us ([unknown] [72.83.250.219]) by vms173005.mailsrvcs.net (Sun Java(tm) System Messaging Server 7u2-7.02 32bit (built Apr 16 2009)) with ESMTPA id <0L69004UBP41BVL7@vms173005.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 28 Jul 2010 07:24:07 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 44D5370160 for ; Wed, 28 Jul 2010 08:24:01 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at mathom.us Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id Ge5ZhuoG40kO for ; Wed, 28 Jul 2010 08:24:01 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 08CEC1FADD; Wed, 28 Jul 2010 08:24:01 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mathom.us; s=mail; t=1280319841; bh=gSbAxDDrGSNP8LFcFG7G32e23FW5/5S1lB4JLR/fsGA=; h=Date:From:To:Subject:Message-ID:References:MIME-Version: Content-Type:In-Reply-To; b=ctiHaGW8Ro/l4EZ1wtddpIk24XOOAUImnOEivz VMzWvPeOIzj2SIer5CpDj8r+fMBRlfttEJAYgeK7P2qCPh/zAn0XeYgvVWwAaELtteC IZDQMSMBmYY/39esn81CA7IeY2+MzkL09EW9wXA+dUO1yLG9I+nLh/XG9dCs9sCPoE= Date: Wed, 28 Jul 2010 08:24:00 -0400 From: Michael Stone To: pgsql-performance@postgresql.org Subject: Re: Testing Sandforce SSD Message-id: Mail-followup-to: pgsql-performance@postgresql.org References: <4C4A9452.9070100@gmail.com> <4C4B1F84.5030306@2ndquadrant.com> <4C4C83DF.3010703@gmail.com> <4C4C8CCC.7080406@gmail.com> <4C4D6396.5020707@gmail.com> <4C4DAAE8.3060501@2ndquadrant.com> <4C4DE50B.1060102@gmail.com> <4C4DE5C9.8090004@2ndquadrant.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline In-reply-to: X-Pgp-Fingerprint: 02D5 315F F11F 1861 860E 1E02 F61A ACDC FA11 FFDE User-Agent: Mutt/1.5.20 (2009-06-14) 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: 201007/433 X-Sequence-Number: 39822 On Mon, Jul 26, 2010 at 03:23:20PM -0600, Greg Spiegelberg wrote: >I know I'm talking development now but is there a case for a pg_xlog block >device to remove the file system overhead and guaranteeing your data is >written sequentially every time? If you dedicate a partition to xlog, you already get that in practice with no extra devlopment. Mike Stone