Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A473C63230F for ; Wed, 28 Jul 2010 10:22:32 -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 89970-02 for ; Wed, 28 Jul 2010 13:22:24 +0000 (UTC) X-Greylist: delayed 00:59:59.76816 by SQLgrey-1.7.6 Received: from vms173015pub.verizon.net (vms173015pub.verizon.net [206.46.173.15]) by mail.postgresql.org (Postfix) with ESMTP id 7594D6322E8 for ; Wed, 28 Jul 2010 10:22:24 -0300 (ADT) Received: from osgiliath.mathom.us ([unknown] [72.83.250.219]) by vms173015.mailsrvcs.net (Sun Java(tm) System Messaging Server 7u2-7.02 32bit (built Apr 16 2009)) with ESMTPA id <0L690001BP0G2Z34@vms173015.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 28 Jul 2010 07:22:03 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 7B7AD70160 for ; Wed, 28 Jul 2010 08:21:52 -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 YCV+owZpf7oK for ; Wed, 28 Jul 2010 08:21:52 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 48F5F1FADD; Wed, 28 Jul 2010 08:21:52 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mathom.us; s=mail; t=1280319712; bh=HVoeafUpo8pVDWHgBJLNlyrR26nILwtMRkT4o82rB1o=; h=Date:From:To:Subject:Message-ID:References:MIME-Version: Content-Type:In-Reply-To; b=qXppW9ogypVLaGNrjfg+CuNQZUk2mlJDAaKPgh btVga6xYdYK6K9+lBAMUD7bKqBEw1MTCvBOc1LImZ+qcfhn6heuZ3aM+7UBgR7/kxfi cvEmrOTymaUJJx/1/dLPwRvyso9U4aNsypl9kSQMPUqXYtqlYMze1OmdFVeD3zH/8Y= Date: Wed, 28 Jul 2010 08:21:52 -0400 From: Michael Stone To: pgsql-performance@postgresql.org Subject: Re: Testing Sandforce SSD Message-id: <54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us> Mail-followup-to: pgsql-performance@postgresql.org References: <4C4B1F84.5030306@2ndquadrant.com> <4C4C83DF.3010703@gmail.com> <4C4C8CCC.7080406@gmail.com> <4C4DA982.5090308@2ndquadrant.com> <4C4DB736.4020801@gmail.com> <4C4DD6AB.6000805@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/432 X-Sequence-Number: 39821 On Mon, Jul 26, 2010 at 01:47:14PM -0600, Scott Marlowe wrote: >Note that SSDs aren't usually real fast at large sequential writes >though, so it might be worth putting pg_xlog on a spinning pair in a >mirror and seeing how much, if any, the SSD drive speeds up when not >having to do pg_xlog. xlog is also where I use ext2; it does bench faster for me in that config, and the fsck issues don't really exist because you're not in a situation with a lot of files being created/removed. Mike Stone