Re: materialised views vs unlogged table (also, ize vs ise)

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: materialised views vs unlogged table (also, ize vs ise)
Дата
Msg-id CAB7nPqSLJtTLdhijobvwCMf7K4G-EKuiUPyx5t+3aPQdYFg=iw@mail.gmail.com
обсуждение исходный текст
Ответ на materialised views vs unlogged table (also, ize vs ise)  (Tim Kane <tim.kane@gmail.com>)
Ответы Re: materialised views vs unlogged table (also, ize vs ise)
Список pgsql-general
Дерево обсуждения 
On Mon, May 19, 2014 at 6:47 AM, Tim Kane <tim.kane@gmail.com> wrote:
> Aside from the convenience of the REFRESH functionality, are there any other
> factors I should consider?
An exclusive lock is taken on the materialized view during a REFRESH
operation, blocking an read or write queries attempted on them. You
can tackle this limitation in the upcoming 9.4 by using REFRESH
CONCURRENTLY, a unique index being necessary on the materialized view.
--
Michael

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

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: 9.4 beta - pg_get_viewdef() and WITH CHECK OPTION
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to solve the problem "error reading c:\Program Files\PostgreSQL\9.3\data\postgresql.conf during installation"