PostgreSQL Indexing & Query Optimization
PostgreSQL Index Types, EXPLAIN ANALYZE & Query Tuning
B-Tree, BRIN, GIN, GiST index selection, EXPLAIN (ANALYZE, BUFFERS) node analysis, slow query triage via pg_stat_statements, and autovacuum/index maintenance guides.
Other Reference Guides
Other reference posters and cheatsheets curated for database administrators.
psql CLI Quick Reference
Comprehensive reference poster covering connection parameters, meta commands (\d, \l, \du), .psqlrc template, COPY streaming, and real-time activity/lock triage queries.
InnoDB Tuning Reference
Buffer pool sizing formula, redo log and flush policies, I/O capacity and thread tuning, production-grade my.cnf template, and SHOW ENGINE INNODB STATUS triage guide.
PostgreSQL Security Hardening
pg_hba.conf hardening rules, SCRAM-SHA-256 password policies, SSL/TLS certificate verification, pgaudit audit trails, public schema lockdown, and single-query security check scripts.
PostgreSQL Backup & Recovery Reference
Logical backups with pg_dump/pg_dumpall, physical backups with pg_basebackup and pgBackRest, WAL archiving, Point-in-Time Recovery (PITR), and disaster recovery playbooks.
MySQL Backup & Recovery Reference
Logical backups with mysqldump and MySQL Shell dumpInstance, physical backups with MEB and Percona XtraBackup, Point-in-Time Recovery via binary logs, and the CLONE plugin.
MySQL OCP 8.0 DBA Exam Topic Map
All 7 domains of Oracle 1Z0-908 MySQL 8.0 Database Administrator exam: Architecture, Install/Config, Security, Monitoring, Query Optimization, Backup/Recovery, HA (InnoDB Cluster), and pitfalls.
