Getting started with Timescale

Timescale extends PostgreSQL for all of your resource-intensive production workloads, so you can build faster, scale further, and stay under budget.

This guide shows you how to get started with a time-series database in Timescale. It steps you through creating your first Timescale service, adding some sample financial data to your database, helps you construct some queries to find out some interesting things about your data, and start using useful functions like continuous aggregates.

Timescale is a PostgreSQL data platform for time-series, events, and analytics. It gives you the reliability of PostgreSQL, the time-series superpowers of TimescaleDB, and the peace of mind of a fully managed service. It provides features like automatic backup and restore, high availability with replication, seamless scaling and resizing, and much more.

Timescale offers two products: a Time-series and Dynamic PostgreSQL database service. The time-series database is optimized for your time-series and analytics workloads. Dynamic PostgreSQL is built for all of other production database workloads. Both products have everything the Timescale data platform has to offer. This guide walks you through creating a time-series database.

Completing this guide should take you less than half an hour. As you go through the guide, you learn how to:

1. Create your first Timescale service
2. Connect to your service
3. Ingest some real financial data into your database
4. Construct some interesting queries Try out some live queries
5. Create and query a continuous aggregates

When you have finished this guide, you might want to check out some more advanced tutorials, or browse through the other guides.