In the following example, I cannot see bloat (via extension pgstattuple dead_tuple_count>0). Wondering where the bloat is.--------do the update.
update tbt set a = 10 + a where a < 20;
REFRESH MATERIALIZED view tbtmv;
SELECT * FROM pgstattuple('tbtmv'); -----no dead tuples count.
You didn’t specify concurrently so the merge method you quoted is not being used.
David J.
