MVCC in PostgreSQL
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.
No video of the event yet, sorry!
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.
- 2017 September 30 14:00 UTC
- 50 min
- PgConf US Local: Ohio [PgConf.US]