| From: | "James Mansion" <james(at)mansionfamily(dot)plus(dot)com> |
|---|---|
| To: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | compact flash disks? |
| Date: | 2007-03-06 22:18:57 |
| Message-ID: | HCEPKPMCAJLDGJIBCLGHOEBCHEAA.james@mansionfamily.plus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paolo Negri | 2007-03-06 23:25:58 | problem with wrong query planning and ineffective statistics |
| Previous Message | Zoolin Lin | 2007-03-06 21:49:27 | Any advantage to integer vs stored date w. timestamp |