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

help / color / mirror / Atom feed
From: Kevin Grittner <kgrittn@ymail.com>
To: Dave Johansen <davejohansen@gmail.com>
To: Shaun Thomas <sthomas@optionshouse.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Unexpected pgbench result
Date: Fri, 20 Dec 2013 07:22:10 -0800 (PST)
Message-ID: <1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CAAcYxUdBAiqPeoTJNUm3A1kEhZcMDfUXKiacD5o14iZ6tko7vg@mail.gmail.com>
References: <CAAcYxUe11Qdx7h3RaRjuGGvp3oO7Wi-QNYrN=9TXBSv+P2u0hg@mail.gmail.com>
	<52B33069.1060203@optionshouse.com>
	<CAAcYxUd7sm6L6p3=bWiFPRm8qpvEu59zHuwtv_ni-HAgHO0PQw@mail.gmail.com>
	<52B44FD8.2030105@optionshouse.com>
	<CAAcYxUdBAiqPeoTJNUm3A1kEhZcMDfUXKiacD5o14iZ6tko7vg@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Dave Johansen <davejohansen@gmail.com> wrote:

> Is there a benefit to having the WAL and logs on the separate
> RAID 1? Or is just having them be part of the larger RAID 1+0
> just as good?

I once accidentally left the pg_xlog directory on the 40-spindle
RAID with most of the data instead of moving it.  Results with
graph here:

http://www.postgresql.org/message-id/4B71358E020000250002F0E4@gw.wicourts.gov

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (7+ messages)  latest in thread

Message-ID: <1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com>
Permalink:  ../1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com/
Also on:    postgresql.org/message-id/1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com

 · 

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: kgrittn@ymail.com, davejohansen@gmail.com, sthomas@optionshouse.com
  Subject: Re: Unexpected pgbench result
  In-Reply-To: <1387552930.9150.YahooMailNeo@web162903.mail.bf1.yahoo.com>

* 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