Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXKum-0005CZ-FI for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jun 2018 06:23:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fXKuk-0002pi-KS for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jun 2018 06:23:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXKuk-0002pU-9n for pgsql-admin@lists.postgresql.org; Mon, 25 Jun 2018 06:23:50 +0000 Received: from mout.kundenserver.de ([212.227.126.135]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fXKug-00078V-Qv for pgsql-admin@lists.postgresql.org; Mon, 25 Jun 2018 06:23:49 +0000 Received: from [10.8.0.146] ([185.40.248.10]) by mrelayeu.kundenserver.de (mreue005 [212.227.15.129]) with ESMTPSA (Nemesis) id 0M53la-1gNWco1Qxq-00zC3u for ; Mon, 25 Jun 2018 08:23:44 +0200 Subject: Re: Reading on how materialized views are materialized? To: pgsql-admin@lists.postgresql.org Newsgroups: gmane.comp.db.postgresql.admin References: From: Thomas Kellerer Message-ID: <894dd06e-c708-bd3e-0a08-8b85e2dc27ff@gmx.net> Date: Mon, 25 Jun 2018 08:23:43 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:6+FAnnmb0xaO47SZCVPqrsXBrbZO+OwnD+PVmz3x+xngW7yH5kE kQCMNBCaWazcWDR0oVud0lI5fR6MIPkk6UtQD9VUXD2CjRfKtLHN2I2lKTWius9EtT24Apb KQV8zeU0WY2Z4PGNDBpNGoJa9xhv3d906O2eto4aHes6tmWGi+qXdDcGuZUO36Gp6ZIk/yG cc44OMHqyXGJHOsSuiBew== X-UI-Out-Filterresults: notjunk:1;V01:K0:rQW4mtvppqY=:WFgy6BoJEKFltkblVVXMcU kpGPksUKQdNIzUwHHPHAycIxWz3YhMdqHfkPnRkWCq1fdB6Z+XR7DIxvjnRpJbwggNn3rpnXH 4VOrA8Jb3ZmKkEVKVC8IVdMyMw14eODIoC5tOc2manAf4PQnWDpre+skUWVzoEpfXry9DRZ8a 7uGaycbWg634wzqXyllCRPwlrwBi3Qbhs0jHL5iDkC8d+NLBUBHnDWNZCTUOx2xVNSiNOKAAd yh/cFeVdJDW60fBho011/8Oy02s63oCuLCqtocB4XBa9xm33p6Aeo6H6M06JHLj+eiGLfhTyU 176zn4nUiFhJlGfFRtaQoS9yc/5RWssaWMrNWVYGk0OBB7saDEtEyDkijm4esSlIOETFaIChg LQU8ALkNAF9k9gFAgQkGk7B6QdAbjnATTeYGMfSB0CUIAALvBx0cBBrx5Payd3MI3WR5jvmjI yH56doBFeb2S/S0pC1/cQGHe9Oktcatzs1l3tIQl8irSUTDGsY1K4TeZyaBley+3ikQZHLlqc R0G1x4sDik+/ZuDtOqS1Kn3hYui8zdLfH3CU3k4qLIr7RJW6MNaOJGuZWWsOQerALf3XLoPBt YJHrvsAEskcbljkPUVp3bygDoFZC7T/ljLUW039IwSAV/U0TDxcpERrOP3ryiBGXMWAVdyY89 ZR5v2LMZcTmvZjZyqV1rjzOfcgcOtKm/9QTlnmzNccrN+eDNWgLTOJ/Z6ZqBttiEDiRyi/sGb Lby3VWtr/kjHT+jO List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Wells Oliver schrieb am 22.06.2018 um 20:51: > Where can I find some more detail? I am deciding between a flat table > populated for the current month only with a script versus a > materialized view, and I'd like to understand better if the latter is > intelligently being refreshed (meaning years of data won't be > re-populated, only what's changed). MViews currently don't support "incremental" refresh in Postgres. A refresh of a mview is essentially the same as: truncate table foo; insert into foo select ... from ....; Where the SELECT part is the query used to define the mview.