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 1ijAoM-0007gG-M0 for pgsql-hackers@arkaria.postgresql.org; Sun, 22 Dec 2019 23:38:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ijAoL-0008Ef-Ch for pgsql-hackers@arkaria.postgresql.org; Sun, 22 Dec 2019 23:38:57 +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 1ijAoK-0008EY-Oy for pgsql-hackers@lists.postgresql.org; Sun, 22 Dec 2019 23:38:57 +0000 Received: from esa1.fujitsucc.c3s2.iphmx.com ([68.232.152.245]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ijAoG-0003AR-Vl for pgsql-hackers@postgresql.org; Sun, 22 Dec 2019 23:38:55 +0000 IronPort-SDR: 6YTNvxIfGdfKBwSUHoLGTmgBsZkRyd2L2QEUu/EgqwRjuKSb7sEs6zdfYF/F3DmO/KwW+RRjLy 50reTITNXWYvnkwFolvfXqvtekcG5+sczmhW2mHJLKpBXua7CX0fkF/RinQ9QKxOF3ALirq7xR cqhIB8pOCgt4w5OxobubR0AJ53OLEPzRQuvlC8VPGvDxYIVCwKjmUzq32lF8CPre6RkbOzudho kvIFxsiiO3dR9Mnhwor1n+sBQSQn6BCYjSBlTCkXdA8d7D4ZFTrCqtmV3uMGEbwFCLMidw+jyH XEU= X-IronPort-AV: E=McAfee;i="6000,8403,9479"; a="16968984" X-IronPort-AV: E=Sophos;i="5.69,345,1571670000"; d="scan'208";a="16968984" Received: from mail-ty1jpn01lp2058.outbound.protection.outlook.com (HELO JPN01-TY1-obe.outbound.protection.outlook.com) ([104.47.93.58]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 23 Dec 2019 08:38:47 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=MkaD3aTxvwqLvFe3XSQxmnIPihb/SGwC2tCluzN0BNQXJ2iETeRb1S+zjr+oB2BkBmynEaujS4iwFSk6Nl/MMQCKih66EN3uydGaxvEfeRM2sDgaQbwwHa9fDLOZ03imGDTKzWKRo/wIk0Q88+uoE7qtokHVxwmeA9md/pjODS9A7SyqlErms7ARIoHJFL945PQ2fmR8bUWb7HD+YKmMIsvYgCRVGwNQSkUg9vob9aOZmukFI4Rh7+tXKwWJ/Yanpnr1FJJYqvO/LpKuGBKCg/eDfh8m2Z0l6H2rG26qzJuUdTSpOnXmz8+olMXjZirQjAmd1hp43OpdskIkcmUtCQ== 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=WwFrEISgX8f0750GLiM9w4b653Y6i3w0rYROtdx9Fr4=; b=J7m3J0641VegRKLMBTR9DS47OCrgYlletGUIgUidU099/r9nh35RRFLKQlpd04XEMpk2JoFr08Fk5J0rkjgz+E9Drm5Go37f3WlDt7L8DhJ9++l9ybIscRrnTedPI6RzgYYYm+j4Mnw306PClOK1U0Z/ustR/iE8fBrtjK1iiSewHP7Vz7kiB9pi/31lUToHIk0jI43mvxz5y5vqu3idkgPJM1P9e/Zrtl50g5/by9UAUsPZqluugZw3nU59QbqQ0NbmWvXHpqxnNZfTkqeDuiimOlNlaZ49ujdOgYeZ8ZBqd27Tk+Pv/kM2a6ntkWgQpwgkEwL4FpZQnIWPXK/+xg== 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=WwFrEISgX8f0750GLiM9w4b653Y6i3w0rYROtdx9Fr4=; b=japo9xQ+3T4b/FLM4aIMduADklZY+SYJHRoC8ZAseUNiG9mFbpkaQn76cufPnQXU3q5F9/6I44W90VHXRcMkKseEXVTlpJbuJnebT2OZtgTqj4UCFDyFhdxHCBN3LC3pgHDzGPtem/5KlvigSjr9WTUEkIAfDczGEnXqIwsaVPU= Received: from OSAPR01MB5073.jpnprd01.prod.outlook.com (20.179.179.15) by OSAPR01MB4611.jpnprd01.prod.outlook.com (20.178.129.145) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.2559.14; Sun, 22 Dec 2019 23:38:44 +0000 Received: from OSAPR01MB5073.jpnprd01.prod.outlook.com ([fe80::c7:cff3:1b9b:bfc6]) by OSAPR01MB5073.jpnprd01.prod.outlook.com ([fe80::c7:cff3:1b9b:bfc6%3]) with mapi id 15.20.2559.017; Sun, 22 Dec 2019 23:38:44 +0000 From: "tsunakawa.takay@fujitsu.com" To: 'Tatsuo Ishii' CC: "nagata@sraoss.co.jp" , "michael@paquier.xyz" , "amitlangote09@gmail.com" , "hoshiai@sraoss.co.jp" , "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+KedDO2AgAADVYCAAtRJAIAAYCsAgADtLACAAF9RgIAAKwYAgAAtBQCAAAEXAIACuTAAgAFygACAABH5AIAce2QAgAAkDrCAABCYAIAEJwNw Date: Sun, 22 Dec 2019 23:38:43 +0000 Message-ID: References: <20191202110538.a6ff2cd84f488f42eab621eb@sraoss.co.jp> <20191220140232.57b43c4f6296f793d42946b2@sraoss.co.jp> <20191220.171058.2097118226859356640.t-ishii@sraoss.co.jp> In-Reply-To: <20191220.171058.2097118226859356640.t-ishii@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.190] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 14e3060c-515f-41eb-2397-08d78738153f x-ms-traffictypediagnostic: OSAPR01MB4611: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:8882; x-forefront-prvs: 02596AB7DA x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(4636009)(396003)(39860400002)(136003)(366004)(376002)(346002)(199004)(189003)(8676002)(81156014)(54906003)(85182001)(478600001)(55016002)(6916009)(966005)(33656002)(9686003)(4326008)(81166006)(8936002)(316002)(86362001)(4744005)(5660300002)(52536014)(2906002)(6506007)(71200400001)(186003)(7696005)(26005)(64756008)(66446008)(66556008)(66946007)(66476007)(3480700005)(76116006)(777600001);DIR:OUT;SFP:1101;SCL:1;SRVR:OSAPR01MB4611;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: r+7bOcBH6nlWP0P6CkIIg7qHM08z1QPmntI/ylLAEDhTlDXDuSYX1sltyBRKGPlyomLaHa1nxD/wPEy4X2nFVkpukxicjLRP2Ri5IBsNhjB5yG6JYRlZJYDpVVX5Kh7V/KV/KskeElU/J6CSqPrUy5k9G4UdgZWtacjQyhB7wjotlzWTEsIOqvyWkr4AnGcglEoKBFfenZwCT3ELxqInd8mhCACNA8PzYN1o46vGZBD+LDycMShGOX6UnzfrWtgisybJXARAQ8hlWf/TRhC2UYiy0dU5sqCFuC1RwUmjzznVj2VRPeYs3+1d9fny7ZT1tR9bAEP3v8wTyT0+QUl9OF4lZ/+GowcbROFCV9O5bYtXGOnz8zaKiV93ccgY2chMuPyX7mJaZo7MN9UsdoALQB60Bs72Lam57f3fTj/LG9i/050nEbKv9XlUSxI228GfB2ERtXHYqh1iEF740Jio+toDwWfXQI7EJAUhrc+/1z+wGMe9i7h46ZujVDCNpCCiwm2aHuP8KTEhAprv88ImHDH2y0eIx4T6aI69+T0yYMA= 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: 14e3060c-515f-41eb-2397-08d78738153f X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Dec 2019 23:38:43.9982 (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: rtXBLf4DdQ5754HKNA7+ZakNKKzfczvdlguKdlqt/5+PS63viu5UkZ+kxNG6s7l3i1UpZHZY8y74TrKxFQpi8oQxNMgKhn6WbQIGwdiYuWs= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB4611 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk From: Tatsuo Ishii > > The following IVM wiki page returns an error. Does anybody know what's > wrong? > > > > https://wiki.postgresql.org/wiki/Incremental_View_Maintenance >=20 > I don't have any problem with the page. Maybe temporary error? Yeah, I can see it now. I could see it on the weekend. The page was not a= vailable for at least an hour or so when I asked about this. I thought the= Pgsql-www team kindly solved the issue. Regards Takayuki Tsunakawa