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)
Список
Дерево обсуждения
Re: Implementing Incremental View Maintenance Paul Draper <paulddraper@gmail.com>
Re: Implementing Incremental View Maintenance Yugo Nagata <nagata@sraoss.co.jp>
Re: Implementing Incremental View Maintenance Paul Draper <paulddraper@gmail.com>
Re: Implementing Incremental View Maintenance Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Implementing Incremental View Maintenance Yugo Nagata <nagata@sraoss.co.jp>
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 по дате отправления
От: Fujii Masao
Дата:
