Horton

Feature: temporary materialized views

Mitar <mmitar@gmail.com>

View thread View on postgr.es
From: Mitar <mmitar@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2018-12-25T09:51:32Z
Lists: pgsql-hackers

Attachments

Hi!

Sometimes materialized views are used to cache a complex query on
which a client works. But after client disconnects, the materialized
view could be deleted. Regular VIEWs and TABLEs both have support for
temporary versions which get automatically dropped at the end of the
session. It seems it is easy to add the same thing for materialized
views as well. See attached PoC patch.


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m

Commits

  1. Add more tests for CREATE TABLE AS with WITH NO DATA