TechTalk #20: PostgreSQL Internals 101


  • PostgreSQL Internals 101 - Huy Nguyen - CTO, Cofounder - Holistics Software, Cofounder - Grokking Vietnam - Slide
  • Description:
    The talk will cover concepts and internal mechanisms of how PostgreSQL, a popular open-source database, operates. While doing so, I'll also draw similarities to other RDBMS like Oracle, MySQL or SQL Server
    • PostgreSQL internal concepts: table, index, page, heap, vacuum, toast, etc
    • MVCC and relational transactions
    • Indexes and how they affect performance
    • Discuss on Uber's blog post about moving from PostgreSQL to MySQL