Re: Delta Materialized View Refreshes?

Поиск
Список
Период
Сортировка
От Jeremy Finzel
Тема Re: Delta Materialized View Refreshes?
Дата
Msg-id CAMa1XUjzet2_9EsCJ=W1WHQg6RVuWKUQm44NuADAkqCS1PWsxA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Delta Materialized View Refreshes?  (Jordan Deitch <jd@rsa.pub>)
Ответы Re: Delta Materialized View Refreshes?  (Isaac Morland <isaac.morland@gmail.com>)
Список pgsql-hackers

Could you apply something similar using triggers?
One question would be how PG would identify changes to existing rows - using the replication facilities to essentially replicate into the view? This would be quite tricky I reckon. Otherwise a change to the underlying table may not propagate correctly to the MV.

That's not what I had in mind.  I only mean when REFRESH MATERIALIZED VIEW is run, it gathers the results of the view in memory, then instead of essentially "wiping and reloading" the table, it would only write the differences.  So if 90% of the rows would be the same as before the refresh, we only update 10% of the rows.

This would also mean materialized views could get bloated just like tables.

Thanks,
Jeremy

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_dump test instability
Следующее
От: Tom Lane
Дата:
Сообщение: Re: stat() on Windows might cause error if target file is larger than 4GB