Supabase: The Complete Guide
Correct & Fast
Correct & Fast
Transactions, MVCC and bloat, the lost update, B-trees, indexing in practice, GIN and JSONB, reading a plan, security_invoker views.
0 / 8 concepts complete
2930313233343536
Transactions & ACID
Data~80%
MVCC, dead tuples, VACUUM & bloat
Perf~60%
Isolation, the lost update & deadlocks
Data~65%
How a B-tree index works
Perf~85%
Indexing in practice
Perf~90%
Beyond B-tree: GIN, GiST, BRIN & JSONB
Perf~60%
EXPLAIN ANALYZE: reading a plan
Perf~70%
Views & security_invoker
Schema~55%