5mins of Postgres E41: Tuning shared_buffers for OLTP and data warehouse workloads

We're talking about tuning shared_buffers, benchmarking with pgbench, TPROC-C and TPROC-H, and whether using 25% of RAM is a good choice.

Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...

Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
  / pganalyze  

Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources

📑 What we have discussed in this episode of 5mins of Postgres:

Andres Freund’s original tweet
  / 1178765225895399424  

pgbench on postgresql.org
https://www.postgresql.org/docs/curre...

Andres Freund on Twitter
  / andresfreundtec  

Harnessing Shared Buffers (and Reaping the Performance Benefits) - Part 1 - by Shaun Thomas
https://www.enterprisedb.com/blog/har...

Harnessing Shared Buffers - Part 2 - by Shaun Thomas
https://www.enterprisedb.com/blog/har...

Shaun Thomas on Twitter
  / bonesmoses