Hacker News new | ask | show | jobs
by whitepoplar 637 days ago
There's always the pg_ivm extension you can use in the meantime: https://github.com/sraoss/pg_ivm
2 comments
ellisv 637 days ago
Unfortunately we use a cloud provider to host our databases, so I can only install limited extensions.
link
gregwebs 637 days ago
REFRESH CONCURRENTLY is already an incremental update of sorts although you still pay the price of running a full query.
link
isoprophlex 637 days ago
Wow, brilliant! I never knew this existed. Going to try this out tomorrow, first thing!
link