Это пробный урок. Оформите подписку, чтобы получить доступ ко всем материалам курса. Премиум

  1. Урок 1. 00:58:27
    001 Basic query executor
  2. Урок 2. 00:42:43
    002 A brief overview of query execution using EXPLAIN
  3. Урок 3. 00:12:27
    003 Observing PostgreSQL client and server communication
  4. Урок 4. 00:22:19
    004 A very brief history of early DBMSs
  5. Урок 5. 00:08:43
    005 Column vs row stores
  6. Урок 6. 00:04:51
    006 What is the core of a core dump or out of core sort
  7. Урок 7. 01:03:36
    007 CSV FileScan
  8. Урок 8. 02:06:34
    008 Heap File
  9. Урок 9. 01:01:10
    009 Basic inserts
  10. Урок 10. 00:35:22
    010 The layout of a PostgreSQL table
  11. Урок 11. 01:00:55
    011 Nested loops join
  12. Урок 12. 00:40:18
    012 Hash join
  13. Урок 13. 01:38:55
    013 Sort-merge join
  14. Урок 14. 00:58:22
    014 Aggregation
  15. Урок 15. 00:20:50
    015 What is a join
  16. Урок 16. 00:18:54
    016 The three basic join stratgies
  17. Урок 17. 00:15:25
    017 Nested loop variants and practical considerations
  18. Урок 18. 00:14:58
    018 Hash join variants and practical considerations
  19. Урок 19. 00:30:28
    019 Transactions the big picture
  20. Урок 20. 01:25:26
    020 B tree in memory
  21. Урок 21. 03:04:07
    021 B tree on disk
  22. Урок 22. 00:45:32
    022 What every programmer should know about B trees