
By Franck Pachot . In a recent tweet I wanted to highlight the importance of knowing what you measure with pgbench, because looking at “Transactions per second” without knowing if you are in shared buffer cache hits, or filesystem cache hit, or storage cache hit, or physical read… is just meaningless: When you run the #postgres builtin pgbench, you should know: – the size of the dataset on disk, about 15MB x scale – the…