About
Douglas is a Data Engineer at OpenSCG where he works alongside leading PostgreSQL experts on a wide variety of PostgreSQL topics as well as the BigSQL distribution of PostgreSQL. He is interested in unusual PostgreSQL deployments and use cases, and has spoken on or taught several topics relating to PostgreSQL at national conferences. Douglas can be found extolling the virtues of the world's most advanced open source database as a member of pgCMH: the Columbus Postgres User's Group.
Douglas Hunley has presented the following presentations
MVCC in PostgreSQL
at
PgConf US Local: Ohio [PgConf.US]
presented by Douglas Hunley
This talk discusses the implementation of MVCC as used by PostgreSQL. It describes the need for and role of MVCC, how PostgreSQL accomplishes the same, and what this implementation means for the db engine. We will discuss transactions, readers vs writers, locking, bloat, and autovacuum. You should be familiar with both SQL and PostgreSQL, but the talk aims to be accessible to beginners.
Sat 30 2017 Postgres