[ DESIGN_DATABASE(1) ]

Database Design & Performance Tuning

Schema design, query tuning, replication, zero-downtime migrations.

Schema design from scratch, slow-query analysis (EXPLAIN), index strategy, partitioning, table rewrites without downtime, replica/PITR setup, ETL pipelines. Real case: 9.4B events indexed without gaps.

▶ examples

$ design_database --engine=postgres

$ design_database --partition=range --shards=8

$ ssh contact $ ls ~/projects