Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: Materialized Hyperviews #1180

narc-Ontakac2 opened this issue Apr 20, 2019 · 3 comments


None yet
3 participants
Copy link

commented Apr 20, 2019

We are running Timescaledb and can do queries on a weeks data with the given hardware. To to long term reports we would like to have materialized views on the hypertable, that are themselves hypertables. These would best be by refreshable by chunk or autorefresh when the chunk is finished..


This comment has been minimized.

Copy link

commented Apr 22, 2019

Hi @narc-Ontakac2 : Thanks for the interest. We'll be releasing support for in-database continuous aggregations in v1.3 -- exposed as materialized hypertables -- which should be released within the next few weeks. Code should hit master branch within a few days.

@mfreed mfreed added the enhancement label Apr 22, 2019


This comment has been minimized.

Copy link

commented Apr 30, 2019

Hi, i'm new to Timescaledb and i was wondering if i create a materialized view of an hypertable, i would lose the benefits of using hypertables quering the view instead the hypertable, then i found this issue in google. So right now, there's no point in doing it as i understand until 1.3

@mfreed mfreed closed this May 22, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.