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

Vacuumful Removes Physically Removes All These Space

Vacuumful removes physically remove all these space, no compact the table. If you have pages 0 to 10 and all are dead, the whole page is over renamed. We started over from page 0 and start moving day round. So it has to acquire access exclusive to do all this. Refresh materialize view. Materialize view is a view that is materialized as persisted on desk.

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