04 - Analytical Database Indexes (CMU Advanced Databases / Spring 2023)

Поділитися
Вставка

КОМЕНТАРІ • 10

  • @BLASTFROMTHEFUTURE
    @BLASTFROMTHEFUTURE Рік тому +5

    [22:00] Note that Postgres' BRIN stands for 'Block Range INdex', and is more similar to Zone Maps than bitmap indexes as described: BRIN contains a summary (e.g. min/max, bloom filter, ) of what data can be expected in each range of blocks in the table, and it does not support addressing individual tuples.

    • @andypavlo
      @andypavlo Рік тому +3

      Yes, somebody else corrected me on Twitter. I will fix for next year. Thanks!

    • @rachelryan5231
      @rachelryan5231 3 місяці тому

      @@andypavlo Your so good! Thanks for uploading. Love from Pakistan 🙏

  • @cvsinpa
    @cvsinpa Рік тому +2

    "places I've lived... Compton"
    I'm slowly getting his sense of humor

    • @StasPakhomov-wj1nn
      @StasPakhomov-wj1nn 11 місяців тому +1

      Yup and the intro/outro music haha, it all clicked for me at that moment too!

  • @MrKKrueger
    @MrKKrueger Рік тому +3

    "You're maybe lit, right?" . . . "What?"

  • @StasPakhomov-wj1nn
    @StasPakhomov-wj1nn 11 місяців тому +1

    I understood everything up until bitweaving and now I am horribly lost :(

  • @JohnKoepi
    @JohnKoepi Рік тому +1

    1:21:22 a crap mention is not muted lol

  • @filipeoliveira7404
    @filipeoliveira7404 Рік тому

    Typo at ua-cam.com/video/lGRAq98ejWs/v-deo.html, the comparison is 6 < 5 not 5 < 6