|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
At 05:18 PM 3/6/2007, James Mansion wrote:
Most flash RAMs have drivers that make sure the pattern of writes over time is uniform across the entire device.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 the WAL on a fast SATA or SAS drive pair. I'm thinking 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.
WARNING: modern TOtL flash RAMs are only good for ~1.2M writes per memory cell. and that's the =good= ones. Using flash RAM for write heavy applications like OLTP, or for WAL, etc can be very dangerous
Flash write speeds also stink; being ~1/2 flash's already low read speed. Much better to use flash RAM for read heavy applications.Even there you have to be careful that seek performance, not throughput, is what is gating your day to day performance with those tables.
Got tables or indexes that are a= too big to fit in RAM and b= are write few, read many times and c= whose pattern of access is large enough that it does not cache well? =Those= are what should be put into flash RAMs Side Note:In the long run, we are going to have to seriously rethink pg's use of WAL as the way we implement MVCC as it becomes more and more of a performance bottleneck. We have WAL because Stonebreaker made an assumption about the future dominance of optical media that has turned out to be false.
...and it's been one of pg's big issues every since.
Heck =16= GB Flash only costs ~$300 US and 128GB SSDs based on flash RAM are due out this year.2GB CF isn't so pricey any more.
[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]