Re: Implementing Incremental View Maintenance

Поиск
Список
Период
Сортировка
От Andy Fan
Тема Re: Implementing Incremental View Maintenance
Дата
Msg-id CAKU4AWpCbAcNFoh+7gaE44c_aMsC4vQ6rwNF8ce2m-jodnSVBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Implementing Incremental View Maintenance  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: Implementing Incremental View Maintenance  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список pgsql-hackers
Дерево обсуждения
On Fri, May 8, 2020 at 9:13 AM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
>> Hi,
>>
>> Attached is the latest patch (v15) to add support for Incremental Materialized
>> View Maintenance (IVM). It is possible to apply to current latest master branch.

I have tried to use IVM against TPC-DS (http://www.tpc.org/tpcds/)
queries.  TPC-DS models decision support systems and those queries are
modestly complex. So I thought applying IVM to those queries could
show how IVM covers real world queries.

+1,  This is a smart idea.   How did you test it?  AFAIK, we can test it with:

1.  For any query like SELECT xxx,  we create view like CREATE MATERIAL VIEW
mv_name as SELECT xxx;  to test if the features in the query are supported.
2.  Update the data and then compare the result with SELECT XXX with SELECT
* from  mv_name to test if the data is correctly sync. 

Best Regards
Andy Fan

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Fix pg_buffercache document
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Back-patch is necessary? Re: Don't try fetching future segment ofa TLI.