Zhang Mingli

> Dynamic Table have all operations from Materialized Views, and it must do. They are same as GPDB's external table and foreign table, if you have a try: > >...

Will provide DOC soon.

> Will provide DOC soon. Done, see doc/src/sgml/ref/create_dynamic_table.sgml, doc/src/sgml/ref/drop_dynamic_table.sgml, doc/src/sgml/ref/refresh_dynamic_table.sgml

> With `catalog_change` in play, I am assuming we are going to bump the version string to 2.0.0? Woo..that will make CBDB version grow up quickly, as we have lot's...

While develop #685, SRF also need to be considered here: https://github.com/apache/cloudberry/pull/685#issuecomment-2453949643 Will fix it later.

Update: Disable query has SRF to AQUMV and Remove raw_processed_tlist elimination. The origin SQL has removed useless ORDER BY clause, only process view query is enough.

> When mirror is promoted, should we launch auto task for Dynamic Table? Synced with my colleague who is familiar with pg_task extension, and confirmed that pg_task could work on...

> Patch miss tab-completion for DYNAMIC feature. According to various feedback, I will enable this. Perhaps within pg_dump patch of Dynamic Table.

> > Patch miss tab-completion for DYNAMIC feature. > > According to various feedback, I will enable this. Perhaps within pg_dump patch of Dynamic Table. Tab-complete added in 80bfc73fbec9e680dd68afa27aee4f953fbc7b87. pg_dump...

Add commit: https://github.com/apache/cloudberry/pull/725/commits/7a13989d24192bb471ff668a1754ae489e538ef5 to give an example of Dynamic Table use case: how to query on external tables as fast as internal tables?