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
|
| Список | 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 по дате отправления: