How Do I Simulate a Delete and Update in Postgres?

In addition to tables and row locks, page level shared exclusive locks are used to control read, write access to table pages in the shared buffer pool. These locks are released immediately after a row is fetched or updated. This tells me that you know to transaction, these two things are serialized, right? The page locks are being obtained to prevent to threads to process from updating the same page.

Transcript

Play full episode

Remember Everything You Learn from Podcasts

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