What would you consider to be small or medium? I have a use case for analytics on ~1 billion rows that are about 1TB in postgres. Have you tried on that volume?
I think your project is great. I suspect incremental updates will be a big feature for most uptake (one we would need to try this out at least).