3 ms·
The issue isn't so much the speed as yes I use bulk SQL statements and can upsert like 4-5k rows per second, it's more the disk writes which I find unsettling a
by madjam002 4y ago
The issue isn't so much the speed as yes I use bulk SQL statements and can upsert like 4-5k rows per second, it's more the disk writes which I find unsettling as after a few months I've noticed several 10s of TBs of disk writes from Postgres onto the SSDs which seems like unnecessary wear.
- qeternity 4y agoSeveral 10s of TBs of writes over a few months is literally nothing to be concerned about for any recently modern enterprise ssd in a production setting. This seems like a bizarre rationale to make a database choice.
- crazygringo 4y agoThen it seems your setup is totally fine. If you're upserting 10 million rows a day with lots of columns, then of course you're going to be seeing TB's of disk writes. And remember that SSD's can't even write individual bytes the way HDD's can, they necessarily write a whole page at a time, which might be 4K or 16K, even if you're just updating a single integer. Your database and SSD are functioning totally normally, as designed.