News for hackers. Stuff that matters.

A comment on PostgreSQL views and materialized views and how they influenced TimescaleDB. Parent comment

Re:PostgreSQL views and materialized views and how they infl... by edmundsauto on Thursday July 14, 2022 @02:03PM (#32099452)
I also wish this were in core posgres, but if you use a build tool like DBT you can enable this type of thing.
[ Parent | on HN ]
Re:PostgreSQL views and materialized views and how they infl... by snicker7 on Thursday July 14, 2022 @02:45PM (#32099957)
Interestingly, DBT does not support creating materialized views.
[ Parent | on HN ]
Re:PostgreSQL views and materialized views and how they infl... by mritchie712 on Thursday July 14, 2022 @02:56PM (#32100079)
yeah, this issue has been open for years. We need them for Clickhouse for our product.

https://github.com/dbt-labs/dbt-core/issues/1162

[ Parent | on HN ]
Re:PostgreSQL views and materialized views and how they infl... by edmundsauto on Friday July 15, 2022 @01:49AM (#32104994)
What's the effective difference between a matview and just a table?
[ Parent | on HN ]