Written a lot more on the PostgreSQL design. Just one more diagram and I think the implementation can begin.