any other observations or insights after running this thing for a while?

Interesting. Lists could be optimised in the backend by indexing the pks and storing only the lists of indexes.

I understand.

In my own relayer, soon to be open source, I'm storing things as raw JSON. I am thinking to compress and store as binary (same format as the data to be signed). Maybe that will save some percentage.