Are Multi-Column Indexes a good idea?

  Рет қаралды 5,388

Supabase

Supabase

Күн бұрын

Пікірлер: 12
@LordMakiavel
@LordMakiavel 3 ай бұрын
It would have been interesting to also compare the insert time between 2 indexes vs a 2 columns-index
@SecretMember-n9d
@SecretMember-n9d 6 ай бұрын
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 6 ай бұрын
Supabase does support multi regions via read replicas.
@wexwexexort
@wexwexexort 4 ай бұрын
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 3 ай бұрын
You can't look at a normal PG db in supabase's UI, no.
@Jebusankel
@Jebusankel Ай бұрын
Supabase is open source so you can run its different components yourself with your existing postgres db. It might not be that simple though.
@eleah2665
@eleah2665 6 ай бұрын
Let's whack an index on that! Thanks Jon.
@MrAmG17
@MrAmG17 6 ай бұрын
For me its the sequence in which you have to write the multi-c indexes that makes my brain hurt.
@StephenRayner
@StephenRayner 2 ай бұрын
Thumbnail said don’t use them. 😅 but watched your whole video and the conclusion is do use them sparingly
@lararawf6100
@lararawf6100 2 ай бұрын
God bless you
@dshukertjr
@dshukertjr 6 ай бұрын
How can we get the nice hoodie you are wearing? 😂
@Trilliant-JP
@Trilliant-JP 6 ай бұрын
Wait, an INDEX can speed up ORDER BY? Learned something new today.
8 things you should NEVER do in a Database!
22:56
Supabase
Рет қаралды 13 М.
OCCUPIED #shortssprintbrasil
0:37
Natan por Aí
Рет қаралды 131 МЛН
Caleb Pressley Shows TSA How It’s Done
0:28
Barstool Sports
Рет қаралды 60 МЛН
13min High Intensity Postgres Workout (NO REPEATS)
13:20
Supabase
Рет қаралды 6 М.
Postgres scales … when you do this!
9:59
Supabase
Рет қаралды 6 М.
Make your queries 43,240x faster
13:16
Supabase
Рет қаралды 27 М.
AWK - A Tool That Does Too Much
11:10
The Exhausted Programmer
Рет қаралды 25 М.
How do indexes make databases read faster?
23:25
Arpit Bhayani
Рет қаралды 77 М.
Faster database indexes (straight from the docs)
13:28
PlanetScale
Рет қаралды 127 М.
3 reasons you should use Postgres Functions and Transactions
16:58
Everything you NEED TO KNOW about Relationships
13:53
Supabase
Рет қаралды 4 М.
They Enabled Postgres Partitioning and their Backend fell apart
31:52
Hussein Nasser
Рет қаралды 44 М.
OCCUPIED #shortssprintbrasil
0:37
Natan por Aí
Рет қаралды 131 МЛН