Re: Query Rewrite for Materialized Views (Postgres Extension)

Поиск
Список
Период
Сортировка
От Dent John
Тема Re: Query Rewrite for Materialized Views (Postgres Extension)
Дата
Msg-id 2E510F8A-E156-403D-9696-0243D22C29A2@QQdd.eu
обсуждение исходный текст
Ответ на Re: Query Rewrite for Materialized Views (Postgres Extension)  (Corey Huinker <corey.huinker@gmail.com>)
Ответы Re: Query Rewrite for Materialized Views (Postgres Extension)  (Nico Williams <nico@cryptonector.com>)
Список pgsql-hackers
I commented to Corey (privately) that, while my rewrite extension has gotten me a server that responds quickly to
aggregatequeries, the constant need to refresh the supporting MVs means the system’s load average is constant and much
higherthan before. I’m happy with the tradeoff for now, but it’s a huge waste of energy, and I’m sure it must thrash my
disk.

I’m very interested in what other people think of Corey’s idea.

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: Speedup of relation deletes during recovery
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Transform for pl/perl