Are Multi-Column Indexes a good idea?

  Рет қаралды 3,636

Supabase

Supabase

Күн бұрын

Пікірлер: 9
@LordMakiavel
@LordMakiavel 15 күн бұрын
It would have been interesting to also compare the insert time between 2 indexes vs a 2 columns-index
@MrAmG17
@MrAmG17 3 ай бұрын
For me its the sequence in which you have to write the multi-c indexes that makes my brain hurt.
@wexwexexort
@wexwexexort Ай бұрын
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 18 күн бұрын
You can't look at a normal PG db in supabase's UI, no.
@dshukertjr
@dshukertjr 3 ай бұрын
How can we get the nice hoodie you are wearing? 😂
@eleah2665
@eleah2665 3 ай бұрын
Let's whack an index on that! Thanks Jon.
@SecretMember-n9d
@SecretMember-n9d 3 ай бұрын
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 3 ай бұрын
Supabase does support multi regions via read replicas.
@Trilliant-JP
@Trilliant-JP 3 ай бұрын
Wait, an INDEX can speed up ORDER BY? Learned something new today.
Make your queries 43,240x faster
13:16
Supabase
Рет қаралды 25 М.
Как мы играем в игры 😂
00:20
МЯТНАЯ ФАНТА
Рет қаралды 3,1 МЛН
when you have plan B 😂
00:11
Andrey Grechka
Рет қаралды 66 МЛН
How Strong is Tin Foil? 💪
00:26
Preston
Рет қаралды 122 МЛН
Electric Flying Bird with Hanging Wire Automatic for Ceiling Parrot
00:15
Everything you NEED TO KNOW about Relationships
13:53
Supabase
Рет қаралды 2,3 М.
UUID vs INT: What’s Better For Your Primary Key?
9:40
Database Star
Рет қаралды 40 М.
7 Advanced PivotTable Techniques That Feel Like Cheating
16:07
MyOnlineTrainingHub
Рет қаралды 43 М.
Microservices with Databases can be challenging...
20:52
Software Developer Diaries
Рет қаралды 46 М.
Faster database indexes (straight from the docs)
13:28
PlanetScale
Рет қаралды 126 М.
Simplify complex SQL queries with Views in Postgres
26:01
Supabase
Рет қаралды 9 М.
DHH discusses SQLite (and Stoicism)
54:00
Aaron Francis
Рет қаралды 74 М.
They Enabled Postgres Partitioning and their Backend fell apart
31:52
Hussein Nasser
Рет қаралды 41 М.
Production SQLite with Turso and libSQL
1:02:53
Aaron Francis
Рет қаралды 9 М.
Как мы играем в игры 😂
00:20
МЯТНАЯ ФАНТА
Рет қаралды 3,1 МЛН