Feature: temporary materialized views

Поиск
Список
Период
Сортировка
От Mitar
Тема Feature: temporary materialized views
Дата
Msg-id CAKLmikNoQR4ZNg_wt=-hU-uUxV2cXVdveeRsMFjr2SAopVxDxw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Feature: temporary materialized views  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: pg_dumpall --exclude-database option
Следующее
От: rajan
Дата:
Сообщение: Is there any way that one of the Postgres Background/Utilityprocess may go down?