This is really awesome. I&#x27;ve spent a ton of time optimizing high throughput PG instances. Every time one of my optimizations failed it was from an incomplete understanding of the physical storage layer and&#x2F;or MVCC.<p>These 2 docs really help with a deeper understanding if you want to learn more:
<a href="http:&#x2F;&#x2F;momjian.us&#x2F;main&#x2F;writings&#x2F;pgsql&#x2F;internalpics.pdf" rel="nofollow">http:&#x2F;&#x2F;momjian.us&#x2F;main&#x2F;writings&#x2F;pgsql&#x2F;internalpics.pdf</a>
<a href="http:&#x2F;&#x2F;momjian.us&#x2F;main&#x2F;writings&#x2F;pgsql&#x2F;mvcc.pdf" rel="nofollow">http:&#x2F;&#x2F;momjian.us&#x2F;main&#x2F;writings&#x2F;pgsql&#x2F;mvcc.pdf</a>