PostgreSQL Deep Dive With Hussein Nasser & Ahmed Elemam - Tech Podcast بالعربي

@hnasr Hussein Nasser Will Explain how PostgreSQL actually works internally and go through PostgreSQL Architecture

Questions

  • Can you explain the architecture of PostgreSQL's storage system, including how data is stored on disk and in memory?

  • How does it make sure of data consistency and transactions?

  • How does PostgreSQL handle concurrency and locking, and what are the different levels of isolation?

  • How does PostgreSQL handle indexing and what types of indexes are available?

  • How does PostgreSQL manage and recover from crashes and data corruption?

  • How does PostgreSQL handle data replication and what replication methods are supported?

See All 30 Episodes of "Ahmed Elemam"