Re: Adding REPACK [concurrently]

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: Adding REPACK [concurrently]
Дата
Msg-id 3436011762001613@a7af8471-b1b8-48c2-9ff7-631187067407
обсуждение исходный текст
Ответ на Re: Adding REPACK [concurrently]  (jian he <jian.universality@gmail.com>)
Список 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 по дате отправления: