Sounds like easily within capabilities of Postgres on a surprisingly small box.

→ View original post on X — @patio11