pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: James Mansion <james@mansionfamily.plus.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Stef Telford <stef@ummon.com>
Cc: Mark Kirkwood <markir@paradise.net.nz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Raid 10 chunksize
Date: Thu, 02 Apr 2009 20:16:30 +0100
Message-ID: <49D50F0E.6050807@mansionfamily.plus.com> (raw)
In-Reply-To: <alpine.GSO.2.01.0904020437080.17611@westnet.com>
References: <C5F933B9.40BB%scott@richrelevance.com>
	<alpine.GSO.2.01.0904020437080.17611@westnet.com>

Greg Smith wrote:
> OK, that's clearly cached writes where the drive is lying about fsync. 
> The claim is that since my drive supports both the flush calls, I just 
> need to turn on barrier support, right?
>
That's a big pointy finger you are aiming at that drive - are you sure 
it was sent the flush instruction?  Clearly *something* isn't right.

> This is basically how this always works for me:  somebody claims 
> barriers and/or SATA disks work now, no really this time.  I test, 
> they give answers that aren't possible if fsync were working properly, 
> I conclude turning off the write cache is just as necessary as it 
> always was.  If you can suggest something wrong with how I'm testing 
> here, I'd love to hear about it.  I'd like to believe you but I can't 
> seem to produce any evidence that supports you claims here.
Try similar tests with Solaris and Vista?

(Might have to give the whole disk to ZFS with Solaris to give it 
confidence to enable write cache, which mioght not be easy with a laptop 
boot drive: XP and Vista should show the toggle on the drive)

James




view thread (59+ messages)  latest in thread

Message-ID: <49D50F0E.6050807@mansionfamily.plus.com>
Permalink:  ../49D50F0E.6050807@mansionfamily.plus.com/
Also on:    postgresql.org/message-id/49D50F0E.6050807@mansionfamily.plus.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: james@mansionfamily.plus.com, gsmith@gregsmith.com, scott@richrelevance.com, stef@ummon.com, markir@paradise.net.nz
  Subject: Re: Raid 10 chunksize
  In-Reply-To: <49D50F0E.6050807@mansionfamily.plus.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