Copy logo as SVG

Copy brandmark as SVG

Open brand kit

  • Products

    Products & Services

    Timescale Cloud

    A reliable PostgreSQL cloud for your workloads

    Timescale Cloud

    Support Services

    Support options for your use case, infrastructure, and budget

    Cloud supportSelf-managed support

    Workloads

    Time Series

    Lightning-fast ingest and querying on PostgreSQL

    Time Series

    Real-Time Analytics

    The fastest real-time analytics on PostgreSQL

    Real-Time Analytics

    AI and Vector

    Build RAG, search, and Al agents, all on PostgreSQL

    AI and Vector

    Open-Source Extensions and Tools

    Time Series and Real-Time Analytics

    A reliable PostgreSQL cloud for your workloads

    timescaledbtimescaledb-toolkit

    AI and Vector

    pgaipgvectorscale

    Security Scanner

    pgspot
    Explore our Enterprise Tier

    Security, reliability, and support for demanding businesses.

  • Solutions

    Industries That Rely On Us

    CryptoIndustrial IoTEnergyTransportation and logisticsManufacturing

    Featured Articles

    Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables

    Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables

    Read more

    Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables
    Boosting Postgres INSERT Performance by 2x With UNNEST

    Boosting Postgres INSERT Performance by 2x With UNNEST

    Read more

    Boosting Postgres INSERT Performance by 2x With UNNEST
  • Customers
  • Developers

    Documentation

    Timescale Docs

    Learn how to make PostgreSQL faster with our documentation

    Timescale Docs

    AI and Vector

    Learn how to use PostgreSQL for Al with our documentation

    AI and Vector

    Learn PostgreSQL

    Learn PostgreSQL

    Learn the PostgreSQL basics and scale your database performance

    OverviewTime series basicsPostgres basicsPostgres guidesBenchmarksPostgres cheat sheet

    Timescale Benchmarks

    Timescale benchmarks

    See how Timescale performs against the competition

    vs RDS PostgreSQLvs Amazon Timestreamvs Influxvs MongoDBvs ClickHousevs Auroravs Cassandravs vanilla PostgreSQL

    More

    Blog

    Tutorials

    Support

    Community

    Changelog

    GitHub

    Slack

    Forum

    Launch Hub

    Partners

  • Pricing
Contact usLog InTry for free
Home
What Is a Time Series and How Is It Used?Is Your Data Time Series? Data Types Supported by PostgreSQL and TimescaleWhy Consider Using PostgreSQL for Time-Series Data?Time-Series Analysis in RUnderstanding Database Workloads: Variable, Bursty, and Uniform PatternsHow to Work With Time Series in Python?Tools for Working With Time-Series Analysis in PythonGuide to Time-Series Analysis in PythonTime-Series Analysis and Forecasting With Python The Best Time-Series Databases ComparedUnderstanding Autoregressive Time-Series ModelingAlternatives to TimescaleAWS Time-Series Database: Understanding Your OptionsStationary Time-Series AnalysisCreating a Fast Time-Series Graph With Postgres Materialized ViewsWhat Are Open-Source Time-Series Databases—Understanding Your OptionsWhat Is Temporal Data?
Optimizing Your Database: A Deep Dive into PostgreSQL Data TypesHow to Install PostgreSQL on LinuxHow to Install PostgreSQL on MacOSUnderstanding percentile_cont() and percentile_disc() in PostgreSQLUsing PostgreSQL UPDATE With JOINUnderstanding PostgreSQL Conditional FunctionsUnderstanding PostgreSQL Array FunctionsUnderstanding PostgreSQLUnderstanding FROM in PostgreSQL (With Examples)How to Address ‘Error: Could Not Resize Shared Memory Segment’ 5 Common Connection Errors in PostgreSQL and How to Solve ThemPostgreSQL Mathematical Functions: Enhancing Coding EfficiencyUnderstanding PostgreSQL Date and Time FunctionsPostgreSQL Join Type TheoryData Partitioning: What It Is and Why It MattersWhat Is Data Compression and How Does It Work?What Characters Are Allowed in PostgreSQL Strings?Understanding PostgreSQL's COALESCE FunctionUnderstanding HAVING in PostgreSQL (With Examples)How to Fix No Partition of Relation Found for Row in Postgres DatabasesUnderstanding GROUP BY in PostgreSQL (With Examples)How to Fix Transaction ID Wraparound ExhaustionUnderstanding LIMIT in PostgreSQL (With Examples)Understanding ORDER BY in PostgreSQL (With Examples)Understanding WINDOW in PostgreSQL (With Examples)Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure ChoicesWhat Is Data Transformation, and Why Is It Important?Understanding PostgreSQL User-Defined FunctionsStructured vs. Semi-Structured vs. Unstructured Data in PostgreSQLUnderstanding SQL Aggregate FunctionsUnderstanding Foreign Keys in PostgreSQLUnderstanding FILTER in PostgreSQL (With Examples)Understanding PostgreSQL FunctionsUnderstanding PostgreSQL WITHIN GROUPUnderstanding DISTINCT in PostgreSQL (With Examples)Using PostgreSQL String Functions for Improved Data AnalysisData Processing With PostgreSQL Window FunctionsUnderstanding WHERE in PostgreSQL (With Examples)PostgreSQL Joins : A SummaryUnderstanding OFFSET in PostgreSQL (With Examples)Understanding the Postgres string_agg FunctionWhat Is a PostgreSQL Full Outer Join?What Is a PostgreSQL Cross Join?What Is a PostgreSQL Inner Join?What Is a PostgreSQL Left Join? And a Right Join?Understanding PostgreSQL SELECTA Guide to PostgreSQL ViewsUnderstanding ACID Compliance Strategies for Improving Postgres JOIN PerformanceUnderstanding the Postgres extract() FunctionUnderstanding the rank() and dense_rank() Functions in PostgreSQL
How to Index JSONB Columns in PostgreSQLHow to Monitor and Optimize PostgreSQL Index PerformancePostgreSQL Performance Tuning: Optimizing Database IndexesOptimizing Array Queries With GIN Indexes in PostgreSQLSQL/JSON Data Model and JSON in SQL: A PostgreSQL PerspectiveHow to Query JSON Metadata in PostgreSQLHow to Query JSONB in PostgreSQLA Guide to pg_restore (and pg_restore Example)Handling Large Objects in PostgresPostgreSQL Performance Tuning: Designing and Implementing Your Database SchemaPostgreSQL Performance Tuning: Key ParametersHow to Reduce Bloat in Large PostgreSQL TablesDetermining the Optimal Postgres Partition SizeGuide to PostgreSQL Database OperationsPostgreSQL Performance Tuning: How to Size Your DatabaseGuide to PostgreSQL PerformanceDesigning Your Database Schema: Wide vs. Narrow Postgres TablesWhat Is a PostgreSQL Temporary View?A PostgreSQL Database Replication GuideUnderstanding PostgreSQL TablespacesGuide to Postgres Data ManagementHow PostgreSQL Data Aggregation WorksBuilding a Scalable DatabaseA Guide to Scaling PostgreSQLPg_partman vs. Hypertables for Postgres PartitioningHow to Use PostgreSQL for Data TransformationWhen to Consider Postgres PartitioningRecursive Query in SQL: What It Is, and How to Write OneGuide to PostgreSQL Database DesignTop PostgreSQL Drivers for PythonNavigating Growing PostgreSQL Tables With Partitioning (and More)An Intro to Data Modeling on PostgreSQLExplaining PostgreSQL EXPLAINBest Practices for (Time-)Series Metadata Tables A Guide to Data Analysis on PostgreSQLWhat Is Audit Logging and How to Enable It in PostgreSQLGuide to PostgreSQL SecurityBest Practices for Time-Series Data Modeling: Single or Multiple Partitioned Table(s) a.k.a. Hypertables How to Compute Standard Deviation With PostgreSQLHow to Use Psycopg2: The PostgreSQL Adapter for Python
Best Practices for Scaling PostgreSQLBest Practices for PostgreSQL Database OperationsHow to Store Video in PostgreSQL Using BYTEAHow to Handle High-Cardinality Data in PostgreSQLHow to Use PostgreSQL for Data NormalizationTesting Postgres Ingest: INSERT vs. Batch INSERT vs. COPYBest Practices for Postgres SecurityBest Practices for Postgres Data ManagementBest Practices for Postgres PerformanceHow to Design Your PostgreSQL Database: Two Schema ExamplesHow to Manage Your Data With Data Retention PoliciesBest Practices for PostgreSQL Data AnalysisBest Practices for PostgreSQL AggregationBest Practices for Postgres Database ReplicationHow to Use a Common Table Expression (CTE) in SQL
PostgreSQL Extensions: Using PostGIS and Timescale for Advanced Geospatial InsightsPostgreSQL Extensions: Turning PostgreSQL Into a Vector Database With pgvectorPostgreSQL Extensions: amcheckPostgreSQL Extensions: Unlocking Multidimensional Points With Cube PostgreSQL Extensions: hstorePostgreSQL Extensions: ltreePostgreSQL Extensions: Secure Your Time-Series Data With pgcryptoPostgreSQL Extensions: pg_prewarmPostgreSQL Extensions: pgRoutingPostgreSQL Extensions: pg_stat_statementsPostgreSQL Extensions: Database Testing With pgTAPPostgreSQL Extensions: Install pg_trgm for Data MatchingPostgreSQL Extensions: PL/pgSQLPostgreSQL Extensions: Intro to uuid-ossp
PostgreSQL as a Real-Time Analytics DatabaseHow to Build an IoT Pipeline for Real-Time Analytics in PostgreSQLHow to Choose a Real-Time Analytics DatabaseUnderstanding OLTPOLAP Workloads on PostgreSQL: A GuideHow to Choose an OLAP DatabaseData Analytics vs. Real-Time Analytics: How to Pick Your Database (and Why It Should Be PostgreSQL)What Is the Best Database for Real-Time AnalyticsColumnar Databases vs. Row-Oriented Databases: Which to Choose?
Text-to-SQL: A Developer’s Zero-to-Hero GuideA Brief History of AI: How Did We Get Here, and What's Next?A Beginner’s Guide to Vector EmbeddingsPostgreSQL as a Vector Database: A Pgvector TutorialUsing Pgvector With PythonHow to Choose a Vector DatabaseVector Databases Are the Wrong AbstractionUnderstanding DiskANNStreaming DiskANN: How We Made PostgreSQL as Fast as Pinecone for Vector DataA Guide to Cosine SimilarityImplementing Cosine Similarity in PythonVector Database Basics: HNSWVector Database Options for AWSVector Store vs. Vector Database: Understanding the ConnectionPgvector vs. Pinecone: Vector Database Performance and Cost ComparisonHow to Build LLM Applications With Pgvector Vector Store in LangChainHow to Implement RAG With Amazon Bedrock and LangChainRetrieval-Augmented Generation With Claude Sonnet 3.5 and PgvectorRAG Is More Than Just Vector SearchPostgreSQL Hybrid Search Using Pgvector and CohereWhat Is Vector Search? Vector Search vs Semantic SearchNearest Neighbor Indexes: What Are IVFFlat Indexes in Pgvector and How Do They WorkImplementing Filtered Semantic Search Using Pgvector and JavaScriptRefining Vector Search Queries With Time Filters in Pgvector: A TutorialUnderstanding Semantic SearchBuilding an AI Image Gallery With OpenAI CLIP, Claude Sonnet 3.5, and PgvectorWhen Should You Use Full-Text Search vs. Vector Search?HNSW vs. DiskANN
Why You Should Use PostgreSQL for Industrial IoT DataHow Hopthru Powers Real-Time Transit Analytics From a 1 TB Table Migrating a Low-Code IoT Platform Storing 20M Records/DayHow Ndustrial Is Providing Fast Real-Time Queries and Safely Storing Client Data With 97 % CompressionHow United Manufacturing Hub Is Introducing Open Source to ManufacturingFrom Ingest to Insights in Milliseconds: Everactive's Tech Transformation With TimescaleUnderstanding IoT (Internet of Things)Moving Past Legacy Systems: Data Historian vs. Time-Series DatabaseBuilding IoT Pipelines for Faster Analytics With IoT CoreVisualizing IoT Data at Scale With Hopara and TimescaleDBHow to Simulate a Basic IoT Sensor Dataset on PostgreSQLA Beginner’s Guide to IIoT and Industry 4.0Storing IoT Data: 8 Reasons Why You Should Use PostgreSQLHow to Choose an IoT Database
What Is ClickHouse and How Does It Compare to PostgreSQL and TimescaleDB for Time Series?Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series DataWhat We Learned From Benchmarking Amazon Aurora PostgreSQL ServerlessTimescaleDB vs. Amazon Timestream: 6,000x Higher Inserts, 5-175x Faster Queries, 150-220x CheaperHow to Store Time-Series Data in MongoDB and Why That’s a Bad IdeaPostgreSQL + TimescaleDB: 1,000x Faster Queries, 90 % Data Compression, and Much MoreEye or the Tiger: Benchmarking Cassandra vs. TimescaleDB for Time-Series Data
Alternatives to RDSWhy Is RDS so Expensive? Understanding RDS Pricing and CostsEstimating RDS CostsHow to Migrate From AWS RDS for PostgreSQL to TimescaleAmazon Aurora vs. RDS: Understanding the Difference
5 InfluxDB Alternatives for Your Time-Series Data8 Reasons to Choose Timescale as Your InfluxDB Alternative What InfluxDB Got Wrong InfluxQL, Flux, and SQL: Which Query Language Is Best? (With Cheatsheet)TimescaleDB vs. InfluxDB: Purpose Built Differently for Time-Series Data
More Time-Series Data Analysis, Fewer Lines of Code: Meet HyperfunctionsTimescale Tips: Testing Your Chunk SizeHow to Migrate Your Data to Timescale (3 Ways)Postgres TOAST vs. Timescale CompressionBuilding Python Apps With PostgreSQL: A Developer's GuideData Visualization in PostgreSQL With Apache SupersetIs Postgres Partitioning Really That Hard? An Introduction To HypertablesPostgreSQL Materialized Views and Where to Find Them5 Ways to Monitor Your PostgreSQL Database
Postgres cheat sheet
HomeTime series basicsPostgres basicsPostgres guidesPostgres best practicesPostgres extensionsPostgres for real-time analytics
Sections
Time series data
What Is Temporal Data?What Is a Time Series and How Is It Used?Is Your Data Time Series? Data Types Supported by PostgreSQL and TimescaleUnderstanding Database Workloads: Variable, Bursty, and Uniform PatternsWhy Consider Using PostgreSQL for Time-Series Data?
Time series analysis
Python
How to Work With Time Series in Python?Tools for Working With Time-Series Analysis in PythonGuide to Time-Series Analysis in PythonTime-Series Analysis and Forecasting With Python
R
Time-Series Analysis in R
Understanding Autoregressive Time-Series ModelingStationary Time-Series AnalysisCreating a Fast Time-Series Graph With Postgres Materialized Views
Time series databases
The Best Time-Series Databases ComparedAlternatives to TimescaleAWS Time-Series Database: Understanding Your OptionsWhat Are Open-Source Time-Series Databases—Understanding Your Options

Products

Time Series and Analytics AI and Vector Enterprise Plan Cloud Status Support Security Cloud Terms of Service

Learn

Documentation Blog Forum Tutorials Changelog Success Stories Time Series Database

Company

Contact Us Careers About Brand Community Timescale Shop Code Of Conduct

Subscribe to the Timescale Newsletter

By submitting, you acknowledge Timescale’s Privacy Policy

2025 © Timescale Inc. All rights reserved.

Privacy preferences

LegalPrivacySitemap

AWS Time-Series Database: Understanding Your Options

Try for free

Start supercharging your PostgreSQL today.

The AWS acronym inside a watch (representing time series) in neon colors.

Written by Carlo Mencarelli

Over the years, Amazon Web Services (AWS) has become a leading provider of cloud database hosting services. They offer everything from general relational databases to specialized ones like ledger and graph databases.

One type of specialized database that has been gaining significant popularity over the years is the time-series database (TSDB). DB-Engines, an initiative by Solid-IT to collect and present information about database systems, ranks time-series databases as the second highest change in popularity for the last several years.

image

With the growing importance of time-series data and options available, there are plenty of options available for users of AWS. However, choosing the right solution for your specific needs can be challenging. I hope to clear up some of the confusion and make the choice easier by the end of this article by:

  • Providing a clear understanding of time-series databases

  • Exploring the various time-series database options available on AWS

  • Comparing these possibilities to help you decide what's right for your organization

What Is a Time-Series Database

As mentioned, time-series databases are specialized database systems built to handle time-stamped or time-series data efficiently. Some examples of this data would be server metrics, sensor data, stock market information, or weather data. For more information about time-series data, we have a whole blog you can read: Time-Series Data: What It Is, and How to Use It.

As you may have learned from our blog above, time-series data is time-centric and normally append-only. A TSDB leverages these facts to optimize storage and compute operations and can efficiently handle a large number of transactions in a very short time.

Queries on time-series databases typically involve date ranges, which means the query process needs to be optimized to handle these types of requests. TSDB systems include these optimizations as part of the engine. Some systems can even downsample or archive the data as it becomes older.

If you want to know more about TSDB systems, our recent blog, Time-Series Database: An Explainer, provides more detail.

What you need from a time-series database

When choosing a time-series database, there are several key properties to consider:

  • Scalability: A good TSDB should be able to handle increasing volumes of data and query loads without significant performance degradation.

  • Maintainability: The database should be easy to manage, update, and troubleshoot. It should include features like automated backups and archiving.

  • Reliability: Many users of TSDBs are building new systems from scratch, so having the data when needed is crucial for success.

  • Usability: The database should offer a powerful and intuitive query language that allows users to easily retrieve and analyze time-series data without adding a new language that the developers have to learn and become proficient with.

AWS Time-Series Database Options

Several options are available for time-series database solutions on AWS. These can be broadly categorized into AWS-native solutions and third-party options that can be deployed on AWS infrastructure. Let's explore some of the key options.

Amazon Timestream is AWS's purpose-built time-series database service. It comes in several flavors, depending on your needs, which we’ll cover below.

You can also use Amazon RDS or Amazon Aurora, although they were not built specifically for time-series data. RDS offers typical relational databases, while Aurora offers Amazon’s proprietary versions of MySQL and PostgreSQL with a serverless option available.

Timescale, built on AWS infrastructure, offers another option. It is a full time-series database solution based on PostgreSQL, so you get TSDB performance with the familiarity of PostgreSQL.

AWS solutions

AWS Timestream

Amazon Timestream is AWS's purpose-built time-series database service. It offers two variants: Timestream for LiveAnalytics and Timestream for InfluxDB.

Timestream for LiveAnalytics is Amazon’s proprietary TSDB. The database falls under their serverless offerings, which means it will automatically scale up and down based on performance requirements. It also offers the standard 99.99 percent uptime guarantee that many AWS services do. 

However, the service has some significant limitations, including limited SQL support, specifically the inability to do joins. Additionally, it is a proprietary solution, which means the service is only available on AWS and has no community development.

Timestream for InfluxDB is based on the open-source implementation of InfluxDB, currently compatible with the 2.7 InfluxDB service. The service is fully managed by AWS, meaning you don’t need to worry about installation and some administration tasks. Timestream for InfluxDB is also beholden to the same problems that running InfluxDB on your own is. We’ve written about some of what InfluxDB has gotten wrong over the years, but to name a few: two backend rewrites, two major API changes, and a multiplying product catalog of similarly named services causing confusion.

RDS

RDS is Amazon’s basic database service. It offers several different engines, such as MySQL, PostgreSQL, and Oracle. It does not offer specific TSDB features, but you can leverage open-source options such as the pg_partman PostgreSQL extension to assist with partitioning the time-series data.

This level of flexibility is nice but also adds management and development overhead. You can find more open-source TSDB options in an article we recently published.

Amazon Aurora

Aurora is similar to RDS in that it provides MySQL and PostgreSQL-compatible databases. The difference is that Aurora offers more cloud-specific features, such as storage scaling, point-in-time recovery, and more.

While Aurora does provide a better administration experience, like RDS, it doesn’t offer any TSDB-specific features or capabilities. The added cost and capabilities may not exactly add up, as we explored in an earlier article: Benchmarking Amazon Aurora vs. PostgreSQL.

Timescale on AWS

Timescale offers a few products in the TSDB space: an open-source TSDB PostgreSQL extension that is free to use (TimescaleDB) and a fully managed solution that offers advanced features and support (Timescale Cloud, with TimescaleDB at its core).

TimescaleDB is built on top of PostgreSQL, which provides a familiar interface and features of PostgreSQL but adds a powerful TSDB over it. In several tests, we’ve observed Timescale surpassing InfluxDB with time-series data. Timescale supports columnar compression for even more efficient data storage, ultimately saving time and money on storage and data transfer.

Conclusion

Time-series databases have become critical tools for teams dealing with large volumes of time-series data. As we've seen, they offer high-performance solutions specifically designed to handle the unique challenges of time series data, such as high write throughput, efficient storage, and optimized time-based queries. There are a lot of choices in the ecosystem for TSDBs, with the information above, you should be well-equipped to make the decision best for you and your organization.

You can host all types of PostgreSQL workloads in Timescale. But especially if you have time-series data, Timescale will suit you better than other AWS time-series databases. Plus, by choosing Timescale Cloud, you’ll enjoy the following benefits:

  • Our mature cloud platform is supercharged PostgreSQL (simpler, faster, and more cost-effective). If you work with time-series data, you know how quickly your data will grow—avoid hitting that scalability wall, and definitely don’t be scared to pay for top performance every time you check your monthly bill.

  • Enhanced performance with less compute and storage resources, thanks to specialized optimizations tailored for time series and analytics workloads. For a 1 TB dataset with almost one billion rows, Timescale outperforms Amazon RDS for PostgreSQL, with up to 44 percent higher ingest rates and queries running up to 350x faster.

  • Substantial storage cost savings: our advanced compression algorithms enable a remarkable 90 percent reduction in disk storage. You can tier your older data to object storage built on S3 for an extra savings boost while remaining fully queryable.

  • Expert technical support is included in our pricing, ensuring you receive the assistance you need whenever you need it. Learn how we're revolutionizing hosted database support at no extra cost.

You can try Timescale Cloud for free for 30 days to see if it’s right for you: sign up and see for yourself.

On this page

    Try for free

    Start supercharging your PostgreSQL today.