> On Oct 8, 2022, at 17:14, Theodore M Rolle, Jr. <stercor@gmail.com> wrote:
>
> What are the pros and cons of using a TF card to store data?
Assuming by TF you mean Transflash, a trade name for SD cards, the bandwidth on them is not particularly spectacular.
Theabsolute fastest is an SDUC card at ~980Mb/s, and real-life performance of them will be considerably lower than that
(especiallygiven that the interfaces that SDUC cards tend to be mounted with are not really design for high speed).
The performance is going to be especially bad in a PostgreSQL environment with constant fsync()-like operations, and
thefile systems that typically are used on SD cards are not really designed for high performance. (exFAT is not
exactlya speed demon.)
Write wear on SD media is also going to be an issue pretty fast.
PostgreSQL will run on SD cards (I've build and run PostgreSQL on Raspberry Pi systems that use SD cards as their
secondarystorage), but it's not something I'd consider for a serious server.