compact flash disks? - Mailing list pgsql-performance

From James Mansion
Subject compact flash disks?
Date
Msg-id HCEPKPMCAJLDGJIBCLGHOEBCHEAA.james@mansionfamily.plus.com
Whole thread Raw
Responses Re: compact flash disks?  ("Merlin Moncure" <mmoncure@gmail.com>)
Re: compact flash disks?  (Florian Weimer <fweimer@bfk.de>)
Re: compact flash disks?  (Ron <rjpeace@earthlink.net>)
Re: compact flash disks?  (cedric <cedric@over-blog.com>)
List pgsql-performance
I see that one can now get compact flash to SATA connectors.

If I were to use a filesystem with noatime etc and little non-sql traffic,
does the physical update pattern tend to have hot sectors that will tend to
wear out CF?

I'm wondering about a RAID5 with data on CF drives and RAID1 for teh WAL on
a fast SATA or SAS drive pair.  I'm thhinking that this would tend to have
good performance because the seek time for the data is very low, even if the
actual write speed can be slower than state of the art.  2GB CF isn't so
pricey any more.

Just wondering.

James

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 05/03/2007
09:41


pgsql-performance by date:

Previous
From: "Paolo Negri"
Date:
Subject: problem with wrong query planning and ineffective statistics
Next
From: "Merlin Moncure"
Date:
Subject: Re: compact flash disks?