Description
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?