From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | David Rees <drees76(at)gmail(dot)com> |
Cc: | david(at)lang(dot)hm, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: I have a fusion IO drive available for testing |
Date: | 2009-03-31 12:20:41 |
Message-ID: | 491f66a50903310520j2d540fa9q3c0f8403bad60c14@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Fri, Mar 27, 2009 at 4:33 PM, David Rees <drees76(at)gmail(dot)com> wrote:
> On Fri, Mar 27, 2009 at 10:30 AM, <david(at)lang(dot)hm> wrote:
> > On Thu, 26 Mar 2009, Dave Cramer wrote:
> >> So far using dd I am seeing around 264MB/s on ext3, 335MB/s on ext2
> write
> >> speed. So the question becomes what is the best filesystem for this
> drive?
> >
> > until the current mess with ext3 and fsync gets resolved, i would say it
> > would probably be a bad choice. I consider ext4 too new, so I would say
> XFS
> > or ext2 (depending on if you need the journal or not)
>
> If you're worried about the performance implications of ext3 in
> data=ordered mode, the best thing to do is to mount the filesystem in
> data=writeback mode instead.
>
> If you're only using the filesystem for PostgreSQL data or logs, your
> data will be just as safe except now that data and metadata won't be
> forced to disk in the order it was written.
>
> And you still get the benefit of a journal so fsck's after a crash will be
> fast.
>
> XFS probably is a decent choice, but I don't have much experience with
> it except on a desktop system where I can tell you that having write
> barriers on absolutely kills performance of anything that does a lot
> of filesystem metadata updates. Again, not a big concern if the
> filesystem is only being used for PostgreSQL data or logs.
>
> -Dave
>
So I tried writing directly to the device, gets around 250MB/s, reads at
around 500MB/s
The client is using redhat so xfs is not an option.
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2009-03-31 14:03:08 | Re: I have a fusion IO drive available for testing |
Previous Message | Matthew Wakeling | 2009-03-31 11:54:44 | Re: Very specialised query |