Skip to content
117: Managing Concurrency in Postgres with Bruce Momjian episode artwork

Jan 24, 2017 1 hr 21 min

117: Managing Concurrency in Postgres with Bruce Momjian

from Three Devs and a Maybe Hosted by Michael Budd, Fraser Hart, Lewis Cains, Edd Mann

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

117: Managing Concurrency in Postgres with Bruce Momjian

0:00 1:21:38

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Three Devs and a Maybe?

This episode is 1 hour and 21 minutes long.

When was this Three Devs and a Maybe episode published?

This episode was published on January 24, 2017.

Can I download this Three Devs and a Maybe episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.