Hacker News Reader

There's always the pg_ivm extension you can use in the meantime: https://github.com/sraoss/pg_ivm

Unfortunately we use a cloud provider to host our databases, so I can only install limited extensions.

REFRESH CONCURRENTLY is already an incremental update of sorts although you still pay the price of running a full query.

Wow, brilliant! I never knew this existed. Going to try this out tomorrow, first thing!