News for hackers. Stuff that matters.
Re:PostgreSQL 17 by whitepoplar on Thursday September 26, 2024 @01:13PM (#41660826)
There's always the pg_ivm extension you can use in the meantime: https://github.com/sraoss/pg_ivm
Re:PostgreSQL 17 by isoprophlex on Thursday September 26, 2024 @04:11PM (#41662733)
Wow, brilliant! I never knew this existed. Going to try this out tomorrow, first thing!
Re:PostgreSQL 17 by ellisv on Thursday September 26, 2024 @01:32PM (#41661020)
Unfortunately we use a cloud provider to host our databases, so I can only install limited extensions.
Re:PostgreSQL 17 by gregwebs on Thursday September 26, 2024 @03:56PM (#41662565)
REFRESH CONCURRENTLY is already an incremental update of sorts although you still pay the price of running a full query.