Design PostgreSQL tables that fit your workload.
Recent revisions are kept. Restoring one creates a new revision.