Re: Will higher shared_buffers improve tpcb-like benchmarks?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That is likely correct, but the data will likely be stored in the OS file cache, so reading it from there will still be pretty fast.

Right -- but increasing shared_buffers won't increase my TPS, right? Btw, I just realised that irrespective of shared_buffers, my entire DB is already in memory (DB size=30GB, RAM=64GB). I think the following output from iotop confirms this. All throughout the benchmarking (client=1,4,8,12,24,48,96), the disk read values remain zero!

    Total DISK READ :       0.00 B/s | Total DISK WRITE :      73.93 M/s
    Actual DISK READ:       0.00 B/s | Actual DISK WRITE:      43.69 M/s                                                                                        

Could this explain why my TPS numbers are not changing no matter how much I fiddle with the Postgres configuration?

If my hypothesis is correct, increasing the pgbench scale to get a 200GB database would immediately show different results, right?

-- Saurabh.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux