pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Anj Adu <fotographs@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: more 10K disks or less 15K disks
Date: Thu, 29 Apr 2010 13:25:06 -0600
Message-ID: <z2gdcc563d11004291225g3e34196eu42379ae4356a1c1f@mail.gmail.com> (raw)
In-Reply-To: <u2yf2fd819a1004291026z89cbd919m7d11c74f9b14a1eb@mail.gmail.com>
References: <i2pf2fd819a1004281127sf91d988cua1d95d13d09dae09@mail.gmail.com>
	<4BD8DCEA.2020003@2ndquadrant.com>
	<u2zf2fd819a1004282145wc60c3b39o7f0679fec9f607f8@mail.gmail.com>
	<4BD9198E.904@2ndquadrant.com>
	<u2yf2fd819a1004291026z89cbd919m7d11c74f9b14a1eb@mail.gmail.com>

On Thu, Apr 29, 2010 at 11:26 AM, Anj Adu <fotographs@gmail.com> wrote:
> All the disks are usually laid out in a single RAID 10 stripe . There
> are no dedicated disks for the OS/WAL as storage is a premium

You should at least investigate the performance difference of having a
separate volume for WAL files on your system.    Since WAL files are
mostly sequential, and db access is generally random, the WAL files
can run really quickly on a volume that does nothing else but handle
WAL writes sequentially.  Given the volume you're handling, I would
expect that storage is not any more important than performance.

The fact that you're asking whether to go with 12 or 24 600G disks
shows that you're willing to give up a little storage for performance.
 I would bet that the 24 10k disks with one pair dedicated for OS /
pg_xlog would be noticeably faster than any single large volume config
you'd care to test, especially for lots of active connections.



view thread (19+ messages)  latest in thread

Message-ID: <z2gdcc563d11004291225g3e34196eu42379ae4356a1c1f@mail.gmail.com>
Permalink:  ../z2gdcc563d11004291225g3e34196eu42379ae4356a1c1f@mail.gmail.com/
Also on:    postgresql.org/message-id/z2gdcc563d11004291225g3e34196eu42379ae4356a1c1f@mail.gmail.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-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, fotographs@gmail.com, greg@2ndquadrant.com
  Subject: Re: more 10K disks or less 15K disks
  In-Reply-To: <z2gdcc563d11004291225g3e34196eu42379ae4356a1c1f@mail.gmail.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