
When an UPDATE Isn’t Really an Update: MySQL vs PostgreSQL (A Deep Dive into the I/O Reality)
When an UPDATE Isn’t Really an Update: MySQL vs PostgreSQL (A Deep Dive into the I/O Reality) If you’ve ever read that “MySQL can update a row in-place without touching indexes” but thought: “Wait — doesn’t SSD copy it to a new location anyway? Shouldn’t the index change?” …you’re not