Hacker News new | ask | show | jobs
by IgorPartola 297 days ago
What about materialized views? CPU cache? Only the Sith deal in absolutes :)
1 comments

CPU cache means that the same value read twice will return the same value. Some exceptions for NUMA, and mu[tiple threads. But two reads of a cache cache make no such guarantees.

There is a vast number of undiagnosed race conditions in modern code cause by cache eviction in the middle of 'transactions' under high system load.