Make your queries 43,240x faster

[@damnnn.]

SUPABASE is AWESOME. The Dev Team is teaching the product, how it should be. I am new to Supabase and these videos are very useful for me. If it's not important to you, try being overwhelmed with textwall documentations and useless videos.

[@mikelCold]

Amazing explainer for something so basic as indexes. I'm always surprised how can people learn this so late. If there's another video I would recommend going into multiple column indexes too.

[@itscooldawgdonteventrip]

I used to work at EDF (electricite de France ) and we performed for PL/SQL script to update the 40 millions of line of customer to make the database faster. Kinda forgot about all of that. But that was satisfying to do.

[@dshukertjr]

Loving the quote at the end!

[@jitxhere]

Thanks excited to know more about Indexes.

[@todoku1]

maybe a noob question but does the advantage of the postgres query planner also work when I use it from the client side like in flutter? like in 08:05

[@mabud_alam]

Please explain how the pgvector index works

[@m_t_jawaad]

When I tried to index a table, it did improve the query time, but only by a couple of seconds. It was noticeable but not as much as in this video. Does it have anything to do with my supabase plan? I'm using the free tier.

[@poolkrooni]

How big is your dataset? In the video he's dealing with 10M entries

[@harryzachariou1]

Fantastic video!

[@activenode]

Nice one jon!

[@salamandr4111]

that is really helpful! thank you!!

[@sumitpurohit8849]

Can you please update the docs for when to use which distance operator in HNSW and IVFFlat vector indexes. Currently it is unclear weather to use cosine distance, Euclidean distance or negative inner product. Also I would love to have detailed videos/blogs/docs on which embedding model to use for how many words(tokens) of data and also on hybrid search as well.

[@Dom-zy1qy]

Tbh this isn't really something you should be looking at the supabase documentation for.

[@roninspect4357]

will this index will work with iLike queries?

[@althafhussain9718]

In this video, the Explain Analyze tool reported a duration of 3 ms for the first query with username and is_active, and 0.02 ms for the second query with is_active and username. Can you explain why there is such a difference?

[@tylerhartman1630]

I would guess that either the machine is running multiple threads and the thread got swapped to inactive for 1 ms or that it cached the result from the first one, so it already knew the answer for the second one (because it processed it as the same query)

[@laugedyret]

Nice, thanks!

[@JonMeyers]

Glad you enjoyed it! 🙌

[@aLfRemArShMeLlOw]

42069x faster

[@JonMeyers]

Missed opportunity! 😂

[@sire_ns]

Incredible! thanks

[@vincentjohnflorio]

Perfectly explained!

[@itscooldawgdonteventrip]

very didactic

[@PramodGeorge]

Hot Damn!

[@jay_wright_thats_right]

Who told him to act like this on camera? 😆😆😆😆 His arms move for every syllable.

[@uhN0id]

Why did you have to point it out lmao I can't unsee it now

[@GivSadds]

I left you database service , just because you don't have the query rows count features for the application codes . You have only in SQL but not in dart , javascript or any other languages

[@KieranCrown]

You can utilise DB triggers and functions to update the count and query it in the frontend with ease

[@Supabase]

You can get the row count using the count option: supabase.com/docs/reference/javascript/select Also we have count() aggregate function option for counting rows of a referenced table: supabase.com/blog/postgrest-aggregate-functions#the-basics-of-aggregate-functions