I use a Pro card meant for cameras. Also, Prometheus disk write load is tiny.

IMO, you really don’t want to run databases over NFS/SMB. I’ve just seen too many corruption and locking issues over the years to trust it.

For home lab use, do you really need anything as big enough for a database that wouldn’t fit on a Pi anyway?

For example, I run Prometheus on my Pi, no problem.