Mat Views and Conflicts

Поиск
Список
Период
Сортировка
От Zahir Lalani
Тема Mat Views and Conflicts
Дата
Msg-id AS8P251MB012075726CD81F97C586842CA7512@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: Mat Views and Conflicts
Re: Mat Views and Conflicts
Список pgsql-general

Hi All

 

My understanding and hope was that Mat Views cache their data and that is how they are so fast. But we are experience “cancelling statement due to conflict with recovery” errors on MV’s with large data sets and I thought that this could only happen if we ran the underlying query, not the Mat View?

 

 

Have I got it wrong??

 

Z

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Mat Views and Conflicts