Feature: temporary materialized views - Mailing list pgsql-hackers

From Mitar
Subject Feature: temporary materialized views
Date
Msg-id CAKLmikNoQR4ZNg_wt=-hU-uUxV2cXVdveeRsMFjr2SAopVxDxw@mail.gmail.com
Whole thread Raw
Responses Re: Feature: temporary materialized views  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pg_dumpall --exclude-database option
Next
From: rajan
Date:
Subject: Is there any way that one of the Postgres Background/Utilityprocess may go down?