How does that work though? If you have multiple instances that are serving the same traffic, how do one know about the change made by the other? Is it a global timer? i.e. any write affects reads, or it knows and only works on the same table?

Why not keep dependent operations within the same transaction? If that would be done by rails from the start then I could just easily split read/write through pgpool.