Re: Refresh Materialized View

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: Refresh Materialized View
Дата
Msg-id CAFS1N4iGnnDwnmNuRVd1rbKecxHVZyADmQr81eyscA+Byo9MDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Refresh Materialized View  (Jayadevan M <maymala.jayadevan@gmail.com>)
Ответы Re: Refresh Materialized View
Список pgsql-general
Дерево обсуждения
I think that does answer my questions.  Nothing has changed?
Regards,
Jayadevan


On Wed, Jan 1, 2014 at 6:42 PM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
Hello all,
A few questions about materialized views.
When I refresh a materialized view, is it a DELETE/INSERT behind the scenes?
Do we need to vacuum to reclaim space?
If a query is executed against the view when the refresh is happening, will the query see the data before the refresh started?
Does the refresh result in exclusive locking?
Regards,
Jayadevan

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