| From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
|---|---|
| To: | David Rees <drees76(at)gmail(dot)com> |
| Cc: | Scott Carey <scott(at)richrelevance(dot)com>, Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Raid 10 chunksize |
| Date: | 2009-03-25 03:29:17 |
| Message-ID: | alpine.GSO.2.01.0903242326090.16570@westnet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 24 Mar 2009, David Rees wrote:
> I would tend to recommend ext3 in data=writeback and make sure that
> it's mounted with noatime over using ext2 - for the sole reason that
> if the system shuts down unexpectedly, you don't have to worry about a
> long fsck when bringing it back up.
Well, Mark's system is already using noatime, and if you believe
http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/
there's little difference between writeback and ordered on the WAL disk.
Might squeeze out some improvements with ext2 though, and if there's
nothing besides the WAL on there fsck isn't ever going to take very long
anyway--not much of a directory tree to traverse there.
--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryan Murphy | 2009-03-25 03:43:37 | Re: Help Me Understand Why I'm Getting a Bad Query Plan |
| Previous Message | Mark Kirkwood | 2009-03-25 03:20:52 | Re: Raid 10 chunksize |