Composite indexes

RLS🟢SQL

I was just looking through my schema and noticed I have have primary key indexes, but no composite indexes for the RLS lookups.

Is that something anyone has added?

Was thinking of running something like:

CREATE INDEX CONCURRENTLY idx_org_roles_account_org 
ON org_roles(account, organization);

CREATE INDEX CONCURRENTLY idx_org_roles_account_org 
ON org_roles(account, organization);

My software usage has scaled up a lot and I'm sometimes getting:

canceling statement due to statement timeout

Specifically with too much concurrent usage by one organization.

Composite indexes

Similar Threads

Composite indexes

Similar Threads

Similar Threads

Similar Threads