On Sunday, January 15, 2023, jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
>
> 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.