Table Clustering in MySQL and Postgres - The pros and cons

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024

ความคิดเห็น • 20

  • @pythonBlender7
    @pythonBlender7 3 ปีที่แล้ว +3

    Hurray for backend show! Lol its 2:13 AM where I am and I'm managing my new aws servers rollout in the terminal. Great timing!

  • @ayanSaha13291
    @ayanSaha13291 ปีที่แล้ว

    Perfectly explained Hussein! Thanks a lot. I really want to work people like you who I can converse with on multitude of topics.

  • @omarizhar3069
    @omarizhar3069 3 ปีที่แล้ว

    Beautifully explained man, one thing that I got to wonder is that does AWS Redshift leverage users' querying patterns to recluster the tables to optimize performance. seems like the only way to do so based on your explanation.

  • @hnasr
    @hnasr  3 ปีที่แล้ว

    Check out my udemy Introduction to Database Engineering course
    husseinnasser.com/courses
    Learn the fundamentals of database systems to understand and build performant backend apps

  • @AadithyaMD
    @AadithyaMD 2 ปีที่แล้ว +2

    6:44 there is no link to B tree video

  • @86Saurabh1
    @86Saurabh1 2 ปีที่แล้ว

    Great video as usual. I had couple of questions. As you have mentioned that we can have a clustering index on the grade column, which I am assuming is not unique, does this affect when we are inserting the data in the table or do databases have a mechanism to create each entry in the grade column as unique, something which SQL Server does. And is it best practice to have Clustered index on a unique and non-null column or it depends upon the queries the user is going to use?

  • @void_star_void
    @void_star_void 3 ปีที่แล้ว

    Hey man tnx for the vid. Can you point out resources to know more about internals of db as a backend dev? (perf tuning, trade-offs, indexing, etc.)

  • @abdulhafeezabdulraheem2048
    @abdulhafeezabdulraheem2048 3 ปีที่แล้ว +1

    Love the hair! Awesome content as usual

    • @hnasr
      @hnasr  3 ปีที่แล้ว

      Thanks !

  • @roumakchakraborty3407
    @roumakchakraborty3407 3 ปีที่แล้ว

    Do I see a Katana on the book rack?

  • @sivalingamsubbiah855
    @sivalingamsubbiah855 3 ปีที่แล้ว

    I like the content, I am having a hard time understanding what a page means, page == a file in disk?

  • @soulofjack7294
    @soulofjack7294 3 ปีที่แล้ว +3

    is it katana in the back?

  • @mdgolamkibria9864
    @mdgolamkibria9864 2 ปีที่แล้ว

    Every one showing mysql clustering on youtube(percona xtradb ,galera,group replication,etc).
    But i want to do simple write and read replicas and also integrate with demo with frontend+backend app!.
    Load balance with all them .
    Can some one show me the demo.Oh i am frustrated.!!!!
    Please give me proper guide someone...

  • @anclaudys
    @anclaudys 3 ปีที่แล้ว +2

    You make backend engineering feel like philosophy.

  • @albinpaul3429
    @albinpaul3429 3 ปีที่แล้ว +2

    I liked your old hairstyle. 😅

  • @Flankymanga
    @Flankymanga 3 ปีที่แล้ว

    You cluster your data in a table and then Postgre will keep appending inserts?! What the... I thought that the reason behind the clustering was to have data ordered based on some index and KEEP IT that way... I would be ok if they offered a "Append inserts" functionality as a optional behaviour after clustering if you are ok with re-clusteding data once in a while but to do it by default?! If this is the case then what was the point of clustering when you cannot keep it/

    • @annalisetrite7281
      @annalisetrite7281 3 ปีที่แล้ว +1

      I think even a one time clustering could benefit you bc it will rewrite like rows into the same page. So that’s less pages to read which is less IO

  • @AndersonSilvaMMA
    @AndersonSilvaMMA 3 ปีที่แล้ว +1

    Finally first

  • @barebears289
    @barebears289 3 ปีที่แล้ว

    "Some of them will get 10" 🤒