Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiCSq-0001co-CX for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 07:12:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iiCSp-0008EO-2X for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Dec 2019 07:12:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iiCSo-0008EG-Fb for pgsql-hackers@lists.postgresql.org; Fri, 20 Dec 2019 07:12:42 +0000 Received: from esa10.fujitsucc.c3s2.iphmx.com ([68.232.159.247]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iiCSg-00035p-1R for pgsql-hackers@postgresql.org; Fri, 20 Dec 2019 07:12:41 +0000 IronPort-SDR: TpiyW1difRRRpJS9sxGp1TPSRr3n262y7/Tqa20BfcE1jlK2OjE1VTxDpaTMJh3sEWQIkxCyD5 Xb/ERvRvb8Kwp6kcFyqWYxkjPiP/7HvAMkQ4U8LKbGErtkafp/THUaVxAURl+TLjmNEHBTJkWO M4hnT1qaP/L8f8txco/sH7VXTwEHwzxf6/XUr/zhq++8oCcaoqilMCRPCFrt8H57Cf4DH/B1Xz J83Tdn6/Bo2NLr/V3pRtfG62g/7KHBoVWEfhYySpn2cHXg5wKCfNEvT46/8WM3mkdDyNVdajmI TB0= X-IronPort-AV: E=McAfee;i="6000,8403,9476"; a="8746472" X-IronPort-AV: E=Sophos;i="5.69,334,1571670000"; d="scan'208";a="8746472" Received: from mail-ty1jpn01lp2051.outbound.protection.outlook.com (HELO JPN01-TY1-obe.outbound.protection.outlook.com) ([104.47.93.51]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 20 Dec 2019 16:12:25 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=bYJqo18CK4K8luTfYcrhW7eG/1D1Qtzy1WpqKumss5etO+yoqCQU1fhGhBby0XgxSdJ9yo3H7Ovnafy82MkdfDE2g5zoGiboRrGDYkbxlYafQ85s5+LQ4CBkkaMoyKtZ0nbUIpq+F50QmZ8EE6zgiyI4xuhGV1wUB6ijBYOhSyRLWxaXlQhC51maxtfok13noyjHz3DBO/eCP86LXfTGpGgnKFObRyj3dkRQ5wZA5pQkpfary0MJIlM08yJSanjLOYSDdi2r4vx0gva/tEc6n0EYpm4YWmzQyncQFtyrlQr/RPmyO4XTgLuPLK4X4tOaFf9Bms/h544ja1xqtUIw3w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=nsN9XZQOFEoCzz9BYwVvhtBl5ehj0D0vtvxzDt+FKZY=; b=jfbBHatgrx8ifwZP0vCTi959pszDWM4oq7DwfLOu+7J5VQbX1AuQDv+zna9/+bewOp7m1nO8L7Kq1frOrJYtRQguwp1o9uQqgRPB9vfSRPEnnxVoVBZCtKmYgRUykZ5LUXPOofh8hyLezDWUmiFGJUPnX23affjVCIdJ9AHgIVeGCETLqp5tbsnu4L5znguh5WRduoO+/g3rlRWYnY0ry4HjPP4D648Fu8OvDo6B8sBzdITa51mpPN+J29QynxlObWQhhY02ArELt1QMMGx8MgIcpkcpVxexPWFZJBynzAuM3eTLxU0KzavTlu9aZ7I8QtYmvBUlX9ZKi7U7aJpMIg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=nsN9XZQOFEoCzz9BYwVvhtBl5ehj0D0vtvxzDt+FKZY=; b=grYER8KNZToI4QO+Zp+8ALf6k+IA1k9ewlQDNYOz/0gOkuAwcd3chtHe8vZlzft/wYBCBa1yPh27cbXJHnlx1qirkUGgdmpxW8BUPGrXmQXL+lnRg9C1C4xLjROerSqiXwSI4JNp/Wl+wrn1tO/VXG4jyP6J/r8gsx36CyCKkhs= Received: from OSAPR01MB5073.jpnprd01.prod.outlook.com (20.179.179.15) by OSAPR01MB3139.jpnprd01.prod.outlook.com (52.134.245.81) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2559.15; Fri, 20 Dec 2019 07:12:24 +0000 Received: from OSAPR01MB5073.jpnprd01.prod.outlook.com ([fe80::4459:e7d0:7340:147a]) by OSAPR01MB5073.jpnprd01.prod.outlook.com ([fe80::4459:e7d0:7340:147a%6]) with mapi id 15.20.2559.012; Fri, 20 Dec 2019 07:12:23 +0000 From: "tsunakawa.takay@fujitsu.com" To: 'Yugo Nagata' CC: Tatsuo Ishii , "michael@paquier.xyz" , "amitlangote09@gmail.com" , Takuma Hoshiai , "alvherre@2ndquadrant.com" , "thomas.munro@gmail.com" , "kgrittn@gmail.com" , "pgsql-hackers@postgresql.org" Subject: RE: Implementing Incremental View Maintenance Thread-Topic: Implementing Incremental View Maintenance Thread-Index: AQHVoP5MW2HR/XuY5Ei0uAznagbD+KedDO2AgAADVYCAAtRJAIAAYCsAgADtLACAAF9RgIAAKwYAgAAtBQCAAAEXAIACuTAAgAFygACAABH5AIAce2QAgAAkDrA= Date: Fri, 20 Dec 2019 07:12:23 +0000 Message-ID: References: <20191129181600.7b5dd4167e1753536af33937@sraoss.co.jp> <20191129181954.208da0d63c1ff9e556008e80@sraoss.co.jp> <20191201025514.GY2355@paquier.xyz> <20191202.100118.1160224336488931090.t-ishii@sraoss.co.jp> <20191202110538.a6ff2cd84f488f42eab621eb@sraoss.co.jp> <20191220140232.57b43c4f6296f793d42946b2@sraoss.co.jp> In-Reply-To: <20191220140232.57b43c4f6296f793d42946b2@sraoss.co.jp> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=tsunakawa.takay@fujitsu.com; x-originating-ip: [210.170.118.185] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: f8a9492c-6d7d-4148-ea64-08d7851bf64b x-ms-traffictypediagnostic: OSAPR01MB3139: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:6790; x-forefront-prvs: 025796F161 x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(4636009)(396003)(39860400002)(346002)(366004)(376002)(136003)(199004)(189003)(86362001)(81156014)(6916009)(3480700005)(64756008)(66556008)(71200400001)(66476007)(66446008)(66946007)(478600001)(52536014)(8936002)(8676002)(85182001)(4744005)(5660300002)(4326008)(966005)(76116006)(186003)(26005)(54906003)(16799955002)(7696005)(6506007)(81166006)(33656002)(55016002)(316002)(2906002)(9686003)(777600001);DIR:OUT;SFP:1101;SCL:1;SRVR:OSAPR01MB3139;H:OSAPR01MB5073.jpnprd01.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: RZs6lhKwrAfOJm06blU8caRaCkiUNUwyiwV+8Kmr4drx4kvpyGBB+WGkOFFuj9V970VNFrF83oqn14hu45YUsXEuroHjMSN21fyolwhZDOHiSgdSWFGEGwE34KNdmzO20GEiNMFaavE1JKHYjekTGzlruj02ufrOjkvB3csePJpOm5vVdil5ar8Z+V/x5aIOT4YVUJnBDi19Cxk6RNVHNaIJzMahbbvM1aoFDDAACCrdx9Qig/2096N6F7RTTJscZfLsphw9F/PhvmSgxLybZVm7zVAJGX5/C/e7X9GuJUR7/SlTHt5s0Ab4or6zuCAcfgfLjotW1IiPVu9iEPc7Aspy6kS/Zh3uzY550WiMYSW3DHekk3WMqkqRaV4VaVUI2ZbcPhdj4ib5QyE+tvSt+KGZ5V0YBtHyu56D7f2aRdl/gl1jajoLA7hxaUMLaOf5eNM/XCnG9+3j3Y9Ie+TPidodcurzxVB1vuE6U5Y6FcNnSod3mi6CGnJ+VsA+hiB81eQUPJ45aO3VoYfCwglVstqxm0ga8xkFXLcXtlus67o= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-Network-Message-Id: f8a9492c-6d7d-4148-ea64-08d7851bf64b X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Dec 2019 07:12:23.8346 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 70Y71QCmPZlkrphf8rv/DnYsMFvUkK9MzZedWp69eriPj+wL7bDK6FhqHOblboLNR7AJ0AsI/joF7CdcgN45qcQqwo6Knf9iY4aYzTN/ZZY= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB3139 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, I'm starting to take a closer look at this feature. I've just finished rea= ding the discussion, excluding other referenced materials. The following IVM wiki page returns an error. Does anybody know what's wro= ng? https://wiki.postgresql.org/wiki/Incremental_View_Maintenance [screen] ---------- MediaWiki internal error. Exception caught inside exception handler. Set $wgShowExceptionDetails =3D true; at the bottom of LocalSettings.php t= o show detailed debugging information. ---------- Could you give some concrete use cases, so that I can have a clearer image = of the target data? In the discussion, someone referred to master data wit= h low update frequency, because the proposed IVM implementation adds trigge= rs on source tables, which limits the applicability to update-heavy tables. Regards Takayuki Tsunakawa