Comment by MBCook

Yep this is it. Since you mostly view the newest stuff you could even have a partial index only over the records that are considered current.

And it’s PG’s range queries that make this shine, as you showed. If you had to simulate the range with two columns all the queries would be a pain.