Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected pgbench result - Mailing list pgsql-performance

From Dave Johansen
Subject Re: Unexpected pgbench result
Date
Msg-id CAAcYxUdmRRMssGHHEqwr5vqSV8PG_EZaH_0AvZt=aHHFSHbkfw@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected pgbench result  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-performance
Tree view
On Fri, Dec 20, 2013 at 8:22 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
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

That's very helpful information. Thanks for sharing it,
Dave

pgsql-performance by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Unexpected pgbench result
Next
From: Dave Johansen
Date:
Subject: Re: Recommendations for partitioning?