Are Multi-Column Indexes a good idea?

Поділитися
Вставка
  • Опубліковано 29 січ 2025

КОМЕНТАРІ • 12

  • @LordMakiavel
    @LordMakiavel 4 місяці тому +1

    It would have been interesting to also compare the insert time between 2 indexes vs a 2 columns-index

  • @wexwexexort
    @wexwexexort 5 місяців тому

    is this ui available for to use as a postgres client like pgadmin, dbeaver or datagrip or do I have to use supabase?

    • @ColetonBoyer
      @ColetonBoyer 4 місяці тому

      You can't look at a normal PG db in supabase's UI, no.

    • @Jebusankel
      @Jebusankel 2 місяці тому

      Supabase is open source so you can run its different components yourself with your existing postgres db. It might not be that simple though.

  • @SecretMember-n9d
    @SecretMember-n9d 7 місяців тому

    I have a question.
    Regardless of whether it is a self-host or a cloud, I want to do a global service with a supabase. The problem is that the service is launched in the United States, but it's too slow because it's accessed from various countries. It would be great if supabase could support multi-regions such as read replication and clustering

    • @nicomiebach
      @nicomiebach 7 місяців тому

      Supabase does support multi regions via read replicas.

  • @eleah2665
    @eleah2665 7 місяців тому

    Let's whack an index on that! Thanks Jon.

  • @MrAmG17
    @MrAmG17 7 місяців тому +2

    For me its the sequence in which you have to write the multi-c indexes that makes my brain hurt.

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

    God bless you

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

    Thumbnail said don’t use them. 😅 but watched your whole video and the conclusion is do use them sparingly

  • @dshukertjr
    @dshukertjr 7 місяців тому

    How can we get the nice hoodie you are wearing? 😂

  • @Trilliant-JP
    @Trilliant-JP 7 місяців тому

    Wait, an INDEX can speed up ORDER BY? Learned something new today.