Re: Adding REPACK [concurrently] - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: Adding REPACK [concurrently]
Date
Msg-id 3436011762001613@a7af8471-b1b8-48c2-9ff7-631187067407
Whole thread Raw
In response to Re: Adding REPACK [concurrently]  (jian he <jian.universality@gmail.com>)
List 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
deletequeries (refresh_by_match_merge in src/backend/commands/matview.c) - so there may be bloat.
 

regards, Sergei



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: contrib/sepgsql regression tests have been broken for months
Next
From: Andrew Dunstan
Date:
Subject: Re: contrib/sepgsql regression tests have been broken for months