Here is a talk I gave at PGCon 2019 titled Temporal Databases: Theory and Postgres. The slides are built from this git repo.