pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: Testing Sandforce SSD
Date: Wed, 28 Jul 2010 08:21:52 -0400
Message-ID: <54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us> (raw)
In-Reply-To: <AANLkTine0bsX_dvQgncDn600Vmt4KoUb3vSL3LW9qocB@mail.gmail.com>
References: <4C4B1F84.5030306@2ndquadrant.com>
	<4C4C83DF.3010703@gmail.com>
	<4C4C8CCC.7080406@gmail.com>
	<alpine.DEB.2.00.1007261045470.20471@aragorn.flymine.org>
	<4C4DA982.5090308@2ndquadrant.com>
	<alpine.DEB.2.00.1007261632380.20471@aragorn.flymine.org>
	<4C4DB736.4020801@gmail.com>
	<AANLkTikSLLcUKdD=mZhN4MnSyUAvmgGqnmPCFKdmXbAJ@mail.gmail.com>
	<4C4DD6AB.6000805@2ndquadrant.com>
	<AANLkTine0bsX_dvQgncDn600Vmt4KoUb3vSL3LW9qocB@mail.gmail.com>

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



view thread (60+ messages)  latest in thread

Message-ID: <54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us>
Permalink:  ../54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us/
Also on:    postgresql.org/message-id/54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mstone+postgres@mathom.us
  Subject: Re: Testing Sandforce SSD
  In-Reply-To: <54bfd3f0-9a42-11df-9b6a-001cc0cda50c@msgid.mathom.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox