The Backend Engineering Show with Hussein Nasser cover image

All Postgres Locks Explained | A Deep Dive

The Backend Engineering Show with Hussein Nasser

00:00

Introduction

There are three level of logs, table logs, page and row level logs. A table log by certain type just means that something happened to this table. It doesn't mean you cannot edit this table. You can absolutely do that. The same thing with the row level logs,. which is easier to understand and page logs, which we have zero knowledge about Postgres that, at least from the dock. But that's what I wanted to do in this video. I just want to go through the different types of logs, confusing as they are, name-wise, and just try to know what operation to acquire. If I do a vacuum full, what can’t I do?

Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner