i wonder what your long-term storage requirements ...
# server
g
i wonder what your long-term storage requirements are for these - if each row is fairly small you might be able to use something like kafka, with a reader cache that just holds the latest updated row for your frequent queries.