Re: GSoC - Materialized Views - is stale or fresh?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: GSoC - Materialized Views - is stale or fresh?
Дата
Msg-id 4C1601D30200002500032296@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: GSoC - Materialized Views - is stale or fresh?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: GSoC - Materialized Views - is stale or fresh?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> What Pavel's trying to do here is be smart about figuring out when
> an MV needs to be refreshed.  I'm pretty sure this is the wrong
> way to go about it, but it seems entirely premature considering
> that we don't have a working implementation of a *manually*
> refreshed MV.
Agreed all around.
At the risk of sounding obsessed, this is an area where predicate
locks might be usefully extended, if and when the serializable patch
makes it in.
-Kevin


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: warning message in standby
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Re: [PERFORM] Large (almost 50%!) performance drop after upgrading to 8.4.4?