Query indexing

Is there any way I can auto write indexes for slow performing queries?

What happens if I don’t have query indexes at all?
Does supabase creates them automatically by checking a pattern of query?

garyaustin•12/31/23, 2:25 PM

You have to study performance issues or Postgres guides or ask here with specific questions on an operation/table setup and maybe someone can offer suggestions.

There are no automatic indexes except for unique columns and primary keys.

garyaustin•12/31/23, 2:38 PM

In particular columns that are queried a lot are candidates or those used in RLS.

Query indexing

Similar Threads

Similar Threads

Similar Threads