Re: Avoid calling SetMatViewPopulatedState if possible
| От | cca5507 |
|---|---|
| Тема | Re: Avoid calling SetMatViewPopulatedState if possible |
| Дата | |
| Msg-id | tencent_740AA48C1EDECD01AF5D7C285821756D5A06@qq.com обсуждение |
| Ответ на | Re: Avoid calling SetMatViewPopulatedState if possible (David Geier <geidav.pg@gmail.com>) |
| Ответы |
Re: Avoid calling SetMatViewPopulatedState if possible
|
| Список | pgsql-hackers |
Hi, Thanks for your reply! > While being a simple patch, it would be good to know what actual use > cases this change improves on and by how much. Can you share a test case > and/or performance data? The improvement of performance is small, so it's hard to observe it. But I think the patch is still useful because we can avoid generating dead pg_class tuple: create table t(a int); create materialized view m as select a from t; create unique index on m(a); select ctid from pg_class where relname = 'm'; refresh materialized view concurrently m; select ctid from pg_class where relname = 'm'; Before the patch, the ctid will change every time we refresh the matview. -- Regards, ChangAo Chen
В списке pgsql-hackers по дате отправления: