Chris van Eijk: PostgreSQL indexes for multi-tenant SaaS: tenant_id first

T2Covered by 1 source · first reported by Planet PostgreSQL at 27 Sept, 22:30 UTC

Five indexes, 1,000 tenants, one query, measured in PostgreSQL 17: why tenant_id goes first, what RLS does to the plan, and when partitioning pays off.

cloud

Sources

• T2Chris van Eijk: PostgreSQL indexes for multi-tenant SaaS: tenant_id firstPlanet PostgreSQL27 Sept, 22:30