TimescaleDB - Timeseries database for PostgreSQL TimescaleDB - Timeseries database for PostgreSQL
open mobile menu
  • Why Timescale
  • Customers
  • Developers
    Developers Docs Tutorials Guides Community Support Try for free
  • Resources
    Resources Blog About Careers Try for free
  • Pricing
  • Try for free
  • Why Timescale
  • Customers
  • Developers
    Docs Tutorials Guides Community Support
  • Resources
    Blog About Careers
  • Pricing
Login Try for free
CATEGORIES
  • All posts
  • Announcements
  • Cloud
  • Developer Q&A
  • Engineering
  • General
  • Grafana
  • Observability
  • PostgreSQL
  • Product Updates

Materialized Views

PostgreSQL, Blog

A Guide to PostgreSQL Views

1 Mar 2023 3 min read

Understanding PostgreSQL views and materialized views is essential to fully grasp one of the most popular features in Timescale that will save you time and disk space: continuous aggregates.

Read more
A Guide to PostgreSQL Views
An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better
Product Updates

An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better

18 Jan 2023 5 min read

A continuous aggregate is similar to a PostgreSQL materialized view, speeding up queries. But rolling up (or downsampling) previously rolled up data can increase calculation speed while decreasing storage needs. Say hi to continuous aggregates on continuous aggregates, courtesy of TimescaleDB 2.9.

Share this post
  • Products
  • Why Timescale
  • Cloud Status
  • Support
  • Security
  • Cloud Terms of Service
  • Learn
  • Documentation
  • Blog
  • Forum
  • Tutorials
  • Release notes
  • Case studies
  • Time series database
  • Company
  • Contact us
  • Careers
  • About
  • Newsroom
  • Community
  • Timescale shop
  • Code of conduct
Subscribe to the Timescale Newsletter
By submitting you acknowledge Timescale's  Privacy Policy.
2023 © Timescale, Inc. All Rights Reserved.
Privacy preferences Legal Privacy Sitemap