Sign up to save your podcasts
Or
Share 117: Managing Concurrency in Postgres with Bruce Momjian
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
117: Managing Concurrency in Postgres with Bruce Momjian
Following on from our previous look at the Query planner - we are joined again by Bruce Momjian to extend this exploration into looking how Postgres manages concurrency.
We start off by discussing some of the challenges and workarounds used in the past to handle concurrent access, particularly in the eyes of a database administrator.
We then highlight the concept of MVCC, how it works from a high-level, how Postgres implements it and the clean-up considerations that are present.
Finally, we mention how Postgres stores data in page-form, how projects such as pg_compact work to regain space and what the fill-factor is.
Show Links
View all episodes
By Michael Budd, Fraser Hart, Lewis Cains, Edd Mann
4.6
1111 ratings
Following on from our previous look at the Query planner - we are joined again by Bruce Momjian to extend this exploration into looking how Postgres manages concurrency.
We start off by discussing some of the challenges and workarounds used in the past to handle concurrent access, particularly in the eyes of a database administrator.
We then highlight the concept of MVCC, how it works from a high-level, how Postgres implements it and the clean-up considerations that are present.
Finally, we mention how Postgres stores data in page-form, how projects such as pg_compact work to regain space and what the fill-factor is.
Show Links