2 ms·
This is really awesome. I've spent a ton of time optimizing high throughput PG instances. Every time one of my optimizations failed it was from an incomplete un
by scosman 11y ago
This is really awesome. I'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/or MVCC.
These 2 docs really help with a deeper understanding if you want to learn more:
http://momjian.us/main/writings/pgsql/internalpics.pdf http://momjian.us/main/writings/pgsql/internalpics.pdf
http://momjian.us/main/writings/pgsql/mvcc.pdf http://momjian.us/main/writings/pgsql/mvcc.pdf