![Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices](/blog/content/images/size/w600/2024/04/Self-hosted-vs-cloud-database_cover--1-.webp)
![Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices](/blog/content/images/size/w600/2024/04/Self-hosted-vs-cloud-database_cover--1-.webp)
![Introducing New Cloud Regions and How We Choose Them](/blog/content/images/size/w300/2024/03/Introducing-New-Regions-and-How-We-Choose-Them.png)
![Do More on AWS With Timescale: Build an Application Using Lambda Functions in Python](/blog/content/images/size/w300/2023/08/pexels-pixabay-55832.jpg)
![The PostgreSQL Job Scheduler You Always Wanted (Use it With Caution)](/blog/content/images/size/w300/2023/10/Screenshot-2023-10-12-at-6.22.47-PM.png)
![An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better](/blog/content/images/size/w300/2023/01/TimescaleDB-2.9-blog-hero--1---1--1.png)
An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better
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.
![What's New in TimescaleDB 2.9?](/blog/content/images/size/w300/2023/01/TimescaleDB-2.9-blog-hero--1---1-.png)
![How to Design a Better Developer Experience for Time-Series Data: Our Journey With Timescale's UI](/blog/content/images/size/w300/2023/06/Timescale-new-UI-2.0.png)
![Expanding the Boundaries of PostgreSQL: Announcing a Bottomless, Consumption-Based Object Storage Layer Built on Amazon S3](/blog/content/images/size/w300/2022/11/timescale-supercharged-elephant.png)
![Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data](/blog/content/images/size/w300/2023/06/2023-06-23-Amazon-RDS-timescale-hero.png)
Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data
Why are developers migrating from Amazon RDS for PostgreSQL to Timescale to handle their time-series data workloads? Our benchmark answers the question: faster queries, faster ingest, and 95 % storage savings for time-series data.
![Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version](/blog/content/images/size/w300/2022/11/Best-Practices-PostgreSQL-version_Hero--1-.png)
Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version
PostgreSQL upgrades have been known to be a bit of a controversial issue in the community. In this article, we will take the mystery out of the question of when an upgrade is appropriate and how Timescale allows you to do it as swiftly as possible.
![10 Database Management Tips and Tricks From a Data Architect](/blog/content/images/size/w300/2022/11/database-management-possible-header-1.jpg)
![How to Spin Up an Instance in 30 Seconds and Add Time-Series Data to Your Database](/blog/content/images/size/w300/2022/11/Add-time-series-data-to-your-database_header.jpg)
![Database Indexes in PostgreSQL and Timescale: Your Questions, Answered](/blog/content/images/size/w300/2022/10/database-indexes-postgres-header.jpg)
Database Indexes in PostgreSQL and Timescale: Your Questions, Answered
Few features raise more questions than database indexes in the PostgreSQL landscape. Since Timescale Cloud is built on PostgreSQL, we often get questions on the topic. Read this blog post to see all your FAQs about indexing answered.
![VPC Peering: From Zero to Hero](/blog/content/images/size/w300/2022/10/2022-10-13-VPC-hero.png)
![How to Test Performance Improvements on Up-To-Date Production Data in Timescale](/blog/content/images/size/w300/2022/10/How-to-test-performance-improvements-in-timescale-cloud.jpg)
![Nightmares of Time Zone Downsampling: Why I’m Excited About the New time_bucket Capabilities in TimescaleDB](/blog/content/images/size/w300/2022/09/Why-Im-Excited-about-time_bucket-features-timescaledb-2.8--1-.png)
![What’s New in TimescaleDB 2.8?](/blog/content/images/size/w300/2022/09/what-is-new-in-timescaledb-2.8--1-.png)
![Timescale Parameters You Should Know About (and Tune) to Maximize Your Performance](/blog/content/images/size/w300/2022/09/Hero_2.png)
![How We’re Raising the Bar on Hosted Database Support](/blog/content/images/size/w300/2022/09/20220908_Hero_1-3.png)
![Timescale Tips: Migrate Your PostgreSQL Production Database Without Downtime](/blog/content/images/size/w300/2022/09/TimescaleCloud_Tips_Blog_Hero--1-.png)
Timescale Tips: Migrate Your PostgreSQL Production Database Without Downtime
Database migration is one of the most painful steps for anyone managing a database. If you want to try a different approach to minimize downtime while migrating your PostgreSQL database, follow our step-by-step guide on the “ingest and backfill” method.
![Monitoring Your Timescale Services With Amazon CloudWatch](/blog/content/images/size/w300/2022/08/TimescaleCloud_CloudWatch_Hero--1-.png)
![Monitoring Your Timescale Services With Datadog](/blog/content/images/size/w300/2022/08/TimescaleCloud_Datadog_Hero--1-.png)
![Timescale Tips: Testing Your Chunk Size](/blog/content/images/size/w300/2022/08/TimescaleCloud_Tips_Blog_Hero--1--2.png)
![Timescale Tips: How to Optimize Your Ingest Rate](/blog/content/images/size/w300/2022/08/TimescaleCloud_Tips_Blog_Hero--1-.png)