4 ms·
Postgres is still going through the motions of a transaction for every query you issue it even if nothing else but that transaction is happening on the server.
by hbrid 10y ago
Postgres is still going through the motions of a transaction for every query you issue it even if nothing else but that transaction is happening on the server. So obviously if you add extra load in the form of writes, you may slow your reads down, but this was not a full benchmark, but instead a comparison of the same workload running against multiple versions of Postgres.
- Tostino 10y agoHuh, that's funny to see a comment of mine copied word for word from Reddit: https://www.reddit.com/r/programming/comments/4in70l/postgresql_scalability_towards_millions_tps/d2zo1kl?context=3 https://www.reddit.com/r/programming/comments/4in70l/postgre...