Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vFB6z-008jvv-N6
	for pgsql-hackers@arkaria.postgresql.org; Sat, 01 Nov 2025 12:53:41 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vFB6y-0053oa-Gt
	for pgsql-hackers@arkaria.postgresql.org; Sat, 01 Nov 2025 12:53:39 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <sk@zsrv.org>)
	id 1vFB6y-0053oS-7T
	for pgsql-hackers@lists.postgresql.org; Sat, 01 Nov 2025 12:53:39 +0000
Received: from forward502d.mail.yandex.net
 ([2a02:6b8:c41:1300:1:45:d181:d502])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <sk@zsrv.org>)
	id 1vFB6u-005PvU-0y
	for pgsql-hackers@lists.postgresql.org;
	Sat, 01 Nov 2025 12:53:38 +0000
Received: from mail-nwsmtp-mxback-production-main-358.klg.yp-c.yandex.net
 (mail-nwsmtp-mxback-production-main-358.klg.yp-c.yandex.net
 [IPv6:2a02:6b8:c42:6c23:0:640:a9c:0])
	by forward502d.mail.yandex.net (Yandex) with ESMTPS id ACA97C17CE;
	Sat, 01 Nov 2025 15:53:33 +0300 (MSK)
Received: from mail.yandex.ru (2a02:6b8:c42:4e23:0:640:1cad:0
 [2a02:6b8:c42:4e23:0:640:1cad:0])
	by mail-nwsmtp-mxback-production-main-358.klg.yp-c.yandex.net (mxback/Yandex)
 with HTTPS id UrgG0W61uKo0-cbD8ykwE;
	Sat, 01 Nov 2025 15:53:33 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail;
	t=1762001613; bh=DrYcxcX67tKGxu+aOv89ZXWTTp4tiA/BDpblLBSIK8M=;
	h=Message-Id:References:Date:Cc:Subject:In-Reply-To:To:From;
	b=juIIcct4nK2bumxpeLfbkBPniq3fJ2FKd2O0YczOFo/4Y+Q/whwwXH+x1+wLi/7Ba
	 d66wtCSBOTAYxATerKBRkSpQPmGwiqPxn6zwxHpvTHIBkNjg5feTHp/Ad45hZOPn8p
	 inEW20XI+11cXbBcW2TmmZcbTUlIn8lJciguUBn4=
Authentication-Results: 
 mail-nwsmtp-mxback-production-main-358.klg.yp-c.yandex.net;
 dkim=pass header.i=@zsrv.org
Received: by mail-sendbernar-production-main-58.klg.yp-c.yandex.net
 (sendbernar/Yandex) with HTTPS id ae78b71895e61e3ab14125430589cfe6;
	Sat, 01 Nov 2025 15:53:33 +0300
From: Sergei Kornilov <sk@zsrv.org>
To: jian he <jian.universality@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>,
	Antonin Houska <ah@cybertec.at>,
	Mihail Nikalayeu <mihailnikalayeu@gmail.com>,
	Robert Treat <rob@xzilla.net>,
	Alvaro Herrera <alvherre@alvh.no-ip.org>
In-Reply-To: 
 <CACJufxFO-rU4+kQZUPuukPpY7-i1DPgKBsz+O2SK1XxdTivajQ@mail.gmail.com>
References: <202507262156.sb455angijk6@alvherre.pgsql>
 <202510301734.pj4uds3mqxx4@alvherre.pgsql>
 <CACJufxFO-rU4+kQZUPuukPpY7-i1DPgKBsz+O2SK1XxdTivajQ@mail.gmail.com>
Subject: Re: Adding REPACK [concurrently]
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Sat, 01 Nov 2025 15:53:33 +0300
Message-Id: <3436011762001613@a7af8471-b1b8-48c2-9ff7-631187067407>
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/3436011762001613%40a7af8471-b1b8-48c2-9ff7-631187067407>
Precedence: bulk

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