TRILHA 01
🐘
Database Deep — Postgres Internals
Postgres profissional além do CRUD: MVCC e isolation levels reais (snapshot, serializable, RR, RC), query planner com EXPLAIN ANALYZE, índices avançados (B-tree, BRIN, GIN, GiST, partial, covering), vacuum e bloat (causa #1 de DB morrendo), connection pooling (pgbouncer), replication (sync/async, failover), partitioning declarativo. Capstone: tuning real de workload.
- MVCC e isolation levels de verdade (sem simplificação)
- Query planner: EXPLAIN ANALYZE ninja
- Índices avançados: B-tree, BRIN, GIN, GiST, partial, covering
- Vacuum, autovacuum e bloat: causa #1 de DB morrendo
- + 4 artigos
8 ARTIGOS · 495 XPAbrir→