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
PostgreSQL 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: Using PostGIS and Timescale for Advanced Geospatial InsightsPostgreSQL Extensions: Intro to uuid-osspPostgreSQL Extensions: Turning PostgreSQL Into a Vector Database With pgvector

Postgres extensions

Learn how to expand Postgres’ capabilities with its rich ecosystem of extensions.

PostgreSQL Extensions: Using PostGIS and Timescale for Advanced Geospatial Insights

Learn how you can how you can integrate a geospatial data setup to manage and manipulate geospatial and time-series data together.
Read more

PostgreSQL Extensions: Turning PostgreSQL Into a Vector Database With pgvector

Read more
A visual representation of a vector, represented in a graph.

PostgreSQL Extensions: Secure Your Time-Series Data With pgcrypto

Read more

PostgreSQL Extensions: Install pg_trgm for Data Matching

Read more

PostgreSQL Extensions: PL/pgSQL

Read more

PostgreSQL Extensions: Intro to uuid-ossp

Read more

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 Newsroom 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