Re: Docs for refresh materialized view concurrently

2019-06-01 Thread Tom Lane
Jeremy Finzel writes: > I've not submitted a patch before, and have a few suggestions I'd like > feedback on before I write one (for the docs only). OK ... > First, even this summary looks untrue: > REFRESH MATERIALIZED VIEW — replace the contents of a materialized view. Agreed. I'd just make

Docs for refresh materialized view concurrently

2019-05-31 Thread Jeremy Finzel
Speaking with Robert today at pgcon, I happily discovered that REFRESH MATERIALIZED VIEW CONCURRENTLY actually only updates rows that have changed since the last refresh, rather than rewriting every row. In my curiosity, I went to the docs, and found that this detail is not mentioned anywhere.