Timescale Blog

Blog

Best Practices for Query Optimization on PostgreSQL

8 Dec 2023 8 min read

Explore the optimization of PostgreSQL queries using tactics such as efficient indexing and partitioning, and judicious use of data types.

Best Practices for Query Optimization on PostgreSQL

Tutorials & How-tos

How to Get Faster Aggregated Data in PostgreSQL

6 Dec 2023 12 min read

There are many ways to retrieve data aggregations, but not all will give you the speed and convenience you’re looking for—cue in continuous aggregates.

How to Get Faster Aggregated Data in PostgreSQL

The Ultimate Guide to Time-Series Analysis (With Examples and Applications)

5 Dec 2023 12 min read

Discover what time-series analysis is, how you should use it, and its challenges. Explore real-world examples and use cases of time series analysis.

Compression Faceoff: Postgres TOAST vs Timescale Compression

29 Nov 2023 10 min read

PostgreSQL TOAST vs. Timescale compression: read the comparison and learn why TOAST is not the most effective database compression mechanism.

Creating a Fast Time-Series Graph With Postgres Materialized Views

27 Nov 2023 7 min read

Build a time-series graph or plot to quickly visualize data using Postgres materialized views and their upgraded version, continuous aggregates.

What We Learned From Benchmarking Amazon Aurora PostgreSQL Serverless

22 Nov 2023 10 min read

Read about our journey benchmarking Amazon Aurora. Spoiler alert: 35% faster ingest, up to 16x faster queries, less than ½ the price, zero fuss.

Launch Weeks Review: Start, Scale, Stay With Postgres

21 Nov 2023 10 min read

An overview of everything we shipped in the past three launch weeks here at Timescale.

10 Things You Need to Know About Time-Series Data

20 Nov 2023 7 min read

From PostgreSQL pro tips and example projects to critical features and database evaluation criteria, we’ve rounded up an all-in-one guide of tips and recommended resources to help you do more with your time series or time-series-like data. 🎉

8 Performance Improvements in Recent TimescaleDB Releases for Faster Query Analytics

16 Nov 2023 5 min read

Learn more about eight recent performance improvements that will rev up your query analytics for time series, events, and analytics.

Teaching Postgres New Tricks: SIMD Vectorization for Faster Analytical Queries

15 Nov 2023 12 min read

Read how we supercharged Postgres with vectorization and Single Instruction, Multiple Data (SIMD) to set your analytical queries on fire.

Building Columnar Compression for Large PostgreSQL Databases

14 Nov 2023 24 min read

Read how we built a flexible, high-performance columnar compression mechanism for PostgreSQL to add scalability to our favorite database.

Scaling PostgreSQL for Cheap: Introducing Tiered Storage in Timescale

13 Nov 2023 13 min read

Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.

How We Designed a Resilient Vector Embedding Creation System for PostgreSQL Data

10 Nov 2023 11 min read

Learn the design decisions and trade-offs behind our system for creating and storing vector embeddings for data in PostgreSQL, PgVectorizer.

A Complete Guide to Creating and Storing Embeddings for PostgreSQL Data

10 Nov 2023 9 min read

Explore the power of vector embeddings and learn how to create and store them for PostgreSQL data using Python, LangChain, and Timescale Vector.

Top 8 PostgreSQL Extensions You Should Know About

Timescale x Cloudflare: Time Series From the Edge

9 Nov 2023 2 min read

Combine faster PostgreSQL for time series with an edge proxy that will turn your local databases into globally distributed ones. Meet Hypertables on Hyperdrive.

Create Timescale Services With the Timescale Terraform Provider

8 Nov 2023 7 min read

The Timescale Terraform provider hits 1.0 and is available for all production use. Learn how to use it.

Navigating a Usage-Based Model for PostgreSQL: Tips to Reduce Your Database Size

7 Nov 2023 11 min read

Usage-based models demand higher accountability for how you manage your data. Learn tips to reduce your Postgres database size.

Introducing Dynamic PostgreSQL: How We Are Evolving the Database to Help You Sleep at Night

6 Nov 2023 10 min read

No more overprovisioning to handle peak load or worrying about unpredictably high bills from serverless database deployments.

Boosting Postgres Performance With Prepared Statements and PgBouncer's Transaction Mode

3 Nov 2023 4 min read

You can now boost both your application’s and Postgres’ performance by using prepared statements and PgBouncer’s transaction mode. Learn how.

How We Scaled PostgreSQL to 350 TB+ (With 10B New Records/Day)

2 Nov 2023 13 min read

Read how we used Timescale to scale a 350 TB+ PostgreSQL database to build Insights, our new database observability tool.

Connection Pooling on Timescale, or Why PgBouncer Rocks

2 Nov 2023 8 min read

Scale database connections without consuming your compute resources: say hello to Timescale’s connection pooler, hosted PgBouncer.

Database Monitoring and Query Optimization: Introducing Insights on Timescale

1 Nov 2023 6 min read

Experience in-depth database monitoring with Insights. Optimize your query performance, including timings, memory, and disk usage.

New Timescale Enterprise Tier: A Solution for Mature Applications

31 Oct 2023 2 min read

Mature applications require a mature cloud platform. Introducing the new Timescale Enterprise Tier, designed for your demanding data and business needs.

Timescale is a mature PostgreSQL cloud, specialized for your demanding workloads.

Time series and analytics

Vector (AI/ML) Early access

Dynamic Postgres Early access

Industries that rely on us

Timescale benchmarks