Re: Feature: temporary materialized views

Поиск
Список
Период
Сортировка
От Andreas Karlsson
Тема Re: Feature: temporary materialized views
Дата
Msg-id 967dc5b6-a37b-efba-cfd2-120b59d32df6@proxel.se
обсуждение исходный текст
Ответ на Re: Feature: temporary materialized views  (Mitar <mmitar@gmail.com>)
Ответы Re: Feature: temporary materialized views  (Mitar <mmitar@gmail.com>)
Список pgsql-hackers
On 12/28/18 8:48 AM, Mitar wrote:> One more version of the patch with 
more deterministic tests.

Her is quick initial review. I will do more testing later.

It applies builds and passes the tests.

The feature seems useful and also improves consistency, if we have 
temporary tables and temporary views there should logically also be 
temporary materialized tables.

As for you leaving out ON COMMIT I feel that it is ok since of the 
existing options only really DROP makes any sense (you cannot truncate 
materialized views) and since temporary views do not have any ON COMMIT 
support.

= Comments on the code

The changes to the code are small and look mostly correct.

In create_ctas_internal() why do you copy the relation even when you do 
not modify it?

Is it really ok to just remove SECURITY_RESTRICTED_OPERATION from 
ExecCreateTableAs()? I feel it is there for a good reason and that we 
preferably want to reduce the duration of SECURITY_RESTRICTED_OPERATION 
to only include when we actually execute the query.

Andreas


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: add_partial_path() may remove dominated path but still in use
Следующее
От: Robert Haas
Дата:
Сообщение: Re: What to name the current heap after pluggable storage / what to rename?