Re: Why no CREATE TEMP MATERIALIZED VIEW ?
| От | Ron |
|---|---|
| Тема | Re: Why no CREATE TEMP MATERIALIZED VIEW ? |
| Дата | |
| Msg-id | 61406744-6096-47b3-1fcd-329b5cfd26b7@gmail.com обсуждение исходный текст |
| Ответ на | Re: Why no CREATE TEMP MATERIALIZED VIEW ? ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Why no CREATE TEMP MATERIALIZED VIEW ?
|
| Список | pgsql-general |
On 7/16/19 11:56 AM, David G. Johnston wrote:
How different is a "temp materialized view" from a regular view?
On Tue, Jul 16, 2019 at 9:29 AM Ivan Voras <ivoras@gmail.com> wrote:Out of curiosity, since there's CREATE TEMP VIEW, any particular reason there's no CREATE TEMP MATERIALIZED VIEW?Seems like it could be similar to a temp table.Probably a lack (absence) of use cases resulted in people deciding (or defaulting) to not spend any effort in that area. Incremental maintenance and refresh seem considerably less useful when only the current session can see the table. Temp views and temp tables seem to provide sufficient options in the session lifetime space.
How different is a "temp materialized view" from a regular view?
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: