| From: | Sergei Kornilov <sk(at)zsrv(dot)org> |
|---|---|
| To: | jian he <jian(dot)universality(at)gmail(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Antonin Houska <ah(at)cybertec(dot)at>, Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>, Robert Treat <rob(at)xzilla(dot)net>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Subject: | Re: Adding REPACK [concurrently] |
| Date: | 2025-11-01 12:53:33 |
| Message-ID: | 3436011762001613@a7af8471-b1b8-48c2-9ff7-631187067407 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello!
> but materialized views don't have bloat, nothing can be removed.
REFRESH MATERIALIZED VIEW CONCURRENTLY does not replace relation completely but updates the relation using insert and delete queries (refresh_by_match_merge in src/backend/commands/matview.c) - so there may be bloat.
regards, Sergei
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2025-11-01 13:43:42 | Re: contrib/sepgsql regression tests have been broken for months |
| Previous Message | Joe Conway | 2025-11-01 12:50:53 | Re: contrib/sepgsql regression tests have been broken for months |