Re: Feature: temporary materialized views

Поиск
Список
Период
Сортировка
От Mitar
Тема Re: Feature: temporary materialized views
Дата
Msg-id CAKLmikOPxJpQO4Pf2o7xBG08-soNFzXPcvSe1XEo0aq0PVeQMQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feature: temporary materialized views  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Feature: temporary materialized views  (Mitar <mmitar@gmail.com>)
Список pgsql-hackers
Hi!

Thanks, I did it.

I am attaching a new version of the patch with few more lines added to tests.

I noticed that there is no good summary of the latest patch, so let me
make it here:

So the latest version of the patch adds an option for "temporary"
materialized views. Such materialized views are automatically deleted
at the end of the session. Moreover, it also modifies the materialized
view creation logic so that now if any of the source relations are
temporary, the final materialized view is temporary as well. This now
makes materialized views more aligned with regular views.

Tests test that this really works, that refreshing of such views work,
and that refreshing can also work from a trigger.


Mitar

On Thu, Dec 27, 2018 at 5:15 AM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
>
> On 2018-Dec-27, Mitar wrote:
>
> > Hi!
> >
> > I made a new version of the patch. I added tests and changes to the
> > docs and made sure various other aspects of this change for as well. I
> > think this now makes temporary materialized views fully implemented
> > and that in my view patch is complete. If there is anything else to
> > add, please let me know, I do not yet have much experience
> > contributing here. What are next steps? Do I just wait for it to be
> > included into Commitfest? Do I add it there myself?
>
> Yes, please add it yourself to the commitfest.
>
> --
> Álvaro Herrera                https://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Alternative to \copy in psql modelled after \g
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: reducing the footprint of ScanKeyword (was Re: Large writablevariables)