PostgreSQL Deep Dive With Hussein Nasser & Ahmed Elemam

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?