Everybody focusing on wrong things. The critical issue here is PostgreSQL's write-ahead logging system which constantly hammers storage with small sequential writes. Consumer SSDs optimize for random performance at expense of sustained sequential writes, leading to severe performance degradation over time regardless of theoretical specs