search

sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
862 stars 24 forks source link

do you plan to include back the CTE/subquery/aggregation work? #4

Closed docteurklein closed 1 year ago

docteurklein commented 2 years ago

First, thank you for your work, it's really interesting!

I lurked in the commits from the pg fork and wanted to apply the patches here, but I wonder how hard it would be? Is the upstream patch to inline_cte necessary?

Thanks!

yugo-n commented 2 years ago

First, thank you for your work, it's really interesting! Thanks!

I lurked in the commits from the pg fork and wanted to apply the patches here, but I wonder how hard it would be?

We decided to start from the simple feature at the initial version, but we plan to support CTE and subqueries. After confirming that they works well, we are going to introduce left features of the pgsql-ivm repository into the extension.

Is the upstream patch to inline_cte necessary?

I plan to use the code of the original PostgreSQL by duplicate.

yugo-n commented 1 year ago

As of pg_ivm 1.2, aggregates and simple sub-queries in FROM clause are supported.

CTE, EXISTS, and outer-join are left for feature releases.