Reference and model answers
The cutover runbook, the pushdown walkthrough, and worked rationales for every Postgres migration exercise.
Three pages, each tied to one exercise. Open a model answer only after completing the matching exercise: the cutover runbook and the pushdown walkthrough are the two a participant is most tempted to read early, and both are more useful as a check than as a script.
Cutover runbook
The model answer to module 02's exercise, section by section, with the reasoning behind each line and the commands module 04 executes.
Pushdown walkthrough
How to read EXPLAIN for pg_clickhouse pushdown across the eight panels, and the model repair for the window-function panel.
Knowledge check rationales
The fourteen module 07 questions grouped by theme, written for the ones you got wrong.
| Page | Matching exercise | Open it after |
|---|---|---|
| Cutover runbook | Module 02, authoring runbook/cutover.md | Module 04 Step 2, with your executed runbook beside it |
| Pushdown walkthrough | Module 06 Steps 5 and 6 | Your own EXPLAIN sweep, which is the authority where the two disagree |
| Knowledge check rationales | Module 07, the fourteen questions | Submitting a real attempt |
The runbook page names the step most people miss in module 02. Module 04 either confirms you found it or shows you the failure it causes, and both of those teach — being told here does neither, and it cannot be undone.
Two things deliberately absent. There is no model answer for the engine and ordering-key decision in module 05: the defensible answers differ per table and the reasoning is in that module's own text, where the constraint that decides it is stated. And there is no reference copy of the benchmark figures — every number in this workshop comes from your own two runs with their config blocks, and a published pair would invite comparison between two different machines.