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 1qaIGR-008mar-NQ
	for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Aug 2023 16:05:23 +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 1qaIGO-0018BM-Qc
	for pgsql-hackers@arkaria.postgresql.org; Sun, 27 Aug 2023 16:05:20 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <nagata@sraoss.co.jp>)
	id 1qaIGO-0018B4-FT
	for pgsql-hackers@lists.postgresql.org; Sun, 27 Aug 2023 16:05:20 +0000
Received: from ml.sraoss.co.jp ([66.11.59.17])
	by makus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <nagata@sraoss.co.jp>)
	id 1qaIGL-001Fyu-Gf
	for pgsql-hackers@postgresql.org; Sun, 27 Aug 2023 16:05:18 +0000
Received: from sranhm.sraoss.co.jp (unknown [192.168.174.164])
	by osspc26.sraoss.co.jp (Postfix) with ESMTP id E8CDA2F00100;
	Mon, 28 Aug 2023 01:05:15 +0900 (JST)
Received: from yugon-CFSV7-1 (unknown [192.168.176.1])
	by sranhm.sraoss.co.jp (Postfix) with SMTP id D726E34188A;
	Mon, 28 Aug 2023 01:05:15 +0900 (JST)
Date: Mon, 28 Aug 2023 01:05:15 +0900
From: Yugo NAGATA <nagata@sraoss.co.jp>
To: jian he <jian.universality@gmail.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Incremental View Maintenance, take 2
Message-Id: <20230828010515.050d715e56b2689ffe854da9@sraoss.co.jp>
In-Reply-To: <CACJufxHJQ-Tvxyj1Fy5O3ULXn912bnF1pHfCmLTR72Qcy2_-iQ@mail.gmail.com>
References: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp>
	<20230601034703.9e4f81f5d92ae6e3949b84d2@sraoss.co.jp>
	<CACJufxE8Kct5=c1KKi_JgP09WApCk0Myk6=a5xo05_J_mB7hRQ@mail.gmail.com>
	<20230628170604.505955118ac2f91abd554f13@sraoss.co.jp>
	<CACJufxEA-V+0Fa3Q6xQrFwG6wLs4DsX7E4exdfA=rO-70svmBw@mail.gmail.com>
	<CACJufxHZkF_e4JvcXCfaYkOSs0p6-S2SFQk1+iOHdDL6kvngKg@mail.gmail.com>
	<CACJufxHtG9h_1V2pr+Hx9amWE9fW0z3dcW9t8yMiBgiSsEjBQA@mail.gmail.com>
	<CACJufxHVrgBM1FhM7=df9Cky_uPJ8o3wTjT0iKJWDgmbYPTYqw@mail.gmail.com>
	<CACJufxHJQ-Tvxyj1Fy5O3ULXn912bnF1pHfCmLTR72Qcy2_-iQ@mail.gmail.com>
X-Mailer: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
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/20230828010515.050d715e56b2689ffe854da9%40sraoss.co.jp>
Precedence: bulk

On Fri, 30 Jun 2023 08:00:00 +0800
jian he <jian.universality@gmail.com> wrote:

> Hi there.
> in v28-0005-Add-Incremental-View-Maintenance-support-to-psql.patch
> I don't know how to set psql to get the output
> "Incremental view maintenance: yes"

This information will appear when you use "d+" command for an 
incrementally maintained materialized view.

Regards,
Yugo Nagata


-- 
Yugo NAGATA <nagata@sraoss.co.jp>