PostgreSQL In-Depth Training: Fundamentals Part 1

Поделиться
HTML-код
  • Опубликовано: 16 июн 2019
  • Learn more about Amazon Relational Database Service (Amazon RDS) at - amzn.to/2IhBBU0
    Part of a five day PostgreSQL In-Depth Training given in Dublin, Ireland in 2019. Covers the fundamentals of PostgreSQL. The content targets a support teams, but is valuable to all who want to understand the fundamentals of PostgreSQL.
  • НаукаНаука

Комментарии • 26

  • @marcinbadtke
    @marcinbadtke 2 года назад +11

    Thanks for great presentation :-) Can be useful:
    00:01 Greetings
    00:21 Table of Contents
    03:49 Opening
    06:06 General Overview
    08:00 Details
    10:00 Disk Layout
    15:00 "Backend" Process Flow
    18:43 libpg
    22:15 Backend Main Steps
    22:29 parser
    26:32 optimizer
    31:52 executor
    33:59 Auxiliary Processes
    35:35 Pages & Tuples
    37:05 Pages
    38:36 Tuples
    39:40 Learn more
    40:05 MVCC
    46:00 VACUUM
    48:57 WAL
    51:03 Checkpointer & Backgroud-writer
    52:23 Summary

    • @vinicius.schmidt
      @vinicius.schmidt 8 месяцев назад +1

      Thank you so much for indexing it. Rerally appreciate it.
      I'm thining about running another version of this presentation in more calm pace and to try to better speak.

  • @anandakumarsanthinathan4740
    @anandakumarsanthinathan4740 3 года назад +4

    PostgreSQL architecture. A tour of the internals. Very insightful.

  • @samhughes1747
    @samhughes1747 3 года назад +5

    I did not know I so desperately wanted this! I love these kinds of platform deep-dives!

  • @jameshwest
    @jameshwest 3 года назад +5

    Great presentation. Really nice to see the details on what's going on in the postres code. Well done.

  • @mgs3866
    @mgs3866 2 года назад +2

    Nice presentation about the entire Architecture of PostgreSQL and each individual components within it!

  • @chatchaikomrangded960
    @chatchaikomrangded960 3 года назад +5

    It's great for those who want to adopt AWS db freedom, especially Aurora Postgres!

  • @dataxorg4359
    @dataxorg4359 Год назад +1

    Good material in a bullet . Gr8, Thanks

  • @VijayarajChakravarthy
    @VijayarajChakravarthy 5 лет назад +2

    Thanks! Very clear and concise

  • @aws-bound4685
    @aws-bound4685 3 года назад +1

    Very good!

  • @RajatGupta00
    @RajatGupta00 4 года назад +1

    That's informative,

  • @reactorscience
    @reactorscience 3 года назад +1

    Very informative.

  • @minhtienceh
    @minhtienceh 3 года назад +2

    Thanks for sharing
    I would like to have a presentation slide, can you share for me and everyone ? thanks!

  • @JosheCloudDB
    @JosheCloudDB 3 года назад +1

    Good information, How i can get the presentation?

  • @wolfcwb
    @wolfcwb 3 года назад +1

    Vou assistir só pelo sobrenome do cara! :)) (não é verdade, me interesso pelo tema)

  • @cappuccinopapi3038
    @cappuccinopapi3038 2 года назад

    Where’s the time stamp guy?

    • @badscrew4023
      @badscrew4023 2 года назад

      You were elected the time stamp guy!

  • @ozgurdemirci4078
    @ozgurdemirci4078 5 лет назад +1

    HOCAM TÜRKÇE İÇERİKTE EKLERSENİZ HARİKA OLUR

  • @gdevelek
    @gdevelek 2 года назад +4

    It's very tiring to hear a person who has such trouble speaking... Sorry to say....

    • @vinicius.schmidt
      @vinicius.schmidt 8 месяцев назад +2

      I wasn't indeed in my best day - even taking in consideration English is not my first language.

    • @TomWick
      @TomWick 6 месяцев назад +1

      Hi Vinicius. I enjoyed your lecture and I learned a lot as a new user.

    • @xunlu-zq3qr
      @xunlu-zq3qr Месяц назад +1

      @@vinicius.schmidtactually I can understand the talk very well because the speak is very clear and smoothly, even though not in ‘perfect’ or ‘standard’ accent, which is not critical for communication.

  • @RajkumarYadav-fv2xr
    @RajkumarYadav-fv2xr 2 года назад

    Speaking style very bad

    • @vinicius.schmidt
      @vinicius.schmidt 8 месяцев назад

      Well if you consider it's my second language and I'm not very used to speak in public I did quiet OK.
      The fun part is that I wasn't aware this presentation was going to be recorded up to the last minute.
      Let me know which part wasn't clear and I can clarify it to you (or I can send you the Portuguese version)

    • @staffeng
      @staffeng 6 месяцев назад

      @@vinicius.schmidt ignore the ironic comment which wasn't grammatically accurate in the first place. True, it wasn't Shakespeare but it was easy to understand. These are topics where you'll have to pay attention anyway so I found no issues in following what's being discussed.