Chris Travers - Timescale Blog

Products

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

Product Link

Time series and analytics

PostgreSQL, but faster. Built for lightning-fast ingest and querying of time-based data.

Product Link

Vector (AI/ML) Early access

PostgreSQL engineered for fast search with high recall on millions of vector embeddings.

Product Link

Dynamic Postgres Early access

PostgreSQL managed services with the benefits of serverless, but none of the problems.

Industries that rely on us
Crypto and finance Energy and environment Transportation and logistics

Timescale benchmarks
vs RDS vs Amazon Timestream vs Influx vs Cassandra vs MongoDB vs ClickHouse

We’re in your corner even during the trial phase. Contact us to discuss your use case with a Timescale technical expert.

Schedule a technical review Explore our Enterprise Tier
Customer Stories
Developers

Docs Tutorials Guides Blog Support Developers' newsletter PostgreSQL Cheat Sheet

Support
Community GitHub Slack Forum
Contribute
Contribute to code or Docs

Learn

Time-Series Database Basics
5 InfluxDB Alternatives for Your Time-Series Data InfluxQL, Flux, and SQL: Which Query Language Is Best? (With Cheatsheet) An Intro to Database Indexes in Postgres
Timescale & PostgreSQL
PostgreSQL Performance Tuning: How to Size Your Database When to Consider Postgres Partitioning Beyond the Basics: Exploring PostgreSQL Extensions

Building Blocks
Real-time Analytics in Postgres: Why It's Hard (and How to Solve It) More Time-Series Data Analysis, Less Lines of Code: Meet Hyperfunctions
Timescale Benchmarks
vs RDS vs Amazon Timestream vs Influx vs Cassandra vs MongoDB vs ClickHouse
Pricing

Contact us Login

Products

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

Product Link

Time series and analytics

PostgreSQL, but faster. Built for lightning-fast ingest and querying of time-based data.

Product Link

Vector (AI/ML) Early access

PostgreSQL engineered for fast search with high recall on millions of vector embeddings.

Product Link

Dynamic Postgres Early access

PostgreSQL managed services with the benefits of serverless, but none of the problems.

Industries that rely on us
Crypto and finance Energy and environment Transportation and logistics Crypto and finance

Timescale benchmarks
vs RDS vs Amazon Timestream vs Influx vs Cassandra vs MongoDB vs ClickHouse

We’re in your corner even during the trial phase. Contact us to discuss your use case with a Timescale technical expert.

Schedule a technical review Explore our Enterprise Tier
Customer Stories
Developers

Docs Tutorials Guides Blog Support Developers' newsletter PostgreSQL Cheat Sheet

Support
Community Github Slack Forum
Contribute
Contribute to code or Docs

Learn

Time-Series Database Basics
5 InfluxDB Alternatives for Your Time-Series Data InfluxQL, Flux, and SQL: Which Query Language Is Best? (With Cheatsheet) An Intro to Database Indexes in Postgres
Timescale & PostgreSQL
PostgreSQL Performance Tuning: How to Size Your Database When to Consider Postgres Partitioning Beyond the Basics: Exploring PostgreSQL Extensions

Building Blocks
Real-time Analytics in Postgres: Why It's Hard (and How to Solve It) More Time-Series Data Analysis, Less Lines of Code: Meet Hyperfunctions
Timescale Benchmarks
vs RDS vs Amazon Timestream vs Influx vs Cassandra vs MongoDB vs ClickHouse
Pricing
Contact us
Login
Try for free

Subscribe to the Timescale Newsletter

By submitting you acknowledge Timescale's Privacy Policy.

The Problem With Locks and PostgreSQL Partitioning (and How to Actually Fix It)

The Problem With Locks and PostgreSQL Partitioning (and How to Actually Fix It)

12 Oct 2023 10 min read

PostgreSQL locks can cause issues in partitioned tables. Read how TimescaleDB solves this using lock minimization strategies.

A PostgreSQL Developer’s Perspective: Five Interesting Patches From January’s Commitfest

A PostgreSQL Developer’s Perspective: Five Interesting Patches From January’s Commitfest

7 Mar 2023 6 min read

In this recap of January’s Commitfest, our PostgreSQL developer Chris Travers shares his thoughts on improvements to psql, software development with infinite values, transaction ID wraparound problems, and more.

A PostgreSQL Developer's Perspective: Six Interesting Patches From November's Commitfest

A PostgreSQL Developer's Perspective: Six Interesting Patches From November's Commitfest

11 Jan 2023 7 min read

From security to data encryption improvements, Chris Travers shares his PostgreSQL developer perspective on six of the latest commitfest patches.

A PostgreSQL Developer's Perspective: Five Interesting Patches From September's Commitfest

A PostgreSQL Developer's Perspective: Five Interesting Patches From September's Commitfest

2 Nov 2022 8 min read

Welcome to our new blog series! Every other month, Timescale’s developer advocate, Chris Travers, will use his PostgreSQL developer perspective to feel the pulse of the beloved database by looking into new commitfest patches.