3 ms·
cool article! It would be great to know the SDCard speed and maybe see some comparisons based on the SDCard type since the speeds vary quite a bit see also: h
by cat199 8y ago
cool article!
It would be great to know the SDCard speed and maybe see some comparisons based on the SDCard type since the speeds vary quite a bit
see also: https://en.wikipedia.org/wiki/SD_card#Speed https://en.wikipedia.org/wiki/SD_card#Speed
- jng 8y agoI believe Raspberry Pi's SDCard port is limited to a bit below 25 MB/s, so that's gonna be the actual limit very often.
- megous 8y agoThere's also IOPS for random 4k block access, which is usually way below 25MB/s. Typically around 2000/500 r/w IOPS for regular A1 cards. With expensive cards you can get to 2500-3000 range. Read queries will be cached in RAM and fast (for <1GB database), and write queries will be limited to 500 IOPS, and heavily dependent on how you use transactions and write queries in your database. Also disabling statistics collecting is the first thing I do when putting a postgresql db on an sd card. Because that causes a lot! of writes.