Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qF1a7-0006Mu-JR for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2023 00:01:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qF1a6-00089B-5b for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2023 00:01:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qF1a5-000891-QK for pgsql-hackers@lists.postgresql.org; Fri, 30 Jun 2023 00:01:45 +0000 Received: from mail-vs1-xe33.google.com ([2607:f8b0:4864:20::e33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qF1a3-001G9Z-Ak for pgsql-hackers@postgresql.org; Fri, 30 Jun 2023 00:01:45 +0000 Received: by mail-vs1-xe33.google.com with SMTP id ada2fe7eead31-44363f4f128so905766137.1 for ; Thu, 29 Jun 2023 17:01:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688083301; x=1690675301; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jlCGvDtamBm1JPVhiD1S3cK3ggL6OV9x6zybGI8YM3Y=; b=EK8w+nQaln7U3RFZ2sl8BJ5OK7o13HySbXkeP9+/ak2lIFpWP3U9jCuH0UzHxr+mKz EUb9dvQozBHqjmXwFPtH9u/0oXU/Dn+/Cv2bsk5U8b7ej7kA+YZnR2hF3D4bYxhx2JjQ pHADYSFrG81/gWwd54iwnU5zwibHCTZcbVFVmZ96yTkolprrWy77WEda+xt7xDbUxj1s EMW3FbNh6oY//nm06w7iNp84Y+5Qn20rNXyheGsrMU26PllS3bunDsbJhirqQatB/5Ep eX9OL7HOiaLsklPWqod1FyiWgstCU3GeF2CHK3TT9PSBk90PEdCQfRg3ixgcji5rkGNL aVIg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688083301; x=1690675301; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=jlCGvDtamBm1JPVhiD1S3cK3ggL6OV9x6zybGI8YM3Y=; b=M0zt2nTQUM4vR6hHPBuviS7lLTtmwN3FI3T4f+EnDIvNo4d50nJpXTLOIZd4y6MdgI aOnpZx/b8NdyMl7bOKF8OfSY9nShbmKkalYvyik6x+r3qli4Oo0+U3Cxib1eK+d5btfF opURZXx3jYnFZh6uX3e2ceqS1CatfOwMDsKIxhngAwjZWzXinfTo/kHKPRPTNys0XXI9 jD3C7AUb+7x/9LjZoaBD4OTE65WphkWXadhX9bxPANkwpx/+2u3qZPnH+fwbno/u43TI vOIcPpCTqKBEHrG17d4WabyLQxZLAFRLBim/qbtso5N4Ymk1oIZvpmiVAZlo0mEgOex/ woGg== X-Gm-Message-State: AC+VfDypre35NY4sUxWHsj4LDlCrmvMV4T1YF8wpstFaQMnF70//7x3J KfLnpdGWeqjV/IN2VM0CsUeygvcQC9cxtTWp6Rs= X-Google-Smtp-Source: ACHHUZ4Ccg7AUjiNR2Vr+C5TGGrz3BbhupRe3BL6Gno/ZCvNcUxWq1nyMWHCQ2vDTL98ufnXxwXINh4E8FpLGZIhqBA= X-Received: by 2002:a67:8c06:0:b0:443:79be:e529 with SMTP id o6-20020a678c06000000b0044379bee529mr1940976vsd.11.1688083301507; Thu, 29 Jun 2023 17:01:41 -0700 (PDT) MIME-Version: 1.0 References: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp> <20230601034703.9e4f81f5d92ae6e3949b84d2@sraoss.co.jp> <20230628170604.505955118ac2f91abd554f13@sraoss.co.jp> In-Reply-To: From: jian he Date: Fri, 30 Jun 2023 08:00:00 +0800 Message-ID: Subject: Re: Incremental View Maintenance, take 2 To: Yugo NAGATA Cc: pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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"